LinkBack URL
About LinkBacks
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:
Please Login or Register to view this content.
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?
For the whole column please try and copy down:For only the end result please try:Formula:Please Login or Register to view this content.Formula:Please Login or Register to view this content.
As in the example given, not just the final result.
TMR's formula does what I wanted.
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