| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine if
Can you sort on col A-E?
If yes, then you can sort and then enter the formula =F1&F2 assuming F1 and F2 are in the right order after sorting in G1 and then copy to G3,G5,,, Paste special as values... delete rows with blank col G then delete col F ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "TLAngelo" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine if
I think I see what you are saying. I was hoping there was a way to not have
to do it all manually each time... my spreadsheet is 1657 rows and there are quite a few rows that need the title combined. Tania "Sheeloo" wrote: Can you sort on col A-E? If yes, then you can sort and then enter the formula =F1&F2 assuming F1 and F2 are in the right order after sorting in G1 and then copy to G3,G5,,, Paste special as values... delete rows with blank col G then delete col F ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "TLAngelo" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combine if
You can record a macro while doing it and rerun it everytime...
If you can logically think of any way this can be done then we can try to come up with a formula... If row difference is constant etc... Also in Excel you can not refer to the cell containing the formula... ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "TLAngelo" wrote: I think I see what you are saying. I was hoping there was a way to not have to do it all manually each time... my spreadsheet is 1657 rows and there are quite a few rows that need the title combined. Tania "Sheeloo" wrote: Can you sort on col A-E? If yes, then you can sort and then enter the formula =F1&F2 assuming F1 and F2 are in the right order after sorting in G1 and then copy to G3,G5,,, Paste special as values... delete rows with blank col G then delete col F ------------------------------------- Pl. click ''''Yes'''' if this was helpful... "TLAngelo" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine cells with the same reference and combine quantities | Excel Discussion (Misc queries) | |||
| combine or if | Excel Worksheet Functions | |||
| how to combine........ | Excel Discussion (Misc queries) | |||
| How Can i combine | Excel Discussion (Misc queries) | |||
| Combine into one please. | Excel Worksheet Functions | |||
Linear Mode
