SHow only rows where once cell has data

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,
I have a spread sheet with a long list of physicans names. The columns following the names show the number of people they referred to my center, if any.

In a report I want to show ONLY those physicians who referred. In other words, if the number of referals column is 0 within a given range do not show the physician information, but if that column is greater then 0, then show all the data for that physician.

Thanks,

Mark

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
use autofilter with key in column 2 and criteria <>(not equal to) 0(zero). see help under "autofilter"
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month