Find next entry?

[Bebbspoke]

Hi Folks - - got a mental block going on.... please...
using the "Find & Search" - what is the instruction for "finding next" entry, in a single column which may have several k rows with only a very occasional (numeric) entry? Thank you.

 

[oldbrewer]

=match("blue",$a$1:$a$10000,0) will give you the row number of the first cell equaling "blue"...

 

[Bebbspoke]

Thanks oldb; - was after a simple find "next (column) entry" method - to search said col rapidly...?

 

[oldbrewer]

so do you want every row number where blue is found ?

 

[Bebbspoke]

Hi Oldbrewer - I require a method by which I can tab through a large but sparsely populated column to visually check entries & values...
I'm sure such a facility should be availabe...

 

[oldbrewer]

my post 4 trying to establish how many blues and will you look for (say) reds, yellows and pinks also.........