MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Help With Formulas


Posted by Brian on December 19, 2000 5:57 PM

I'm trying to come up a formula that will count how many
times a item number comes up by address. A2 thru A10 would
get a part number entered, B2 thru B10 would get an address
entered, Colum C would total how many times that part number
was shipped to that address.


Posted by Aladin Akyurek on December 20, 2000 12:20 AM

How about trying out the following, until someone comes up with something better:

C2 =A2&"."&B2 [ copy down as far as needed ]
D2 =C2
D3 =IF(ISNA(VLOOKUP(C3,$D$2:D2,1,0)),C3,"") [ copy down as far as needed ]
E2 =IF(LEN(D2)>0,COUNTIF(C:C,D2),"") [ copy down as far as needed ]

Aladin