Sorting is not necessary


--


Regards,


Peo Sjoblom



"DW" wrote in message
...
Ok, thanks........will this also work on a list that is not in any sort
order or does it have to be sorted?

Don

"Peo Sjoblom" wrote in message
...
It's this part

A1:A10=""

it's what is called an array formula, you can lookup array formula in
help

http://www.cpearson.com/excel/ArrayFormulas.aspx


--


Regards,


Peo Sjoblom



"DW" wrote in message
...
Thanks everyone....

Now, this might be a dumb question, but why the ctrl+shift + enter combo
to commit the formula?


Don