mbarbera83
New Member
- Joined
- Feb 17, 2015
- Messages
- 27
Hi all.
I am trying to create a list of products by brand, using the Index function with Small, but it seems that my data base is too big for the memory. when i index only to row 21, then it works, but when i take it to row 1500 which I need, i get an error
=IF(ROWS(E$3:E3)>E$2,"",INDEX($A$2:$A$21,SMALL(IF($B$2:$B$21=E$1,ROW($B$2:$B$21)-ROW($B$2)+1),ROWS(E$3:E3))))
is there any way to get around this?
<tbody>
</tbody>
<tbody>
</tbody>
I am trying to create a list of products by brand, using the Index function with Small, but it seems that my data base is too big for the memory. when i index only to row 21, then it works, but when i take it to row 1500 which I need, i get an error
=IF(ROWS(E$3:E3)>E$2,"",INDEX($A$2:$A$21,SMALL(IF($B$2:$B$21=E$1,ROW($B$2:$B$21)-ROW($B$2)+1),ROWS(E$3:E3))))
is there any way to get around this?
<tbody>
</tbody>
Product | Brand | Brand1 | Brand2 | ||
product1 | Brand1 | =count Brand1 in column B | =count Brand2 in column | ||
product2 | Brand2 | FUNCTION GOES HERE | |||
product3 | Brand1 | ||||
<tbody>
</tbody>