Excel query-offset/data validation

[Gaurang Mhatre]

Hi Friends,

I have query in offset formula. i have attached sheet for your reference.
Just wanted to know whether offset formula is applicable for my query.

Thanks in advance for taking out your time.

Regards,
Gaurang M

 

[azumi]

Hope it works, pls see the file attach.....

Regards

 

[Gaurang Mhatre]

hey Azumi,

Excellent!!!....its working ...

But i have not understood the formula u have used.


God Bless.!!
Regards,
GAURANG