Home |
Search |
Today's Posts |
#1
|
|||
|
|||
First column that does not contain "Cucumber"
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 |
#2
|
|||
|
|||
one way
Sub findnot() For Each c In Range("c6:g6") If ucase(c) < "CUCUMBER" Then MsgBox c.Column: Exit Sub Next End Sub -- Don Guillett SalesAid Software "umop apisdn" wrote in message ... 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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) | |||
Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
how to fit my column unmoved eventhough i scroll down? | New Users to Excel | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |