Previous Topic Next Topic

SHow only rows where once cell has data

Closed
Mark - Dec 29, 2009 at 02:40 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 29, 2009 at 07:38 PM
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 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 29, 2009 at 07:38 PM
use autofilter with key in column 2 and criteria <>(not equal to) 0(zero). see help under "autofilter"
1

Similar discussions

Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response
How To Fix Mint Mobile Data Not Working?
sachin327 -
joshitha -

2 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
AMD data change update new data to DMI
Luis -
dwebb -

1 response