http://tinypic.com/r/w9wdqo/5
I want to know when the same customer buys at different stores on the same date. I used an if formula as follows but it didn't seem to work:
=IF(A2=A3&D2=D3,IF(C2=C3,"","X"),"")
Any advice/help is much appreciated. Thanks.
Hi all,
I wouldn't call myself proficient in Excel but I'm familiar with basic formulas, filters, conditional formatting, etc. This dataset that I'm trying to analyze (picture) has a structure that I'm trying to manipulate to make it easier to analyze.
i'm trying to calculate the average...