Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 31
Default Combine if

I have a spreadsheet where column A has an object ID number and column F has
a title. I would like to combine the titles to make one title if the object
ID numbers are identical. Right now, if there are identical object ID
numbers the title will be contained in sections... for example the first
instance of object ID 139930096 has the first part of the title which is
"Section 3E" and the second instance of object ID 139930096 has the second
part of the title which is "entry wing shop & ESPIS"... it needs to be
"Section 3E entry wing shop & ESPIS". The data in columns B through E will
also be identical like column A, the only column that is different is F.

Is this as clear as mud?!

Thanks for your time,

Tania
 
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
Combine cells with the same reference and combine quantities brandon Excel Discussion (Misc queries) 2 September 17th 08 05:44 PM
combine or if littlelouise1 Excel Worksheet Functions 4 July 7th 08 09:26 PM
how to combine........ pathan Excel Discussion (Misc queries) 1 August 7th 06 09:39 AM
How Can i combine Monty Excel Discussion (Misc queries) 5 July 25th 06 09:28 PM
Combine into one please. Steved Excel Worksheet Functions 2 February 22nd 05 11:46 PM


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