• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Using MAX to find date and using this in a formula to find what was updated last

A

ashl

Member
Hi,

Sorry, new question...

I've used the max formula referencing the 3 date columns in the 3 tables on different sheets of my workbook to find out the date of when the latest update was made.

Works great, now i want to somehow use this as a reference in a formula which will give me the serial number of what was last updated. In each worksheet, the colum header of the serial number is named differently for eg, sheet 1,Table 1; Serial Number, Sheet 2; Table 1; Serial Number 2 etc etc

Any ideas on how this can be done using no VBA or volatile formulas? I was thinking index and match but I'm not quite sure how to put it together.

Can anyone help please?

Thanks,
 
You must log in or register to reply here.
Back
Top