nischal4487
New Member
- Joined
- Nov 21, 2007
- Messages
- 45
Hi
I have a Column A with values - John,Mike, Sara , Tim etc
Column B contains timesheet hours which are repetitive values against each of the the names ,like
John- 10
Mike-20
John-50
Sara-30
Sara-25
Tim-80
John-50
I want to get the sum of the values for each of these names in a separate sheet without using a pivot chart.
Please help
I have a Column A with values - John,Mike, Sara , Tim etc
Column B contains timesheet hours which are repetitive values against each of the the names ,like
John- 10
Mike-20
John-50
Sara-30
Sara-25
Tim-80
John-50
I want to get the sum of the values for each of these names in a separate sheet without using a pivot chart.
Please help