Applying named range into a formula

[jw01]

Hi there,

i have a formula that lists unique names from my data sheet.

Please Login or Register  to view this content.

im trying to add my named range, and index formula so it auto picksup the correct column name and performs the same as the above formula

Please Login or Register  to view this content.

when i run this above formula, it just shows no data (blank). any idea if my input is wrong?

this is my formula for my named range
='Database results - Data'!$C$8:INDEX('Database results - Data'!$AX:$AX,ROW('Database results - Data'!$AX$8)-1+LET(A,'Database results - Data'!C:F,MAX(BYCOL(A,LAMBDA(x,COUNTA(x))))))

^this picks up the data from the header cell to the last active row in my datasheet.

thxs all.

[TMS]

You should know by now …

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

[TMS]

Comment: you seem to have a number of threads, though by no means all, that you have not marked as solved and/or provided feedback and/or followed up on the solutions offered. You might want to consider reviewing those threads.

[jw01]

thanks all. appreciate the feedback. was able to resolve it, realized i didnt lock in one of the cells to $a$5