Hi Neil,
Attched file is solved per your requirements.
Best Regards,
DILIPandey
On Sat, Dec 4, 2010 at 7:34 PM, neil johnson wrote:
> Hi Dilip,
>
> You grab my question, I need the second value of harmeet in the below cell.
>
>
>
>
> On Sat, Dec 4, 2010 at 3:19 PM, Dilip Pandey wrote:
>
>> Hi
Hi,
Try Sumproduct formula
Rgds
Vaibhavj
On Sun, Nov 28, 2010 at 2:06 PM, neil johnson wrote:
> Hi Everyone.
>
> I have large data in excel. for example in sheet 1. and we have name in
> sheet 2 . I use vlookup function and fetch the production using vlookup .
> now when i saw the total there i
Hi Dilip,
You grab my question, I need the second value of harmeet in the below cell.
On Sat, Dec 4, 2010 at 3:19 PM, Dilip Pandey wrote:
> Hi Neil,
>
> Yes, this can be done but I am not sure if you want the second value
> of harmeet in the below cell OR you want that to be add-up in the
> fi
Hi Neil,
Yes, this can be done but I am not sure if you want the second value
of harmeet in the below cell OR you want that to be add-up in the
first cell value.
Harmeet 100+1000
OR
Harmeet 100
1000
Best Regards,
DILIPandey
On 11/28/10, neil johnson wrote:
> Hi Everyone.
>
> I ha
7:23
Subject: Re: $$Excel-Macros$$ Queries
use sumif check the attachment see if it helps
On Sun, Nov 28, 2010 at 2:06 PM, neil johnson wrote:
> Hi Everyone.
>
> I have large data in excel. for example in sheet 1. and we have name in
> sheet 2 . I use vlookup function and fetch the
use sumif check the attachment see if it helps
On Sun, Nov 28, 2010 at 2:06 PM, neil johnson wrote:
> Hi Everyone.
>
> I have large data in excel. for example in sheet 1. and we have name in
> sheet 2 . I use vlookup function and fetch the production using vlookup .
> now when i saw the total th
Hi Everyone.
I have large data in excel. for example in sheet 1. and we have name in
sheet 2 . I use vlookup function and fetch the production using vlookup .
now when i saw the total there is difference between two . When i see in the
sheet 1 . there is duplicate name as well as value is differen
