Ankur, You are welcome..!!
Let me know if you face any difficulty.
Thanks & Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Wed, Jan 13, 2010 at 3:57 PM, ankur wrote:
> Thanks Dilip Sir
>
> n
Thanks Ankur,
Explanation of Offset function:-
=OFFSET(Sheet1!$F$1,0,0,COUNTA(Sheet1!$F:$F),COUNTA(Sheet1!$1:$1))
In the above formula, last two COUNTAs are increasing the range downwards
and toward right. So ultimately the range is increasing from F1 to left,
till row 1 has data and to down, ti
Dear bas001,
You are welcome..!!
Let me know if you face any challenge in implementing the same in your
solution.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Wed, Jan 13, 2010 at 1:00 AM,
hi Dilip Sir,
Very Good Use of Offset Function,
Can You Please Explain How this work here.
On 1/12/10, Dilip Pandey wrote:
> Hi,
>
> Using Offset function, this task can be done.
> I have attached a sample file in which new added columns will automatically
> get covered in the lookup name bein
Hi,
Using Offset function, this task can be done.
I have attached a sample file in which new added columns will automatically
get covered in the lookup name being used.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
