Consolidate Data

[jebindavidson]

Hello,

In my excel there are names appearing multiple times with different values. Sorting by names helps me to find out the total. What I would like to have is, if this data can be populated on a separate sheet where the totals of a name appear.

Please look at my sample file.

Thanks in advance for your support!

[windknife]

Try this,

Please Login or Register  to view this content.

[jebindavidson]

Genius! Thanks a million.

[windknife]

You are welcome.
-----------------------------------
If that takes care of your original question, please click on "Thread Tools" from the menu link above and mark this thread as SOLVED.

[jebindavidson]

Just did it! Thanks!

I was looking for the solved option