Function to filter out zero data

[vaishaks89]

Hi There,
My name is Vaishak, and this is my first post here in this forum.

I have an excel sheet that has customer names in the rows, followed by 2 columns which displays Available Hrs and Billed Hrs for the current and previous month.
Available Hrs Billed Hrs
Customer Name PM CM PM CM
ABC CORP 10 20 15 16
LIFE WISH 15 16 20 25
TRAVEL KING 0 0 0 0

I have this data in an excel sheet.

I want to populate the same data into another excel sheet, except that I don't want rows that have all those 4 columns empty.

Is there a formula that I can use to do this? Something like an if condition or some ready made formula. Since, this is a dynamic report, I cant use manual filters. I need to use some build in function in excel.

Can anyone please help me with this question.

Thanking you
Regards
Vaishak

 

[Nebu]

Hi:

One way of doing this is to create a helper column adding all your PM and CM columns and you create a pivot and filter the helper column for greater than 0

may something like this


Thanks

 

[Ashhu]

Hi Vaishak
Welcome to the forum.
Please chk Nebu's reply, if its not what you are looking for, then attach sample sheet, it will be easy for members to understand and give you effective solution.

-Ashwin

 

[vaishaks89]

OK. thanks. Give me some time. I will upload the excel file.