Consolidating Data in Excel

0

https://www.youtube.com/watch?v=IGaq_biQ1B8   Tried it but its not working for the whole name list. Certain Person's total amount are not getting added. For Eg: As per your list above, the Total amount for John doe is 70. But when I tried it comes like John Doe 56 and then John Doe 14. Which means only a part of Amount is getting added. why is that?????   I have attached my file herewith and have marked in red which has not been added. All Iwant is to know who has purchased more.Please help

Answer
Discuss

Discussion

Post your workbook and I shall take a look at your problem.
Variatus (rep: 1413) Apr 3, '18 at 8:38 pm
Add to Discussion

Answers

0
Selected Answer

The name "Shibani" in row 86 has a blank space added at the end which the other "Shibani"s don't have. Excel treats it as another name. Unfortunately I don't have access to YouTube. Therefore I don't know how the list was created. However, your description of the mistake points at names not being identical. Therefore that is what I looked for and that is what I found. I hope it helps.

You could avoid errors of this kind by creating a data validation list for your customers and selecting their names from the list instead of entering them several times. That would be both faster and more secure.

Discuss
0

Thank you so much. It worked

Discuss

Discussion

Great! Do you need any help with the validation drop-down?
Variatus (rep: 1413) Apr 7, '18 at 5:33 am
No Thank you.
ramya3ram (rep: 2) Apr 7, '18 at 9:46 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login