Hi All. I'm using Excel 2010 and I am used to using COUNT, COUNTIFS, AVERAGEIFS etc. but I'm stuggling with working out how to use MATCH and COUNTIFS. Obviously these may not be my best options so any help would be appreciated.
The problem is I have 3 colums of Data: A includes the date of a sale; B includes the Company if was sold to; C the Value of the sale. It centers upon finding out how many times a Company bought over different periods of time. I am trying to populate a second sheet. I have enclosed an example.
Many thanks in advance.
Bookmarks