Search results

Sorry to be a pain but could you please change this formula so it returns a number rather than a percentage? I also require the formula to say 0% if that's the answer rather than DIV%? Or something change like that.

Sorry for the confusion. This is no longer required but thank you anyway.

Updated spreadsheet.

Thanks, both. Really good progress. I will shortly upload an updated spreadsheet with comments to help track progress. Feel free to have a further look. I would appreciate it.

Thank you very much. Is there a solution without VBA i.e. with formulas only? Anyone else - Feel free to help with the other queries in the attached. Many thanks.

Please could someone address the comments in purple? For the benefit of the search function here, I will summarise what I need help with... A formula to calculate when a document was last saved. Return a result of the date, time and author. A percentage to calculate how many queries were...

Really appreciate this. Thank you!!

Brillant. Works perfectly. Thank you for your help :)

Does any know how to highlight a row of cells because dates are not in a chronological order? I have attached a sample spreadsheet which gives the requirements in a bit more detail.

Perfect! Thank you so much!

I have attached a spreadsheet which contains the following three questions: 1) Please could you set it so that once today's date finishes then the cell of all dates within each month turn green. I imagine conditional formatting can achieve this? 2) Under the Attendance % field (cell O4)...

Can you help? :(

Really appreciate this. I will have to test it when I get home. Could you attach a file addressing all the comments? Happy to extend the deadline to 9pm the following day. I was really hoping you would respond as I know how helpful you are. I’ve been lurking this forum for some time and...

Willing to pay £20 for successfully addressing all the comments in the attached. Paypal preferred. I'm willing to pay first (providing I trust you... In other words, long-term users who I have seen help others). Please do not put this in another forum. I want to pay. I require attention due...

Please do not spend time doing this. I've asked for the thread to be removed. I will post a new thread later this evening. Unfortunately, I've uploaded the wrong file again!

Ignore the above file. It will not let me edit the post. Correct file added...

Can you add percentages of misclassified cases by a team i.e. Finance? It should be a percentage like the 'Data dump' tab where it says the percentage for 'original team'. There should be an extra cell that says Finance. Basically, all the purple comments need addressing. I would be most...

Apologies. This wasn't quite what I wanted. I should have been clearer. Can you add percentages of misclassified cases by a team? It should be a percentage like the 'Data dump' tab where it says the percentage for 'original team'. There should be an extra field that says Finance etc...

Thank you. Apologies for not asking earlier... Do you know how to get percentages of misclassified cases for each team i.e. HR cases were misclassified X amount of percent. P.S. Can you post a step-to-step guide for all the solutions you have posted within this thread? I know this may be...

Thank you. Do you happen to have a revised file?

Thank you everyone! Oh wow you did the percentages too! I'm so grateful! Thank you very much :) Can you tell me how to get the crosses and tickets to automatically show for each new case added? Can you also tell me how to make it so that the spreadsheet refreshes automatically rather than...

Thank you and everyone else for their help. Do you happen to know the answers to the other questions I asked you earlier i.e. percentage etc... Or would I be better of creating a new thread?

Thank you so much! Worked great. Out of curiosity, do you think this is possible to do with formulas? No need to publish the formulas. I wouldn't want to unnecessarily take up your time :) However, I would appreciate if you could publish a formula to calculate the percentage of cases which was...

Hi all, Please, could someone post a robust formula that will allow data that doesn't match to be copied into a separate tab? Excel file explains. Thank you in advance.

Compliance could have only been correctly classified 5 times. I only got it correct four times so wrong once. For this reason, I have m misclassified 20% of cases.