Calculate the most recently entered data in columns?

		Microsoft Office Forums > Microsoft Excel > Excel
Calculate the most recently entered data in columns?

FAQ

Thread Tools

Display Modes

#10

09-18-2017, 11:07 PM

Pecoflyer

Windows 7 64bit Calculate the most recently entered data in columns?

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

Have a look here to understand this technique http://www.xldynamic.com/source/xld.LastValue.html
Be aware that OFFSET and INDIRECT are volatile functions

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting- Only format cells once data is entered	chart3	Excel Programming	1	12-15-2015 11:26 AM
Calculate amount of entered fields	sp1d3r69	Excel	3	01-26-2015 07:35 AM
calculate date if date entered in cell, do nothing if blank	ConfuddledOne	Excel	3	11-07-2014 09:37 AM
Compare columns + calculate difference	Inatic	Excel	1	01-27-2013 08:00 AM
Using data entered in prompt to search database table	BluRay	Word	1	03-25-2011 01:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:32 AM.