Returning the value in a corresponding cell that returns the largest number in Sheet Summary

Rylan Funk

I have been able to return the largest number for a specific day in the sheet summary using =LARGE(COLLECT([Profit]:[Profit], Date:Date, =Date#), 1) but I am having trouble returning the corresponding transaction number for the returned value of the above formula. I want to be able to return the transaction number in another line in the sheet summary.

Thanks in advance.

Leibel S

@Rylan Funk

Try the below, profit# should be a reference to the sheet summary field you mentioned in your comment

=index(collect(trans#:trans#, Date:Date, =Date#, [Profit]:[Profit], profit#),1)

Leibel S

@Rylan Funk

Try the below, profit# should be a reference to the sheet summary field you mentioned in your comment

=index(collect(trans#:trans#, Date:Date, =Date#, [Profit]:[Profit], profit#),1)

Rylan Funk

This works! Thank you so much @Leibel S.