Vidyut why don't you use a simple pivot table, it will do the trick.
On Tue, Aug 25, 2009 at 4:22 PM, vidyut more wrote:
> can i use this formula to another sheet extract data from another sheet.
>
>
> -- Forwarded message --
> From: Anish Shrivastava
> Date: Tue, Aug 25, 2009 a
Yea Vidyut,
You can use this formula to extract data from another sheet.. U just have to
changed the reference cells.
Lemme know if I can help u more on this..
Cheers!!
ANISH
On Tue, Aug 25, 2009 at 4:22 PM, vidyut more wrote:
> can i use this formula to another sheet extract data from anothe
Hi Vidyut,
Attached please find the worksheet wid formula. I just used Data Validation
to create the list of your Q.No. and used below formula.. Hope it Helps.
=SUMPRODUCT(($A$2:$A$211=$F$219)*($C$2:$C$211=G217)*($H$2:$H$211))
Cheers!!
ANISH
On Tue, Aug 25, 2009 at 2:23 PM, vidyut more wrote:
Hi Vidyut,
Solution is attached with this email. thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Aug 25, 2009 at 2:23 PM, vidyut more wrote:
> plz find attd. excel file. i want formula for pa
