Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
would like to combine info. fr different location on a list
Hi,
wondering if it is possible to combine information that is located in various area of the list. abcd 1.merchant settlement date: 06/01/09 2.1234 3. sale amount 4.total 500.00 Ideally would like the combine to be 1234060109500.00 which may formulate as =A2&C1&C4 BUT in every batch of total the line vary. some time it has 7 lines some time it only have one. so with the new column on combine information when use for a continuation don't work. Is there a way base on the information on the above/below, and next to cell. Like if a number under merchant plus the date next to settlement date the number next to total . is this possible? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum up values from a list to a second location. | Excel Discussion (Misc queries) | |||
Functions that will move info to a different location in column | Excel Worksheet Functions | |||
question on links where info is added and cell location is wrong | Links and Linking in Excel | |||
combine multiple sheets, each sheet has info in different cells | Setting up and Configuration of Excel | |||
Is there a function that will return info of the cursor location? | Excel Worksheet Functions |