Hi,
I do not know VBA, but everywhere I search, it tells me this is a VBA function. I am trying to put an array into the formula bar of a dropdown list, but whenever I hit Ctrl+Shift+Enter, it just takes it as "Enter" and does not add the array brackets. The formula seems to be workin with a 1:1 relationship, I just need the options from the rest of the table (array). Can someone tell me if there is a way to type "array" into the formula or show me how to type this into VBA? Current formula reads:
=INDEX(SubforSub, SMALL(IF($R$2=SubConc, ROW(SubforSub)-MIN(ROW(SubforSub))+1, ""), ROW(A1)))
P.S. I'm using Excel 2007
I do not know VBA, but everywhere I search, it tells me this is a VBA function. I am trying to put an array into the formula bar of a dropdown list, but whenever I hit Ctrl+Shift+Enter, it just takes it as "Enter" and does not add the array brackets. The formula seems to be workin with a 1:1 relationship, I just need the options from the rest of the table (array). Can someone tell me if there is a way to type "array" into the formula or show me how to type this into VBA? Current formula reads:
=INDEX(SubforSub, SMALL(IF($R$2=SubConc, ROW(SubforSub)-MIN(ROW(SubforSub))+1, ""), ROW(A1)))
P.S. I'm using Excel 2007