Ok, so this is a super-duper simplified version of my Excel table... but I'm not even sure how to phrase what I want to do without using pictures.
chartexample.jpg
Essentially I need a formula that will give me the result for the last column, give me the minimum "Due Date" where the "Part Number" is the same.
chartexample2.jpg
Since the pink rows are all for the same part number, I need the last column to be 1/31/12.
Any help?
Last edited by NBVC; 01-27-2012 at 03:06 PM.
You mean?
=MIN(IF($A$2:$A$100=$A2,$C$2:$C$100))
adjust ranges to suit and confirmed with CTRL+SHIFT+ENTER and copied down.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
No, that's just returning the min value for the whole column. I need the min value relative to each part number. Does that make sense?
Did you confirm with CTRL+SHIFT+ENTER so that you get { } brackets around the formula?
OMG it works! What does CTRL+SHIFT+ENTER do that ENTER doesn't? Have I been entering formulas incorrectly my whole life?
Thank you so much for your help!
It is a way to tell Excel that is is an Array Formula. See here about Array Formulas
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks