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

SHow only rows where once cell has data
Tmobile data check - Guide
Transfer data from one excel worksheet to another automatically - Guide
Display two columns in data validation list but return only one - Guide
If cell contains specific text then return value in another cell ✓ - Excel Forum
Hosted app data ✓ - Google Chrome Forum

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"

Similar discussions

AMD data change update new data to DMI

Counting cells containing only numbers

Unlock safe folder without losing any data

How To Fix Mint Mobile Data Not Working?

help me to add particular cells

Similar discussions

Subscribe To Our Newsletter!