Hello,
Please help me with a formula to find the highest cumulative figures between a period of time
If date is between day X and Y find the highest cumulative figure.
Capture.jpg
Thank you
Dieter
Hello,
Please help me with a formula to find the highest cumulative figures between a period of time
If date is between day X and Y find the highest cumulative figure.
Capture.jpg
Thank you
Dieter
Hi
tryin H3 and drag down as needed. If you need to include begin and start date replace < with <= and > with >=Please Login or Register to view this content.
Please use this function with Ctrl+Shift+Enter
=IFERROR(LARGE(IF((($A$5:$A$28=G5)*($B$5:$B$28>=$H$3)*($B$5:$B$28<=$I$3))>0,$D$5:$D$28),1),0)
Please click 'Add reputation', if my answer helped you.
Thank You! Both variants works for me!
Hello,
I really appreciate your help.
I am using the formula above (Max(Index()) on a file with more then 10k rows, and extract data from 3 different workbooks with more then 60k rows.
Excel is very slow by using this formula. Is it not possible to use instead a vba code?
The file is updated on a daily basis.
Thank you,
Madi1004
I would suggest you start a new thread in the VBA forum then referring to this one. I'm astonished though that it's slow on 10 k rows.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks