LinkBack URL
About LinkBacks
pedersenn 
Hi
I need help with a formula to count like in uploaded example.
Hi
I need help with a formula to count like in uploaded example.
In E4:copied downFormula:
=IF(COUNTIF($C$4:$C$15,$B4),MAX($E$3:$E3)+1,"")
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
It's about the end result. 5 in this case. Or should the count be put in the column exactly as you indicated in the example?
As in the example given, not just the final result.
TMR's formula does what I wanted.
For the whole column please try and copy down:For only the end result please try:Formula:=COUNT(MATCH(B$4:B4,C$4:C$15,0))Formula:=COUNT(MATCH(B4:B15,C4:C15,0))
You're welcome. Thanks for the rep.
Thanks for the feedback,
Good to hear that TMS's formula works as desired, but I don't understand your question.
My formula produces the expected result, as you indicated in column E. The formula of TMS uses this expected result.
@Hans: my formula replaced what was in column E. Column E was the expected result. I guess I could have put it in any column by changing the column letter, but I chose to put it in column E.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks