How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask bbao Your Own Question

bbao
bbao, IT Consultant
Category: Microsoft Office
Satisfied Customers: 198
Experience:  Certified Information Systems Security Professional / Certified Information Security Manager / Microsoft Most Valuable Professional
96068672
Type Your Microsoft Office Question Here...
bbao is online now
A new question is answered every 9 seconds

Need some help. I have an Excel report including multiple

Customer Question

Hi, need some help. I have an Excel report including multiple account numbers. I am trying to find out how many time the same account number shows up (total count) I believe there is a way to do this in Excel with a function without manually doing it. Any advise on how?
Submitted: 4 months ago.
Category: Microsoft Office
Expert:  bbao replied 4 months ago.

Hi There. I am Bing and I look forward to helping you with your issue today.

Expert:  bbao replied 4 months ago.

As I remember they are COUNT and COUNTIF functions. Can you please attache your XLS file so I make changes and post it back?

Expert:  bbao replied 4 months ago.

Please better manually illustrate your result in a worksheet so I can make sure the result is something you are expecting. Is it okay for you?

Customer: replied 4 months ago.
Hi, here is the file I am trying to work on
Customer: replied 4 months ago.
Did you get the file?
Expert:  bbao replied 4 months ago.

Got it. Thanks.

Expert:  bbao replied 4 months ago.

Do you actually mean the filed of Customer Number? If yes, I think the best way to do that is to use Pivot Tables.

Expert:  bbao replied 4 months ago.

Done. Please review.

Customer: replied 4 months ago.
Sorry, can't download the file
Expert:  bbao replied 4 months ago.

mmm... me too. let me check what's wrong.

Expert:  bbao replied 4 months ago.

Again, in ZIP format.

Expert:  bbao replied 4 months ago.

I don't know why my file changed filename... :(

Customer: replied 4 months ago.
Still no luck to download the file...
Expert:  bbao replied 4 months ago.

Okay, I put it somewhere and let you download. OK? Sorry for the inconvenience.

Expert:  bbao replied 4 months ago.

http://http://52.160.104.249/2014_MAP_BING.xls

Expert:  bbao replied 4 months ago.

Please advise once downloaded, so I can delete it.

Customer: replied 4 months ago.

Still does not work....Can you please email me? XXXXXXXXXXXXX

Expert:  bbao replied 4 months ago.

http://52.160.104.249/2014_MAP_BING.xls

Sorry, only one HTTP there.

Expert:  bbao replied 4 months ago.

Workable now?

Expert:  bbao replied 4 months ago.

BTW, my XLS file was save on Mac. If you notice anything incompatible with your version of Excel, I may switch to a Windows PC and resend it.

Customer: replied 4 months ago.
Still not working. Am I getting charged for this? Sorry, but this is not what I expected
Expert:  bbao replied 4 months ago.

Did you open the XLS and saw one more sheet named "Customer Number Counts"?

Customer: replied 4 months ago.
File is not opening properly. Can you please send to my email address
Expert:  bbao replied 4 months ago.

Please see attached the screenshot which shows every Customer Number's total count is shown there.

Expert:  bbao replied 4 months ago.

OK. Will also try saving it on a PC. Which Excel version do you prefer?

Customer: replied 4 months ago.
Not quire sure what Excel version I have. It's not the latest version
Expert:  bbao replied 4 months ago.

Email sent. Got it?

Expert:  bbao replied 4 months ago.

BTW, just double check did you see the screenshot I posted above, which shows the required total number for each Customer ID in a new worksheet?

Expert:  bbao replied 4 months ago.

Any feedback please? Was it something you expected.

Expert:  bbao replied 4 months ago.

Just in case you do want to know the function for counting the Customer Number field in my demonstrating pivot table, as mentioned in my second comment, it is function COUNT.

I am positive for my answer. However, if you do think it is not something you expected, please upload a worksheet to demonstrate your expected result. Thanks.

Expert:  bbao replied 4 months ago.

I just called JA customer services regarding your requirement of invoice, they will help and contact you shortly.

Please kindly accept the my answer to this question as you have confirmed my answer was a workable solution. Thanks.

Related Microsoft Office Questions