#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 275
Default Column question

I was wondering if there is a function that can put multiple text in a field
if it is in one colunm and if it has the same number put it in that row.
Example.
A B c - Example
1 05919 OR-PCITY01 OR-PCITY02
2 05919 OR-PCITY02

Can I make it so that if it duplicated that it throws OR-PCITY02 in column
'C' like my example above.

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,836
Default Column question

I believe this will do what you want, but you have to sync up your data in
columns in a fashion similar to this sample:
http://www.freefilehosting.net/download/3f6jb


Regards,
Ryan---

--
RyGuy


"Anthony" wrote:

I was wondering if there is a function that can put multiple text in a field
if it is in one colunm and if it has the same number put it in that row.
Example.
A B c - Example
1 05919 OR-PCITY01 OR-PCITY02
2 05919 OR-PCITY02

Can I make it so that if it duplicated that it throws OR-PCITY02 in column
'C' like my example above.

Thanks

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
Column question... Ariana Excel Worksheet Functions 1 January 11th 08 03:19 PM
column autofill question JohnBee Excel Worksheet Functions 2 December 22nd 07 10:51 PM
Text To Column Question [email protected] Excel Discussion (Misc queries) 2 July 24th 07 07:58 AM
Question About Formula for 1 column FearFactory510 Excel Worksheet Functions 2 February 21st 07 03:35 PM
Sum at end of column question JEM New Users to Excel 1 February 7th 07 07:56 PM


All times are GMT +1. The time now is 06:55 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"