Hi,
I would like to know how I can make this formula to use two criteria:
I have tried this but it gives me a a "#SPILL" error:
I would like to know how I can make this formula to use two criteria:
VBA Code:
=IFERROR(INDEX(Vikta;SMALL(IF(Vikta[Grupper]=1;ROW(Vikta)-4);ROW(2:2));1);"")
I have tried this but it gives me a a "#SPILL" error:
VBA Code:
=IFERROR(INDEX(Vikta;SMALL(IF(AND(Vikta[Grupper]=1;Vikta[Grupp]=I3);RAD(Vikta)-4);RAD(1:1));1);"")