acummulating notes

[sunroyal]

Hello,

I am working on a productivity sheet that concatonates (vertically), 4
lines of notes at the top of a single page, from the horizontal notes
below. I want the notes at the top only to show the last row of notes,
each time a new set of notes is entered.

Ex. (notes at top) Jim Miller 555-4897
30 day lock - exp date 11/22/03
..250 hit for cash out refi
sent confirm to 555-4855


Ex. (cumulative notes) Jan Smithe 548-7878 548 2256 30 day...
Mark Rich 145-4565 fax 859-8686 60 d...
Jim Miller 555-4897 f 555-4855 30 day lo.....(etc.)

Anyone know how this is done...I'm stumped and on a deadline!!!


__________________
Thanks,

Lane

 

[Debra Dalgleish]

If the list of notes are in columns A, enter the following formulas in
cells A1:A4 --
=LOOKUP(REPT("z",255),A:A)
=LOOKUP(REPT("z",255),B:B)
=LOOKUP(REPT("z",255),C:C)
=LOOKUP(REPT("z",255),D)

This will return the last item in each column, so may not be appropriate
if there will be blank cells. You could work around this by typing some
filler text (e.g. N/A) in unused cells.