srinidhi
Active Member
Hi All,
I have created my own tab in the ribbon, I use certain formulas very frequently. Insted of typing the same formula in different workbooks, I thought of creating the formulas & storing it in the the tab which I created .
Ex I use this formula : IF(SUMPRODUCT(($C$2:$C2=C2)*($C$2:$C2=C2))>1,0,1)to find out the unique text from a list of duplicate texts and this formula is used in different workbooks.
Is there any way of saving this formula to the tab created by me, only the columns may change, like instead of c it may be IF(SUMPRODUCT(($g$2:$g2=g2)*($f$2:$f2=f2))>1,0,1)
I have created my own tab in the ribbon, I use certain formulas very frequently. Insted of typing the same formula in different workbooks, I thought of creating the formulas & storing it in the the tab which I created .
Ex I use this formula : IF(SUMPRODUCT(($C$2:$C2=C2)*($C$2:$C2=C2))>1,0,1)to find out the unique text from a list of duplicate texts and this formula is used in different workbooks.
Is there any way of saving this formula to the tab created by me, only the columns may change, like instead of c it may be IF(SUMPRODUCT(($g$2:$g2=g2)*($f$2:$f2=f2))>1,0,1)
