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 Richard Your Own Question
Richard
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 36526
Experience:  Over 15 year experience resolving Microsoft Office Issues
32989067
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

May spreadsheet has to do with clients and collections and

This answer was rated:

May spreadsheet has to do with clients and collections and also payments and movement of packages. This spreadsheet gathers information of all movements on a daily basis and it also gathers information for the month.

Example. Mr. A has received a parcel and at closing of day the parcel was not collected but he was notified about the parcel the answer in the reason cell would be true or yes. With this I do not have a problem but if he could not be contacted for any reason then that reason must be reflected in the corresponding field for that day on the daily spreadsheet. I need a formula in excel that brings text into a cell in my daily figures on the specific date if the criteria (in this case the reason why the client could not be contacted) is met.
Thank you for your question, my name is Richard.

Can I look at your speadsheet please so I can see exactly how you have it laid out.

I can then directly do the formula for you.

- Click the following link: http://www.wikisend.com
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"

Thank you
Customer: replied 3 years ago.

Thanks... I'm sending the file now

Thank you

Please give me the File ID once you have up,loaded it so I can work on it for you.

Customer: replied 3 years ago.

http://wikisend.com/download/198064/Daily Stats.xlsx

 

Daily Stats.xlsx

 

198064

Customer: replied 3 years ago.

198064

Thank you

Can you download this file and tell me if this is what you want please

http://wikisend.com/download/325742/Daily Stats.xlsx

Thank you
Customer: replied 3 years ago.

Yes thank you Richard but I have put another "N" in with a reason on the 10th and the reason did not pull through. Can you kindly look at it?


 


http://wikisend.com/download/839824/Expert Daily Stats.xlsx


 


Many thanks

ok, I see what you did, which stopped the formula, so I needed to use a Macro for this.

Download it from my link below

http://wikisend.com/download/240076/Expert Daily Stats.xlsm

Test and let me know the results please.

Customer: replied 3 years ago.

Richard I cannot download the file in Wikisend. It keeps on opening Download manager to open it and Download manager keep asking for a user name and password

ok, go to

www.wikisend.com

Click download and enter in File ID

240076

Then download the file please.

When you are using the file, when you make a change, go to the Cell that should display the information, press F2 and then press enter so it updates.

Let me know if you have any difficulties please


Richard and other Microsoft Office Specialists are ready to help you
Customer: replied 3 years ago.

Thanks Richard


 


I eventually got the file downloaded


 


I had to uninstall Download manager which is fine because I don't use it anyhow. When I did changes to the spreadsheet I pressed F2 in the field where the answer should be and I got #NAME. So I realized that my macros was switched off. As soon as I enabled the macros everything work smoothly.


 


You are a star ! Thanks very much!

Your most welcome!

If you have continued problems, or would like any additional information or assistance, please do not hesitate to let me know.

And if you can take a second to rate my service, that would be greatly appreciated.

Thank you

Related Microsoft Office Questions