Formula Please

I have lots of different entries in column A. What I need is in say column C see enter that entry and in column D next to it how many times it appears in coulumn A e.g C2 dazwm D2 it appears 18 times in column A. Thanks.


  interzone55 21:24 04 Apr 2009

D1=COUNT(A:A,C1) should do the trick

  bstb3 00:25 05 Apr 2009

what alan14 says, but use COUNTIF, not COUNT ;)

  ronalddonald 06:35 05 Apr 2009

this for excel or something else not very clear. or some other software program

  interzone55 09:04 05 Apr 2009

well spotted...

ronalddonald - it should work in most spreadsheets, it's a pretty standard formula...

That doesn't seem to work all that happens is zeros. BTW excel.

  VoG II 15:12 05 Apr 2009

D2 should be


That has zero too.

  VoG II 15:29 05 Apr 2009

Make sure that C2 contains exactly what you want to count in column A. Check for leading or trailing spaces in C2 and in column A.

Sorry I don't understand. I have loads of different names in column A and nothing else on the spreadsheet. In column C I want it to find a name and in the cell next to it put how many times it appears in column A.

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

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Microsoft Paint set to die after 32 years

Mac power user tips and hidden tricks

Comment désactiver la saisie intuitive et paramétrer votre clavier ?