Excel Query

  Desert Andy 10:06 29 Jan 2009

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 2009

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.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?