I am trying to extract the earliest and most price for a given set of products from a long data file. I have tried Min and Max functions which works where the price of the product has increased over time, but does not work where the price has dropped. I have over 7,000 lines of data and do not want to pull out the prices manually using filters. I attach an extract of the dataset so you can see what I trying to do.
Thanks
Hi rsecomak
Try with these two formula
1) =MIN(IF($A$2:$A$26=E2;$C$2:$C$26))
2) =MAX(IF($A$2:$A$26=E2;$C$2:$C$26))
Both of these are Arrays Formula. Not just Enter, but Ctr+Shift+Enter
Hope to helps you.
Because of Forum problems, i am not able to upload a sample workbook!!!!!!!!!!
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
..And this is the sample workbook...
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
hi rsecomak, welcome to the Excelforum, longer formula option but without using array formulas, please check attachment
Thanks - Fotis - max and min worked for some but not all parts.
Hi Watersev - this worked - got the prices as required. Brill
Glad to found your solution.
But, Just out of curiosity, what does not work correctly in my formula?
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks