Excel Query

  Desert Andy 10:06 29 Jan 09

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


To get the last text entry in row 1


If you actually meant columns not rows then


gets the last numeric entry in column C and


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…