Conditional Worksheet Formula

M

Marie

Is there a way I can write a formula that outputs desired results on a
separate worksheet within a workbook, without showing a bunch of blank rows
for undesired results? For example:

Data is in Sheet1
Sheet2 will display output of only the rows in Sheet1 that meet desired
condition (display all rows of data from Sheet1 where Column F = 'yes').
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Worksheet Fomatting 3
conditional display of certain rows 4
Can you display entire rows that match a certain criteria... 1
Using countif with multiple criteria 0
loop to copy paste 5
Compare two different workbook sheet to show the difference in text 0
Macro to change referenced column to the next one 1
Does the order of worksheets matter ? 1

Top