An easy way is just to apply autofilter to that column and select Non-
blanks from the filter pull-down.

Hope this helps.

Pete

On Aug 18, 9:53*am, Custard Tart wrote:
I'm using VLOOKUP to import data from a pivot table. Currently I have
set it up so that VLOOKUP uses the row names and the count with an IF
forumla to import anything above a count of 12. I have the following
formula:

IF=('[Alarm log.xlsx]Aug'I$B:$V=12,'[Alarm log.xslx]Aug'I'$B,"")

This is working perfectly BUT instead of bringing over data which
looks like this:

ROW NAME COUNT
ROW NAME COUNT
ROW NAME COUNT

It is bringing over data which looks like this:

ROW NAME COUNT
BLANK LINE (because it does not meet criteria)
ROW NAME COUNT
ROW NAME COUNT

I would like it to NOT insert the blank line i.e. completely ignore
data which does not meet its criteria.

Any help appreciated!