ExcelBanter - Return names

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Return names (https://www.excelbanter.com/excel-programming/397315-re-return-names.html)

Mike H

Return names

Hi,

Try this in E1 and drag down:-

=IF(ISNUMBER(D1),A1,"")

Mike

"Ivica Lopar" wrote:

Hello to group

I heave in Column D numbers and text like 1, 2. 3, I, II, III, GD, Bo, Pd.In
column A are Names.
I wont in Column return Names that in Column D dont have numbers 1, 2, 3 is
that posiblle.

Thanks for any help

Best regards
Lopar

All times are GMT +1. The time now is 01:29 PM.