B
Ben
I have the following table
N O P
1 Clothing Type Color Size
2 T-Shirt BL SM
3 Shorts BR 4
4 T-Shirt BK XL
5 T-Shirt GR XS
6 Pants RD 5
I have the following code in H2:H11
=IF(COUNTIF(INDEX($N$2:$P$7,0,1),$G$2)>ROW()-ROW($G$2),
INDEX($N$2:$P$7,SMALL(IF(INDEX($N$2:$P$7,0,1)=$G$2,
ROW($N$2:$P$7)-CELL("Row",$N$2:$P$7)+1),ROW()-ROW($G$2)
+1),3),"")
H2 Brings up the correct Option, but H3-H11 gives the
following error #NUM.
What do I need to fix?
Thanks Ben
N O P
1 Clothing Type Color Size
2 T-Shirt BL SM
3 Shorts BR 4
4 T-Shirt BK XL
5 T-Shirt GR XS
6 Pants RD 5
I have the following code in H2:H11
=IF(COUNTIF(INDEX($N$2:$P$7,0,1),$G$2)>ROW()-ROW($G$2),
INDEX($N$2:$P$7,SMALL(IF(INDEX($N$2:$P$7,0,1)=$G$2,
ROW($N$2:$P$7)-CELL("Row",$N$2:$P$7)+1),ROW()-ROW($G$2)
+1),3),"")
H2 Brings up the correct Option, but H3-H11 gives the
following error #NUM.
What do I need to fix?
Thanks Ben