Microsoft Office Forums - View Single Post - Calculate the most recently entered data in columns?

Thread: Calculate the most recently entered data in columns?

View Single Post

Old

09-18-2017, 07:05 AM

mreynolds1775 mreynolds1775 is offline

mreynolds1775 is offline

mreynolds1775 uses Windows 10

Windows 10 mreynolds1775 uses Office 2013

mreynolds1775 uses Office 2013

Office 2013

Novice

The original poster

Join Date: Sep 2017

Posts: 12

mreynolds1775 is on a distinguished road

Default

Quote:

Originally Posted by xor

View Post

Maybe you like this one better?

haha...no idea what you did, but that appears to work great!

Can you explain to me what "RC" is for?

=AVERAGE(OFFSET(INDIRECT("RC"&COUNT($E3:$ZZ3)+4,0) ,,,,-3))

Reply With Quote