How do I Skip a Row if the Value is False

**coconnor** · 08-24-2012, 03:51 PM

Currently I have a spreadsheet that has a Working Tab and I need to get the data from there to the Report tab.
But I ONLY want the rows with a True Values on the Report
I have a column on the working tab that has the formula to decide it the row is True or False

I want it to skip all the false rows and only pull the True rows.

Tried to attach file but its too large

So basiclly I need it to look at A2 if False the look at A3 and so on until it finds a True then when it finds a True enter the value of of the next column over B?

Any help would be greatly appreciated.

**JBeaucaire** · 08-26-2012, 03:09 AM

I'm sure you can slim your workbook, perhaps by zipping it?

Or, slim it down by reducing the amount of sample data to just 10-20 rows.

**coconnor** · 08-27-2012, 07:40 AM

Attahced ZIP

**JBeaucaire** · 08-28-2012, 08:03 AM

I've changed your column A formula from TRUE/FALSE to one that gives each appropriate row a unique INDEX number.

Then on the Report sheet we draw over the first instance of each unique index number.

I've added a drop box in B1 so you could see the rows for either status.

C1 is required and shows the number of visible rows that should appear in the report.

**coconnor** · 08-28-2012, 09:27 AM

Thanks so much very helpful. Was I even close haha

**JBeaucaire** · 08-28-2012, 10:26 AM

No, you were not accomplishing the task as I understood it, I presume that is why you ask here. Many eyes, new ideas, and all that.

If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.