Hi
I am looking to output the min value based on dates and also one other variable (named RN).
For example, multiple values will exist across dates and RN, I just need to pull out the min value. If there is only one RN, then I need that value. Also, if there are only 2 or 3 values and they are the same, I don't want to return anything.
I have explained in the attached.
Hoping someone can help me with this?
I suppose the table is sorted.
Try with a helper column
In E2 use the following formula and copy down
Formula:
Please Login or Register to view this content.
In F2 use the formula and copy down
Formula:Please Login or Register to view this content.
You can hide the column E.
See the file
perfect, thanks Jose!
I have one other question.
In Col L, I have the finishing position (1st, 2nd, 3rd or 4th).
If there is a "1st" against one of the values for the day, how can I skip the values and go straight to the next day?
I have explained in the attached.
I have managed to create a loop but unfortunately it is still not producing the required results? Does anyone have any ideas?
Please Login or Register to view this content.
Hi Jose,
I have sorted the table and inputted these formulas, however I do not get all of the results.
See attached on some sample data where I have highlighted in yellow the gaps.
Are you able to assist me with this please?
Try this array formula in E2, copied down:
=IF(COUNTIFS(A:A,A2,C:C,C2,D:D,D2)>1,"",IF(MIN(IF($A$2:$A$70=A2,IF($C$2:$C$70=C2,$D$2:$D$70)))=D2,D2,""))
Array Formulae are a little different from ordinary formulae in that they MUST be confirmed in the FIRST CELL ONLY by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. After that, the array can be dragged down as normal, to cover the desired range.
You will know the array is active when you see curly brackets { } - or "curly braces" for those of you in the USA, or "flower brackets" for those of you in India - appear around the outside of your formula. If you do not use CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.
Don't type the curly brackets yourself - it won't work...
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.
Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks