would like to combine info. fr different location on a list

[Bklynhyc]

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?

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

 

[Bklynhyc]

I dont get one and two

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[Don Guillett]

Not rocket science.
1.On your file>insert a worksheet and copy/paste this msg to that sheet
2. In the subject of your email use the same subject shown here and tell me
the name of the newsgroup you posted to..