Hi Friends,
I unable to count greater than value in filtered list. cell counting including hidden data.
I Attached excel for your reference.
Please help on this.
Thanks,
Sekar G
Hi Friends,
I unable to count greater than value in filtered list. cell counting including hidden data.
I Attached excel for your reference.
Please help on this.
Thanks,
Sekar G
Last edited by Sekar G; 03-27-2021 at 08:19 AM.
Try:Formula: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
In your column B click the dropdown button and use the "Number Filters" option and choose "Greater than...".
Yes. But I need based on column A. if using number filters, showing entire data including robert and praveen.
Thank you so much TMS. This is working fine. but formula looking entire column (A2 to XFD11) and getting slowness for large data. there is any option to restrict to work formula for till B column.
Last edited by Sekar G; 03-27-2021 at 06:17 AM.
No. The formula is ONLY looking at column B. Have you, by any chance, changed the ranges (red) to something excessively large?:
SUMPRODUCT(SUBTOTAL(3,OFFSET(B2,ROW(2:11)-2,))*(B2:B11>5))
Post the EXACT formula you are currently using. How many rows of data do you have?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
As Glenn says, it is only looking at column B. Change the 11 to reflect the number of rows of data.
Formula:Please Login or Register to view this content.
Becomes, for example:
Formula:Please Login or Register to view this content.
Thanks Glenn and TMS for clarifying. Now no problem. Thanks Again.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks