Hi guys,

Can someone please help me with a formula for the following task?

I have over 40,000 rows of data in ‘Table 1′, I’ve extracted a sample.

I need to analyse only cells which contain identical values in both ‘Product‘ and ‘Decrement‘ in ‘Table 1’. I have manually created a dataset in ‘Table 2′ which highlits the output I need.

Thanks in advance!! 

​ Hi guys, Can someone please help me with a formula for the following task? I have over 40,000 rows of data in ‘Table 1’, I’ve extracted a sample. I need to analyse only cells which contain identical values in both ‘Product’ and ‘Decrement’ in ‘Table 1’. I have manually created a dataset in ‘Table 2’ which highlits the output I need. Thanks in advance!!       Read More

​