What formula shall I use [Closed]

Report
Posts
11
Registration date
Tuesday January 15, 2013
Status
Member
Last seen
January 23, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,


Hi morning!
I Have a problem right now. Here's the thing.
I' working on an Ms Excel. My data are the following:
"Assigned
Reg. No." Suggestion / Idea "Suggester's
Name/s" Emp.# Points Total Points
.

Now, I don't know what formula shall I used, on how to get the points on each suggesters based only on their ID # considering that some of them started submitting suggestions since 2009. Another also is that some of the suggestions are submitted by 2 suggesters. So i would like to know how it would appear on another sheet with these data: Name: ID # Year: Total POints( from previous 2006 year up to present) . I'm the one who enters the point. I don't know how to sum it up. Please help me

6 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
are you looking for update to happen as you enter name or is it more like a batch job which when you want, have a summary information prepared as you indicated
Posts
11
Registration date
Tuesday January 15, 2013
Status
Member
Last seen
January 23, 2013

Hi Rizvisa 1!

Yes, for update everytime I enter an ID #.
Example, ID # 8209 submitted suggestion last 2011 3 times and in 2012 6 times.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
sounds like you just want to enter an ID and find out based on existing records in the sheet what is the total for that person. is that so?
Could you post a sample book at some file share site like speedyshare.com and post back the link to the actual file back here.
Posts
11
Registration date
Tuesday January 15, 2013
Status
Member
Last seen
January 23, 2013

Hi Rizvisa 1!

Yes, that's it.

here's the link.

http://speedy.sh/5srvq/Sample-Excel.xlsx
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
you need a maxro for it. I am thinking the macro should
1. delete data from "total points" sheet
2. loop through each sheet and add name and id, if no already added. update the total
Posts
11
Registration date
Tuesday January 15, 2013
Status
Member
Last seen
January 23, 2013

gOOdmornning rizvisa 1.!

how will i do it?
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
there are some like this 5249/7006/7690 so how they will work?
Posts
11
Registration date
Tuesday January 15, 2013
Status
Member
Last seen
January 23, 2013

they will identified as unique value. or they will be interpreted as one.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
normally
5249/7006/7690 and 5249 will be two different records. but then all depends on what is the requirement.
Hi!
yes, thats it.so how would that be?
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
so in year 2010, name Jing Pano. apears 4 times with total points for each time, is 26. So you expect for total , Jing Pano. to appears only once and total being 104 (assume that's the only year this name appeared)

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!