If cell = false, go to next cell?

[anakeimai]

Hi,

With the following list on Sheet1, on Sheet2 I want list only the Names that don't have a value next to them:

Aaron
Abigail 6
Alexander
Alina 24
Allan
Andrew 5
Ann

That sounds so easy to explain, but I am baffled as to how you can do it with a standard if function without getting the following type of result (this list could be up to 200 names - I only want ones that don't have a populated field next to them):

Aaron True
Abigail
Alexander True
Alina
Allan True
Ann

Can this be done with a groovy IF and INDEX formula, or is VBA (of which I have very limited skills) the only way to go?

In anticipation of your awesomenesses, my thanks,

A

[martindwilson]

http://www.excelforum.com/excel-gene...t-to-them.html

[sglife]

=if(isnumber(right(a1,1)*1),"",a1)

[rwgrietveld]

For this example the following would work as well:

=LEFT(A1;FIND(" ";A1&" ";1)-1)

Gr,
Ricardo

[martindwilson]

anyone not bother to read the link to the duplicate thread then?