Solved

excel scripting, count

Posted on 2013-11-20
6
344 Views
Last Modified: 2013-11-22
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
0
Comment
Question by:BLarry9
  • 3
  • 2
6 Comments
 
LVL 21

Expert Comment

by:oleggold
ID: 39663996
take countif(vlook
0
 

Author Comment

by:BLarry9
ID: 39664018
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
0
 
LVL 21

Expert Comment

by:oleggold
ID: 39664031
then use search to search for "aaa" in  aaa,"klhjashg"
0
ScreenConnect 6.0 Free Trial

At ScreenConnect, partner feedback doesn't fall on deaf ears. We collected partner suggestions off of their virtual wish list and transformed them into one game-changing release: ScreenConnect 6.0. Explore all of the extras and enhancements for yourself!

 
LVL 21

Expert Comment

by:oleggold
ID: 39664036
nest count or countif,vlookup or search to achieve the required reesult
0
 

Author Comment

by:BLarry9
ID: 39664048
I am not an excel scripting person, please provide more information...

today is this first time i am doing this....
0
 
LVL 2

Accepted Solution

by:
samrad1 earned 500 total points
ID: 39665208
Hey! I used a countif to the other sheet, and a search to extract the name on sheet 2, I've attached the file to this reply, take a look!


Formula for extracting the name in Sheet2 cell B2:
=LEFT(A2, SEARCH(",",A2) - 1)

Formula in Sheet1 cell B2 for counting the occurrences on Sheet2:
=COUNTIF(Sheet2!$B$2:$B$6,Sheet1!A2)

Example.xlsx
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question