# 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 '#

Use Color, rather than ColorIndex

Code
1. .DisplayFormat.Interior.Color

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.

=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.

Hi & welcome to the board.

Code
1. Sub tmyflyte()
2. Dim UsdRws As Long
3. UsdRws = Range("U:U").Find("*", , xlValues, , xlByRows, xlPrevious, , , False).Row
4. If UsdRws > 9 Then Range("U9:AS" & UsdRws).Copy
5. End Sub

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.

Not entirely sure what your aim is, but you can retrieve certain columns from an array like

Code
1. Dim a As Variant, b As Variant
2. a = Range("A1:Z20").Value
3. b = Application.Index(a, Evaluate("row(1:" & UBound(a) & ")"), Array(2, 3, 4))

Glad you sorted it & thanks for the feedback.