Glad to help & thanks for the feedback.
Posts by Fluff13
-
-
If the values are numbers you can use COUNT rather than COUNTA, if the values are text use
=LOOKUP(2,1/(E2:E10<>""),E2:E10)
-
Ok, but as you have already got a working formula on ExcelForum, I'll step out.
You might also want to have a look at the rules, both here & on EF regarding cross posting.
-
If you have the dynamic array functions in G3 copied right
=INDEX(SORT(FILTER($A$2:$D$294,$B$2:$B$294=G2),4,-1),SEQUENCE(10))
-
If the table header is # then G3 will need to be '#
-
-
You need to move the check for A10 being empty, before you try to find the value in the data sheet.
-
You're welcome & thanks for the feedback.
-
Row 722 has a row height of 0, which is the cause of the discrepancy
-
Probably a different type of apostrophe.
What does =CODE(MID(A1,6,1)) return?
146, 39 or something else.
-
In that case can you please supply a sample workbook.
-
If the nickname is in column F why is the formula looking at column T?
-
You're welcome & thanks for the feedback.
-
How about
=MEDIAN(IF(($A$2:A$360=I2)*($B$2:B$360=J2)*($C$2:C$360=K2),$F$2:F$360))
May need CSE entry depending on your version of Excel.
-
-
You're welcome & thanks for the feedback.
-
I'm still none the wiser, about what you are trying to do, but as far as I know you cannot use Index on a jagged array the way you are trying to do.
-
In that case can you please supply a workbook, with your data & complete code.
-
-
Glad you sorted it & thanks for the feedback.