Obviously, we can use COUNTIF("TEXT",A1:A100) to count how many times a specific string appears within a range, but what if the range is user-defined or variable? In other words, how could a user choose if they want to search ONLY the top 10 (A1:A10), top 20 (A1:A20) etc?
Thanks!
Using E1 for the rows to include:
Please Login or Register to view this content.
Last edited by protonLeah; 01-04-2022 at 07:41 PM.
Ben Van Johnson
Mmmm, actually, it's =COUNTIF(A1:A100, "TEXT")
Some options:
=COUNTIF(A1:A100, "TEXT")
=COUNTIF(A1:INDEX(A:A,10), "TEXT")
=COUNTIF(A1:INDEX(A:A,MAX(D1,1)), "TEXT")
D1=5, say
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
Ah, just a bit too slow ...
protonLeah, Thank you so much! But please also share with me how you got to put all that extra text in E1. I wouldn't even know how to look that up!
UPDATE: Never mind, figured it out!
Last edited by CriticalMass048; 01-10-2022 at 01:56 PM.
I selected E1 and applied custom number format "count " # " rows"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks