Hi All,
Having a little bit of an issue figuring out a formula...
I am working on a database of airline costs and one of the fields I am looking to auto populate from the data table is number of suppliers. This works fine and am using the formula =SUM(IF(FREQUENCY(MATCH(B2:B10,B2:B10,0),MATCH(B2:B10,B2:B10,0))>0,1)) to do so. The issue is though I have another criteria for selection to add to this; that of office of use. We have 5 different offices (Glasgow, London etc...) and the number of suppliers for each office also has to be determined. Each line of data has an office code attached (GE for Glasgow, LE for London etc....)
I can do this manually by splitting each offices data up onto different sheets and then applying the above formula, but would rather have a formula that would do this automatically thus saving time. Was thinking it would be a case of nested IF statement but struggling to come up with the right answer. Any help with this would be greatly appreciated.
Joe
Bookmarks