Pull out latest data from 2 different worksheet

Cybsss

Hi,

Happy new year everyone!

Im just wondering if it is possible to get the latest data from certain column, using max collect, my goal is to scan the 2 different sheet then get the latest data (SI No. Column) using the date of deposit column and Account column as reference

Please i need help.

Paul Newcome

You would just use a MAX/COLLECT/COLLECT.

=MAX(COLLECT(1st column set), COLLECT(2nd column set))

Paul Newcome

You would just use a MAX/COLLECT/COLLECT.

=MAX(COLLECT(1st column set), COLLECT(2nd column set))

Cybsss

so the formula would be..

MAX(COLLECT({SI COLUMN worksheet1}, {WORKSHEET1 date of deposit},⇐today(), {WORKSHEET1 account}, account@row),COLLECT({SI COLUMN worksheet2}, {WORKSHEET2 date of deposit},⇐today(), {WORKSHEET2 account}, account@row)

is this correct?

Ps im currently using mobile phone will try this tomorrow at work 😅

Paul Newcome

Looks about right. Just need to make sure you have <= instead of ⇐.

Cybsss

It worked!

thanks really for the help!

Paul Newcome

Happy to help. 👍️