Hi
for a formula approach try something like the following array formula
(entered with CTRL+SHIFT+ENTER):
=MIN(IF(A1:X100="Cucumber",COLUMN(A1:X100))

--
Regards
Frank Kabel
Frankfurt, Germany


umop apisdn wrote:
Hi,

I have 100 columns. How do I find the first column that does not
contain any cell with the value "Cucumber".

Thanks for any help,

Rob