Formulas

[Fishbone]

I have a very simple formula [=IF(A1="N", B1, "")] which works fine.
However, I need to filter my results as there are quite a few duplicat
results. Is there a way of usinf the advanced filter so that it read
the returned value from the formula, rather than the formula itself
I.e instead of it looking at =IF(A1="N", B1, ""), I want it to show th
value of B1 (which is text)

Thanks

 

[Frank Kabel]

Hi
one way would be using these fomulas, copy the range and
insert the values with 'Edit - Paste Special - bValues'.
Use this column for filtering

 

[Fishbone]

Thanks Frank


Worked a treat :-