Formula to select a cell that has a different value than the rest of the cells in that column

[jt145]

I have a simple three cell range W4:W6 two of the cells have the text "No task Id Found" and the other one has a number value such as "102345678".

i would like to be able to have a formula in a now empty Cell such as A1, that searches that small range and returns the one that doesn't have the text "No task Id Found"

But im banging my head on the wall with this one.

here is the "table" I have and the small range im trying to search through is the "Results:" Column

the reason for this is that some times the B column will have the 102345678 type number in it and some times the C could and even the A might but it will only ever be 1 column with it .

 

[Fluff]

Do you want to return the value of the cell, or the column it was found in?

 

[jt145]

Do you want to return the value of the cell, or the column it was found in?

To Return the value of the cell such as "102345678"

 

[Fluff]

Ok, how about

=FILTER(W4:W6,W4:W6<>"No task Id Found")

 

[jt145]

Ok, how about

=FILTER(W4:W6,W4:W6<>"No task Id Found")

Danng you are GOOD! THANKKKKS Mate!

 

[Fluff]

You're welcome & thanks for the feedback.