How to skip to cells which contain values only

  • Thread starter Thread starter Martin C
  • Start date Start date
M

Martin C

Not sure if this is possible in Excel.
I am using Excel 2003 SP2 at work. In a column, I have a formula that is
copied down the column so that if a condition is valid, it prints a "Y",
otherwise nothing:

eg '=IF(N5714>0.011,"Y","")

As the condition is true only some of the time in the column, it would be
nice to be able to skip down the column to the next occurrence of the "Y".

I know this is possible with CNTRL <down arrow>, but as each cell has a
formula in it which gives "" if the condition is false, using this key
stroke just goes to the last cell in the column.

Is there any way round this.

Thanks for any help you can provide.

Martin
 
As long as the cells have something in them the down arrow stuff won't work.

If you could convert the range to values, clear the cells that return "", then
you could do what you want. But then you'd be destroying your formulas.

Maybe you could take a different approach.
Select the column that contains that formula.
Data|Filter|autofilter
Then filter to show just the Y's (or what you want to see)
 
The filter looks the best way to go. Thanks for the reply. Typical 'wood for
the trees' scenario. I should have thought about filters myself.

Martin
 
Back
Top