link data in a column to one cell

B

Brian M

Is there a way to link one cell to a group of cells so that the information
input in the next corresponding cell of the group overides the information
showing in the linked cell, but will still keep the data in the columns.

Hope this make sense,

and cheers in advance

Regards

Brian m from sunny scotland
 
S

Sandy Mann

If you mean that you have a range of cells being progressively filled in and
you want the last entry to show in another cell then try:

=LOOKUP(1,1/(E12:E21<>""),E12:E21)

This will work if there are no gaps in the range, if there are gaps, (ie
spaces), then try:

=INDEX(E12:E21,MAX((E12:E21<>"")*(ROW(E12:E21)-ROW(E11))))

This is an array formual and must be entered with the Ctrl & Shift keys held
pressed while you press enter. If doen correctly then XL will put curly
bracres { } aroint the formula.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
B

Brian M

Thanks Sandy this was exactly what i was looking for and works the way i
hoped. Cheers for your help
 
S

Sandy Mann

You are very welcome. Thanks for letting us know that it was what you were
looking for.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top