Dear Vimal,
You need to sort the source data before applying the formula, else you need
to go for VB solution. Choice is urs. :)
After sorting, formula works fine and updated spreadsheet is also attached
herewith.
Humble suggestion:- Think about the future challenges and provide the
scenario(s
Hi Dilip,
Your formula Works fine only if the duplicate sales are continuos . if the
duplicate sales are not continuos then it is not working . for example in
the attached excel file there is a scenario in which it does nt work .
On Sun, Feb 7, 2010 at 10:00 PM, Dilip Pandey wrote:
> You are
You are always welcome Vimal...!!
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On 2/7/10, vimal barlota wrote:
>
> Thanks a lot . this is exactly wat i wanted . you saved my lot of manua
Thanks a lot . this is exactly wat i wanted . you saved my lot of manual
time . thanks a ton .
Cheers,
Vimal Barlota
On Sun, Feb 7, 2010 at 8:53 PM, Dilip Pandey wrote:
> Dear Vimal,
>
> Attached file has been formulated as per your requirement(s).
> Get back to me in case of any queries.
>
> T
Dear Vimal,
Attached file has been formulated as per your requirement(s).
Get back to me in case of any queries.
Thanks & Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B Com(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On 2/7/10, vimal barlota w
Hello Dilip,
Thanks a lot for taking time to answer my query .. i have another question
. hope i am not asking too much..after getting the top ten sales i need to
get their corresponding volume and pid . i can do this by using index and
match formula. but how to find volumes when the sales are s
Dear Vicky,
Solution is attached containing your scenario.
Revert back in case of any queries.
Best Regards
--
DILIP KUMAR PANDEY
MBA-HR,B Com(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On 2/3/10, vicky wrote:
>
> volume sales
> 1.13
hi check the attachment
On Wed, Feb 3, 2010 at 1:39 PM, vicky wrote:
> volume sales
> 1.13 2423
> 1.532423
> 2.92 33243
> 1.47 3243
> 1.49 234234
> 1.35 343423
> 3.45 32423
>
>
> i need top ten sales values for volume > 1 and volume < 2
>
> --
>
> -
volume sales
1.13 2423
1.532423
2.92 33243
1.47 3243
1.49 234234
1.35 343423
3.45 32423
i need top ten sales values for volume > 1 and volume < 2
--
--
Some important links for
