Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populating Cells
In a downloaded excel report, the County name is in cell B1 with the list of
cities in C5 through C how ever many. Then another County name appears a few rows after that to start another batch of cities. Question is, I need the County name to apear in the cell before the city name cell. I do not want to cut and paste into it either. I am looking for an automated formula or something. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populating Cells
Need More Details, may be Sheet
Hardeep kanwar "rciolkosz" wrote: In a downloaded excel report, the County name is in cell B1 with the list of cities in C5 through C how ever many. Then another County name appears a few rows after that to start another batch of cities. Question is, I need the County name to apear in the cell before the city name cell. I do not want to cut and paste into it either. I am looking for an automated formula or something. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populating Cells
Basically the excel report is in cascading bullet format. I would like to
have all the information on each record line. current example: Cook County Chicago LaGrange looking for: Cook County Chicago Cook County LaGrange "Hardeep_kanwar" wrote: Need More Details, may be Sheet Hardeep kanwar "rciolkosz" wrote: In a downloaded excel report, the County name is in cell B1 with the list of cities in C5 through C how ever many. Then another County name appears a few rows after that to start another batch of cities. Question is, I need the County name to apear in the cell before the city name cell. I do not want to cut and paste into it either. I am looking for an automated formula or something. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populating Cells
Insert a new column C, so that your cities are now in D with your counties
remaining in B. In C2, use =IF(D2="","",IF(B1<"",B1,C1)), and copy down. -- David Biddulph "rciolkosz" wrote in message ... Basically the excel report is in cascading bullet format. I would like to have all the information on each record line. current example: Cook County Chicago LaGrange looking for: Cook County Chicago Cook County LaGrange "Hardeep_kanwar" wrote: Need More Details, may be Sheet Hardeep kanwar "rciolkosz" wrote: In a downloaded excel report, the County name is in cell B1 with the list of cities in C5 through C how ever many. Then another County name appears a few rows after that to start another batch of cities. Question is, I need the County name to apear in the cell before the city name cell. I do not want to cut and paste into it either. I am looking for an automated formula or something. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Randomly populating empty cells with other text cells | Excel Discussion (Misc queries) | |||
Help with auto populating cells. | Excel Worksheet Functions | |||
Populating Cells from One Worksheet to Another... | Excel Worksheet Functions | |||
populating multiple cells | Excel Worksheet Functions | |||
Populating several cells | Excel Worksheet Functions |