Question description:
This user has given permission to use the problem statement for this
blog.
i need a formula to combine column y with the number mentioned in column w counting in from 1 to 0 and posting the total count next to number 1 in column v.
Solved by E. J. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
22/08/2018 - 06:45
Welcome, Thanks for choosing Got It Pro-Excel.
Excelchat Expert
22/08/2018 - 06:46
Do you have sample data that we can work with?
User
22/08/2018 - 06:49
here is an example
[Uploaded an Excel file]
Excelchat Expert
22/08/2018 - 06:51
Okay.
Excelchat Expert
22/08/2018 - 06:51
How would you like to combine the columns?
Excelchat Expert
22/08/2018 - 06:55
Hello, are you there?
User
22/08/2018 - 06:56
i would like to combine column w or y to column v for every similar email sent. without counting it manually
User
22/08/2018 - 06:57
i was counting manually from 1 to 0 and the first email sent gmail. com was 3 and put the total next to one
User
22/08/2018 - 06:58
so, 1,0,0 = count 3
User
22/08/2018 - 06:59
and the next count was for email on column x ( omcast.net which was 1,0,0,0,0,0,0,0,0,0 = count 10 next to 1.
Excelchat Expert
22/08/2018 - 07:01
Basically, why are you doing all these? Maybe there is a better approach to this.
Excelchat Expert
22/08/2018 - 07:01
Please let me know
User
22/08/2018 - 07:03
i am trying to find a formula
User
22/08/2018 - 07:03
instead of counting it manually
User
22/08/2018 - 07:03
i have over 60000, i cant do them all manually
Excelchat Expert
22/08/2018 - 07:04
Very good.
Excelchat Expert
22/08/2018 - 07:04
What do you want to count?
User
22/08/2018 - 07:04
column w for each email sent
Excelchat Expert
22/08/2018 - 07:05
1 implies an email sent?
User
22/08/2018 - 07:05
and total will be posted on column v beside the number 1
User
22/08/2018 - 07:06
# opens Uniques
3 1 @gmail.com
0 @gmail.com
0 @gmail.com
User
22/08/2018 - 07:07
# opens Uniques
3 1 @gmail.com
0 @gmail.com
0 @gmail.com
User
22/08/2018 - 07:09
here is an example. so, 3 gmail.com were sent and the total count is 3. i want to figure out a formula that count the 3 gmail.com email into column v next to number 1 on column w or y
Excelchat Expert
22/08/2018 - 07:11
Are columns W and Y always the same? Or sometimes their rows change?
User
22/08/2018 - 07:12
they are the same because it is the same emails from the same firms. the only thing that changes is numbers of email sent per firm
Excelchat Expert
22/08/2018 - 07:13
Okay.
User
22/08/2018 - 07:14
here is an example formula i was using = COUNT(W12,1,0)
User
22/08/2018 - 07:19
please see new excel sheet just uploaded for you. so, you can have an idea of what am saying
[Uploaded an Excel file]
Excelchat Expert
22/08/2018 - 07:20
Okay.
Excelchat Expert
22/08/2018 - 07:21
Okay. Working on this...
User
22/08/2018 - 07:24
thank you
User
22/08/2018 - 07:44
ANY PROCESS
User
22/08/2018 - 07:44
LOOKS LIKE I GOT 37 SECOND LEFT
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.