*Hello Prince*
*
*
*This is also working fine with a small changes in the cell's address as
follows :-*
*
*
in Column C
=A2&B2drag it up to* C11*
in Column D
=COUNTIF($C$2:$C2,C2) Drag it up to *D11*
Now in Cell *B12* I Wrote : =SUM((B2:B11)*(D2:D11=1)) with Ctrl+Shift+Enter
*
*
*Thank you.*
*
No problem Dave. . !! :)
Thx for your kind evaluation.
warmest regards,
Dilipandey
On 7/1/10, Dave Bonallack wrote:
>
> Hi Dilip,
>
> Sorry, didn't see your latest solution. Excellent!
>
> Regards - Dave
>
>
>
> Date: Tue, 29 Jun 2010 15:21:56 +0530
> Subject: $$Excel-Macros$$ Re: Required For
Hi Dilip,
Sorry, didn't see your latest solution. Excellent!
Regards - Dave
Date: Tue, 29 Jun 2010 15:21:56 +0530
Subject: $$Excel-Macros$$ Re: Required Formula
From: dilipan...@gmail.com
To: ahmedhon...@gmail.com
CC: excel-macros@googlegroups.com
Hi Ahmed,
As promised, please find attac
I agree with you Dave that last column of sumproduct formula is having
issue because of text, and this is why i have revised my solution in
my second attempt and used vlookup with array functionality.
Anyways thanks for your consideration.
Thanks,
Dilipandey
On 6/30/10, Dave Bonallack wrote:
>
>
Hi Ahmed, Dilip,
The problem is that the passport data in Col E of the 'Raw Data' sheet, is
text, which isn't processed properly by SUMPRODUCT.
The formulas in columns C:F are ok because they deal with numeric data, but the
formulas in Column G will have to be replaced with something else, but
