$$Excel-Macros$$ help:increase the sheet number in a formula

2012-10-20 Thread Sundarvelan N
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

Re: $$Excel-Macros$$ help:increase the sheet number in a formula

2012-10-20 Thread ashish koul
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*