Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,501
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rank and return Names Karthik Excel Discussion (Misc queries) 5 January 29th 10 02:19 PM
Return Names From List DeeCee Excel Worksheet Functions 2 December 10th 09 08:36 PM
Return names which are repeated 5 times Gaurav[_4_] Excel Discussion (Misc queries) 2 December 18th 08 10:54 PM
return a list of names, from a large list of repeated names. The Fru Fru Excel Worksheet Functions 5 December 10th 08 01:03 PM
return all worksheet tab names and chart sheet tab names in report - an example DataFreakFromUtah Excel Programming 2 October 6th 04 08:09 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"