E
esbee
Hi everybody,
I have in column A (say A2:A100), strings containing names and dates
concatinated by "-". I have extracted the names using Data>Text To Column.
The parsed names have been filtered to have unique names and are kept in
another column say column F ( say F2 :F15).
The names are of variable length (say 4 to 6 characters). As there could
be more than one row containing data relating to the same name but of
different dates, I want to use the unique names in Col F by referencing them
in a formula to extract all data available against them in Col B ( B2:B100).
I want to use sumif or sumproduct. I am not clear how to reference them as
the name lengths are not uniform. As the names are in Col F, I am not able to
use wildcards. Can any one help ?
I give below a sample of data below:
A B F
Dat-Esbee-09-13-2006-S 200 Esbee
Dat-Harry-12-23-2005-S 120 Harry
Dat-Esbee-02-15-2007-S 270 Pete
Dat-Pete-05-13-2006-P 120 TiaN
Dat-TiaN-04-30-2006-S 325
The total of B for each name in F has to be arrived at using a formula.
Thanks in advance.
I have in column A (say A2:A100), strings containing names and dates
concatinated by "-". I have extracted the names using Data>Text To Column.
The parsed names have been filtered to have unique names and are kept in
another column say column F ( say F2 :F15).
The names are of variable length (say 4 to 6 characters). As there could
be more than one row containing data relating to the same name but of
different dates, I want to use the unique names in Col F by referencing them
in a formula to extract all data available against them in Col B ( B2:B100).
I want to use sumif or sumproduct. I am not clear how to reference them as
the name lengths are not uniform. As the names are in Col F, I am not able to
use wildcards. Can any one help ?
I give below a sample of data below:
A B F
Dat-Esbee-09-13-2006-S 200 Esbee
Dat-Harry-12-23-2005-S 120 Harry
Dat-Esbee-02-15-2007-S 270 Pete
Dat-Pete-05-13-2006-P 120 TiaN
Dat-TiaN-04-30-2006-S 325
The total of B for each name in F has to be arrived at using a formula.
Thanks in advance.