hello, I'm very confused about my problem.
how can i get old price data with formula?
Annotation 2022-01-31 044043.png
Thank you for your help
hello, I'm very confused about my problem.
how can i get old price data with formula?
Annotation 2022-01-31 044043.png
Thank you for your help
Last edited by alkaform; 01-31-2022 at 09:59 AM.
One way....
Old: =INDEX($D:$D,AGGREGATE(14,6,ROW($D$5:$D$16)/($C$5:$C$16=$G6),2))
New: =INDEX($D:$D,AGGREGATE(14,6,ROW($D$5:$D$16)/($C$5:$C$16=$G6),1))
next time, please read the yellow banner (top) and attach an Excel sheet, not a non-editable picture of one.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thank you so much sir for helping my case . Im so sory, i will read the yellow banner now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks