BLarry9
asked on
excel scripting, count
Hi, i have an excel question
in one excel file, two sheets
sheet1,
column1 as name
aaa
bbb
ccc
ddd
column2 as count
sheet2,
colume1 as member
aaa, "asdg"
aaa, "gadsds"
ccc, "dafdsgfdsag"
eee, "dagsd"
bbb, "dsaghdshjh"
I would like count how many records for sheet1 column1 if they are in the sheets.
thanks a lot!
s
in one excel file, two sheets
sheet1,
column1 as name
aaa
bbb
ccc
ddd
column2 as count
sheet2,
colume1 as member
aaa, "asdg"
aaa, "gadsds"
ccc, "dafdsgfdsag"
eee, "dagsd"
bbb, "dsaghdshjh"
I would like count how many records for sheet1 column1 if they are in the sheets.
thanks a lot!
s
take countif(vlook
ASKER
looks like i need use vlookup in sheet1 B2
to compare sheet1 A2 with sheet2 columnA
but the text is not totally match,
in sheet1, is aaa
in sheet2, is aaa,"klhjashg"
please provide more information. thanks
to compare sheet1 A2 with sheet2 columnA
but the text is not totally match,
in sheet1, is aaa
in sheet2, is aaa,"klhjashg"
please provide more information. thanks
then use search to search for "aaa" in aaa,"klhjashg"
nest count or countif,vlookup or search to achieve the required reesult
ASKER
I am not an excel scripting person, please provide more information...
today is this first time i am doing this....
today is this first time i am doing this....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.