Excel Query

  Desert Andy 10:06 29 Jan 09
Locked

I have set up a row for a user to put in data. I want to have a cell at the bottom of the row which shows the last entry (the user can input a different quantity of data each time). Is there an easy way to display this data?

  VoG II 10:58 29 Jan 09

I'm a bot confused as to whether you mean rows or columns. The following formulas must be entered in a different row to where the data is entered.

To get the last numeric entry in row 1

=LOOKUP(9.99999999999999E+307,1:1)

To get the last text entry in row 1

=LOOKUP(REPT("z",255),1:1)

If you actually meant columns not rows then

=LOOKUP(9.99999999999999E+307,C:C)

gets the last numeric entry in column C and

=LOOKUP(REPT("z",255),C:C)

gets the last text entry.

This thread is now locked and can not be replied to.

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…