| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple rows with some dups where I need result on one line
I have the following cells A1:A4 and B1:B4 where I need the duplicates in
column B one time and the corresponding results from column A combined in one cell only once. I'm looking for this result: ANGIE BURBANK O0313, 01577, etc. - Thanks a bunch. 00313 ANGIE BURBANK 01577 ANGIE BURBANK 01537 ANGIE HOMA 01719 ANGIE HOMA |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple rows with some dups where I need result on one line
Do you want the "ANGIE BURBANK in one cell and the combined numbers in
another cell, or do you want it all in one cell? HTH Otto "VAN GOGH" wrote in message ... I have the following cells A1:A4 and B1:B4 where I need the duplicates in column B one time and the corresponding results from column A combined in one cell only once. I'm looking for this result: ANGIE BURBANK O0313, 01577, etc. - Thanks a bunch. 00313 ANGIE BURBANK 01577 ANGIE BURBANK 01537 ANGIE HOMA 01719 ANGIE HOMA |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
multiple rows with some dups where I need result on one line
Yes, ANGIE BURBANK IN ONE CELL AND THE COMBINED NUMBERS IN A SEPARATE CELL -
THANKS. "Otto Moehrbach" wrote: Do you want the "ANGIE BURBANK in one cell and the combined numbers in another cell, or do you want it all in one cell? HTH Otto "VAN GOGH" wrote in message ... I have the following cells A1:A4 and B1:B4 where I need the duplicates in column B one time and the corresponding results from column A combined in one cell only once. I'm looking for this result: ANGIE BURBANK O0313, 01577, etc. - Thanks a bunch. 00313 ANGIE BURBANK 01577 ANGIE BURBANK 01537 ANGIE HOMA 01719 ANGIE HOMA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding "and" to Spellnumber code | Excel Discussion (Misc queries) | |||
| Number format | Excel Discussion (Misc queries) | |||
| EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
| convert value in word. For Exampe Rs.115.00 convert into word as . | Excel Discussion (Misc queries) | |||
| Amount or Numbers in Words | New Users to Excel | |||
Linear Mode
