Using arrays or range in IF function - HELP PLS

G

Guest

I have a workbook with 2 worksheets. Wksht 1 = Checklist, Wksht 2 = Completion.

In cloumn A (Wksht1) I have a list of Y or N for range A2:A14 and column B
is a range of Items. eg:

COL A COL B
Y LOCAL
Y HIGHWAYS
N MINING
Y DRAINAGE

In column A (wrksht 2) I have the following formula:

=IF(Checklist!A2= "Y",Checklist!B2," ")
I then copied this down the column to othe rows

Where the logical test is true I do get the correct value from col B
but if the logical test is false then I just get a blank line.

How do I get rid of the blanklines and end up with just the 'true' values.
 
B

Bernard Liengme

You could take the result (with blank rows), use Copy followed by Paste
Special->Values to change formulas to values. Then use Sort.
Without knowing more of the purpose I cannot make any suggestion
best wishes
 

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

IF formula help? 5
count a value in a date range based on a date in another workshee. 4
calculate total items meeting criteria in range with multiple shee 2
Problem with a Array formula, Please help !! 6
If or index formula help 2
IF Statements and multiple columns 4
worksheet function in event macro 3
Matching Date From Two Groups 3

Top