# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need to find a formula to recognize a particular name in a column and associate the numbers (row) with the name. add up all the numbers with the name and divide by how many times the name comes up.
Solved by V. D. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 16/08/2018 - 07:07
Hi
User 16/08/2018 - 07:08
Hey CV. im trying to create a average
Excelchat Expert 16/08/2018 - 07:08
Would you be able to share the data?
User 16/08/2018 - 07:08
sure
User 16/08/2018 - 07:08
how
Excelchat Expert 16/08/2018 - 07:09
you can upload the file here
User 16/08/2018 - 07:09
User 16/08/2018 - 07:10
like this ?
Excelchat Expert 16/08/2018 - 07:10
yes
Excelchat Expert 16/08/2018 - 07:10
Which sheet do you want the formula to be in ?
User 16/08/2018 - 07:10
well for some reason my screen has gone blank. no more excel spreadsheet anymore
User 16/08/2018 - 07:11
average
Excelchat Expert 16/08/2018 - 07:11
Average of what column and in which sheet?
User 16/08/2018 - 07:11
im trying to create a formula that will take each technicians name as i enter them every day.
User 16/08/2018 - 07:11
DATA
Excelchat Expert 16/08/2018 - 07:11
okay
Excelchat Expert 16/08/2018 - 07:12
what is the value you want to average?
User 16/08/2018 - 07:12
is the sheet. i would like to create a formula that will take each technicians name . add up the revenue per call and divide it by the amount of call the technician has.
User 16/08/2018 - 07:12
is that clear enough ?
Excelchat Expert 16/08/2018 - 07:13
yes
Excelchat Expert 16/08/2018 - 07:13
SO , you want to average revenue per call?
User 16/08/2018 - 07:13
yes
Excelchat Expert 16/08/2018 - 07:13
Column F
Excelchat Expert 16/08/2018 - 07:13
in which column should i put this formula in ?
Excelchat Expert 16/08/2018 - 07:14
or should I create a separate table for technician and average?
User 16/08/2018 - 07:14
Excelchat Expert 16/08/2018 - 07:14
sure
Excelchat Expert 16/08/2018 - 07:14
ve me sometime to work on it
Excelchat Expert 16/08/2018 - 07:14
*give
Excelchat Expert 16/08/2018 - 07:17
Here it is
User 16/08/2018 - 07:17
technicians name by the amount of (total) revenue he has made divided by the (total) calls hes had. i input around 15 new rows everyday. so if i can get this to work it would save me a ton of time.
Excelchat Expert 16/08/2018 - 07:18
So, if you want to update this, just enter in the immediate rows in the data sheet
User 16/08/2018 - 07:18
and automaticle update
Excelchat Expert 16/08/2018 - 07:18
nd then refresh the pivot table
Excelchat Expert 16/08/2018 - 07:18
*and
User 16/08/2018 - 07:18
what formula did you use ?
Excelchat Expert 16/08/2018 - 07:18
I used pivot table
Excelchat Expert 16/08/2018 - 07:18
No formula
Excelchat Expert 16/08/2018 - 07:19
User 16/08/2018 - 07:20
you did it. and if i enter new data in the sheet and hit refresh. the pivot table will also refresh?
Excelchat Expert 16/08/2018 - 07:21
You enter the data in the row just below the where previous data
Excelchat Expert 16/08/2018 - 07:21
Suppose, the current data ends in row 100
Excelchat Expert 16/08/2018 - 07:21
Then you would have to enter the data in row 101
Excelchat Expert 16/08/2018 - 07:21
This will help excel to understand if they are part of the same table
User 16/08/2018 - 07:22
awesome, i get that. just how did you create this in the pivot table ?
User 16/08/2018 - 07:22
no formula ?
Excelchat Expert 16/08/2018 - 07:23
Post this, go to the sheet with pivot table, select any cell in the pivot table >then Pivot table analyze tab in the top and refresh
Excelchat Expert 16/08/2018 - 07:23
yes, no formula was used
Excelchat Expert 16/08/2018 - 07:24
For creating pivot table select the data > Insert Tab > Pivot table
User 16/08/2018 - 07:25
so if i where to graph this . then entered mor data in my data sheet the graph would automatically change if i press refresh
Excelchat Expert 16/08/2018 - 07:26
yes
Excelchat Expert 16/08/2018 - 07:27
but you would have to insert pivot graph
Excelchat Expert 16/08/2018 - 07:27
and this functionality is available in windows only

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.