vijay.vizzu
Member
Dear All,
Can it possible to copy unique values to another sheet automatically? In my sheet i have entered countif formual to count unique values i.e =IF(COUNTIF($R$11:R11,R11)=1,1,). It works fine and put 1 on every single value, but now i need to create a formula in another sheet, that can automatically add the values to my sheet which has 1, I mean to say that in my sheet1, in column it has vendor names, which has repeated also. i have created a helper column and put 1 infront of that vendor by =IF(COUNTIF($R$11:R11,R11)=1,1,), when i will select 1 by autofilter, then it will display vendor names without repetitions. Now in another sheet, i just need a formula which will copy the vendor names which has 1 in helper column. It should automatically add everytime when the new vendor will add.
Thanks in advance.
Can it possible to copy unique values to another sheet automatically? In my sheet i have entered countif formual to count unique values i.e =IF(COUNTIF($R$11:R11,R11)=1,1,). It works fine and put 1 on every single value, but now i need to create a formula in another sheet, that can automatically add the values to my sheet which has 1, I mean to say that in my sheet1, in column it has vendor names, which has repeated also. i have created a helper column and put 1 infront of that vendor by =IF(COUNTIF($R$11:R11,R11)=1,1,), when i will select 1 by autofilter, then it will display vendor names without repetitions. Now in another sheet, i just need a formula which will copy the vendor names which has 1 in helper column. It should automatically add everytime when the new vendor will add.
Thanks in advance.
