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.
-This is my Greek whisper to Europe.
--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.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
..And this is the sample workbook...
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks