We help IT Professionals succeed at work.

excel list if = 0 then don't add to list

cdb424ttm
cdb424ttm asked
on
I have excel list, which I have times and totals. What I'm looking to do is create a formula that will go down the list and  and as long as there are hours list the time and the amount.
like 12:00 am      11
12:30    14
Won't list 1:00 am because the count is 0.
Any thought on this?
12:00:00 AM      11
12:30:00 AM      9
1:00:00 AM      0
1:30:00 AM      7
2:00:00 AM      3
Comment
Watch Question

Commented:
create a pivot table on your raw data and add a filter on count to exclude 0's
Solutions Consultant
Commented:
Another option would be to use a filter on the list, it would quick and easy and provide what you have asked for

Michael

Author

Commented:
That works for me thanks