Array Help

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top