How would I adjust the grand total to reflect the duplicates from a list of account with names in a pivot table. The sample is short but the master list has hundreds if not thousands of entries. Essentially, I just want to show the monetary value for each sales rep, but there are a few employees that have the same first and last name. Any ideas?
Please see sample sheet attached-
I would suggest to use COUNTIF function with the name. This will add a number to each name which will make it unique
=B3&COUNTIF(B$3:B3,B3)
Row\Col Sales Rep John Hyde1 John Hyde Joseph Vega1 Joseph Vega David Banner1 David Banner Michael Jackson1 Michael Jackson Steven Franco1 Steven Franco Joseph Vega2 Joseph Vega
Or if you want to add a number to the duplicate name only:
=B3&IF(COUNTIF(B$3:B3,B3)=1,"",COUNTIF(B$3:B3,B3))
Row\Col John Hyde John Hyde Joseph Vega Joseph Vega David Banner David Banner Michael Jackson Michael Jackson Steven Franco Steven Franco Joseph Vega2 Joseph Vega
Last edited by AlKey; 03-13-2015 at 09:32 AM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Awesome! it worked thanks a bunch!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks