Re: $$Excel-Macros$$ need help on finding the vales in attached sheet

2016-06-20 Thread Amit Basra
HI , not sure but have you tried using the value "true" in vlookup, might as well work out for you. sorry in advance i am not a pro at it just amateur. thanks & regars On Mon, Jun 20, 2016 at 4:59 PM, Paul Schreiner wrote: > It works fine on my file. > However, I

$$Excel-Macros$$ Fwd: Quality Analyst With Service Virtualization in CA Lisa@ Naperville, IL

2016-06-20 Thread Santosh kumar Nityo
Hi, Hope you doing Well !!! Here is our *Implementing partner **Requirement*, Please go through the below requirement and send us suitable consultant with their *updated resume, rates and Contact details ..* *Role: Quality Analyst With * *Service Virtualization in CA Lisa Location:

Re: $$Excel-Macros$$ need help on finding the vales in attached sheet

2016-06-20 Thread Paul Schreiner
It works fine on my file.However, I noticed in YOUR file, the Calculation option is set to "manual". (A "Calculate" reminder appears in the Status Bar.You have to hit an F9 to calculate. which means, when you copy the formula down the column, it retains the original value until you recalculate.

$$Excel-Macros$$ Hide/ Unhide raws which are blank

2016-06-20 Thread big smile
Hello Friends This sheet is the calculation of Accident policy of New India Ass Co Ltd I have to put the value in D column from D 10 to D 17 & then calculate the premium. My query is that for example I am putting the value in only some D coumun Ex -- D 10 + d 12 + d 14 the other raws