LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 57
Default Source and Destination

Hi, all,
I would like a formula to do the following;
SOURCE DESTINATION
101 102
102 C 105
102 108
104
105 S
106
107
108 S

The source column A numbers run consecutively from 101-216. I just want any
column B source cell that has a C or S to have its 3 digit number appear
in destination column A. What formula do I use?
Thanks,
Malcolm



 
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
Source and Destination worksheet difference Malcolm Excel Worksheet Functions 5 May 31st 10 12:16 AM
How can I insert a row in a source that links to a destination Bob Excel Worksheet Functions 1 December 12th 08 07:45 AM
Paste names from a source workbook to a destination kerfloo Excel Discussion (Misc queries) 0 January 31st 08 04:55 PM
Data Validation source = destination? andy62 Excel Worksheet Functions 7 December 4th 07 11:10 PM
updating destination when I add a line to my source workbook mygrandmashousecat Excel Worksheet Functions 1 May 22nd 07 08:00 PM


All times are GMT +1. The time now is 06:43 AM.

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

About Us

"It's about Microsoft Excel"