How to skip to cells which contain values only

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Martin C - 26 Sep 2007 13:51 GMT

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

Reply to this Message

Dave Peterson - 26 Sep 2007 15:17 GMT

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)

> 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
[quoted text clipped - 15 lines]
>
> Martin

Signature

Dave Peterson

Reply to this Message

Martin C - 27 Sep 2007 08:43 GMT

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

> As long as the cells have something in them the down arrow stuff won't
> work.
[quoted text clipped - 28 lines]
>>
>> Martin

Reply to this Message

Rate this thread: