hi all. hope anyone has an answer for this particular matter
suppose in range a1 thru a10 there are elements (product names) that repeat in a random fashion and in range b1 thru b10 there are numeric elements that correspond to each product name in the prior mentioned range
i added this 2 column array formula in cell c1 which allows me to 'extract' specific product name with its correlated numeric values...
=if(a1:a10="product name",choose({1,2},a1:a10,b1:b10),"")
how could i add in the output of the first column, (the product name) resulting from the array formula,...the inclusion (maybe thru the & operator) of the corresponding ocurrance number of each name (like item1, item 2, item3, etc)???
thanks so much for your help
if youd like to see the spreadsheet let me know the sharesite url, and ill be glad to oblige
suppose in range a1 thru a10 there are elements (product names) that repeat in a random fashion and in range b1 thru b10 there are numeric elements that correspond to each product name in the prior mentioned range
i added this 2 column array formula in cell c1 which allows me to 'extract' specific product name with its correlated numeric values...
=if(a1:a10="product name",choose({1,2},a1:a10,b1:b10),"")
how could i add in the output of the first column, (the product name) resulting from the array formula,...the inclusion (maybe thru the & operator) of the corresponding ocurrance number of each name (like item1, item 2, item3, etc)???
thanks so much for your help
if youd like to see the spreadsheet let me know the sharesite url, and ill be glad to oblige