What formula shall I use
Closed
flower_girl
rizvisa1
- Posts
- 11
- Registration date
- Tuesday January 15, 2013
- Status
- Member
- Last seen
- January 23, 2013
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Related:
- What formula shall I use
- Spreadsheet formula - Articles
- Excel @ in formula ✓ - Forum - Excel
- Little alchemy formulas - Guide
- 1st, 2nd, 3rd position formula in excel ✓ - Forum - Office Software
- Logitech formula vibration feedback wheel driver windows 10 - Download
6 replies
rizvisa1
Jan 21, 2013 at 09:17 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Jan 21, 2013 at 09:17 PM
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
flower_girl
Jan 21, 2013 at 09:24 PM
- Posts
- 11
- Registration date
- Tuesday January 15, 2013
- Status
- Member
- Last seen
- January 23, 2013
Jan 21, 2013 at 09:24 PM
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.
Yes, for update everytime I enter an ID #.
Example, ID # 8209 submitted suggestion last 2011 3 times and in 2012 6 times.
rizvisa1
Jan 21, 2013 at 09:56 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Jan 21, 2013 at 09:56 PM
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.
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.
flower_girl
Jan 21, 2013 at 11:38 PM
- Posts
- 11
- Registration date
- Tuesday January 15, 2013
- Status
- Member
- Last seen
- January 23, 2013
Jan 21, 2013 at 11:38 PM
Hi Rizvisa 1!
Yes, that's it.
here's the link.
http://speedy.sh/5srvq/Sample-Excel.xlsx
Yes, that's it.
here's the link.
http://speedy.sh/5srvq/Sample-Excel.xlsx
rizvisa1
Jan 23, 2013 at 06:47 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Jan 23, 2013 at 06:47 AM
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
1. delete data from "total points" sheet
2. loop through each sheet and add name and id, if no already added. update the total
flower_girl
Jan 23, 2013 at 09:50 PM
- Posts
- 11
- Registration date
- Tuesday January 15, 2013
- Status
- Member
- Last seen
- January 23, 2013
Jan 23, 2013 at 09:50 PM
gOOdmornning rizvisa 1.!
how will i do it?
how will i do it?
rizvisa1
Jan 23, 2013 at 10:35 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Jan 23, 2013 at 10:35 PM
there are some like this 5249/7006/7690 so how they will work?
Didn't find the answer you are looking for?
Ask a question
flower_girl
Jan 23, 2013 at 11:55 PM
- Posts
- 11
- Registration date
- Tuesday January 15, 2013
- Status
- Member
- Last seen
- January 23, 2013
Jan 23, 2013 at 11:55 PM
they will identified as unique value. or they will be interpreted as one.
rizvisa1
Jan 24, 2013 at 06:46 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Jan 24, 2013 at 06:46 AM
normally
5249/7006/7690 and 5249 will be two different records. but then all depends on what is the requirement.
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?
yes, thats it.so how would that be?
rizvisa1
Feb 2, 2013 at 02:36 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Feb 2, 2013 at 02:36 PM
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)