I have different sales offices in sheet1 column E E2 thru E8
I have revision numbers in sheet1 column I I2 thru I8
Data as follows
E2=NF I2=emptycell
E3=DP I3=40619
E4=DP I4=emptycell
E5=NU I5=emptycell
E6=DP I6=40609
E7=DP I7=emptycell
E8=SF I8=40618
Sheet2 column A are my offices
A2=DP
A3=NU
A4=SF
A5=NF
In sheet2 column c I need excel to enter a number to indicate how many times an office gets a revision number. Correct answers for above example should be DP=2 NU=0 SF=1 NF=0. But I cannot seem to get the formula right. I keep getting #NUM or # VALUE and so on. Would appreciate any help thank you.
Todd
Bookmarks