Hi Gurus,
Please help me in this formula
increase the sheet number in formula
=IF(IF(ISNUMBER(SEARCH(C$2,*Sheet1*!$B1)),TRUE,0)=TRUE,TRIM(RIGHT(*
Sheet1*!$B1,LEN(*Sheet1*!$B1)-FIND(:,SUBSTITUTE(*Sheet1*!$B1, ,:,LEN(*
Sheet1*!$B1)-LEN(SUBSTITUTE(*Sheet1*!$B1, ,)),0)
I would like to increase
can u share excel file
On Sat, Oct 20, 2012 at 12:24 PM, Sundarvelan N nsund...@gmail.com wrote:
Hi Gurus,
Please help me in this formula
increase the sheet number in formula
=IF(IF(ISNUMBER(can u share SEARCH(C$2,*Sheet1*
!$B1)),TRUE,0)=TRUE,TRIM(RIGHT(*Sheet1*!$B1,LEN(*Sheet1*