Returning the value in a corresponding cell that returns the largest number in Sheet Summary
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.
Help Article Resources
Check out the Formula Handbook template!