Macro, Formula?

  steviegee 13:32 16 Mar 2010
Locked

I have a spreadsheet that has thousands of different cells with info in. Is there a macro/formula that I can run which will put an entry and how many times it appears on the spreadsheet. (Pivot table will not work too many entries)

  VoG II 14:40 16 Mar 2010

Not sure that I know what you mean.

=COUNTIF(E1:H10,1)

will count how many cells in the range E1 to H10 contain 1.

  steviegee 14:57 16 Mar 2010

I have loads of different numbers everywhere on the sheet i.e ABC1234, ABC4567 and so on. At the bottom of the spreadsheet I want a macro/formula that will count up all the ABC1234 and ABC4567 and tell me how many times each one appears on the sheet. Or maybe list them all on sheet 2.

  VoG II 15:02 16 Mar 2010

So maybe make a list of the codes in another sheet and use a formula like

=COUNTIF(Sheet5!A1:D100,A1)

where A1 contains ABC1234

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

HP’s new Surface Pro rival is designed specifically for Adobe-using designers and artists

Best kids apps for iPhone & iPad

Que faire si son iPhone ou iPad est tombé dans de l'eau ?