Victtor
Board Regular
- Joined
- Jan 4, 2007
- Messages
- 170
- Office Version
- 365
- Platform
- Windows
original formula in another worksheet (works properly):
=ARRAY_CONSTRAIN(ARRAYFORMULA(IF(I24="","",INDEX($P$4:$P$104,SMALL(IF($Q$4:$Q$104=L24,ROW($Q$4:$Q$104)-ROW($Q$4)+1),COUNTIF($L$24:L24,L24))))), 1, 1)
I copied and pasted into another worksheet (as soon as I did this, it gave me a #NAME? error) then I changed the cell references to the new sheet (still #NAME? error):
=ARRAY_CONSTRAIN(ARRAYFORMULA(IF(M5="","",INDEX($C$5:$C$157,SMALL(IF($K$5:$K$157=M5,ROW($K$5:$K$157)-ROW($K$5)+1),COUNTIF($K$5:K5,K5))))), 1, 1)
Please help. Could it be different versions of excel?
=ARRAY_CONSTRAIN(ARRAYFORMULA(IF(I24="","",INDEX($P$4:$P$104,SMALL(IF($Q$4:$Q$104=L24,ROW($Q$4:$Q$104)-ROW($Q$4)+1),COUNTIF($L$24:L24,L24))))), 1, 1)
I copied and pasted into another worksheet (as soon as I did this, it gave me a #NAME? error) then I changed the cell references to the new sheet (still #NAME? error):
=ARRAY_CONSTRAIN(ARRAYFORMULA(IF(M5="","",INDEX($C$5:$C$157,SMALL(IF($K$5:$K$157=M5,ROW($K$5:$K$157)-ROW($K$5)+1),COUNTIF($K$5:K5,K5))))), 1, 1)
Please help. Could it be different versions of excel?