All solutions COLUMNS Expert Solution – Excel COLUMN Problems

Excel - COLUMN Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc