Forum

Hello, For reference. The LEFT function returns its value in a text string, so you need to change it to be a numeric value. Use below formula an...

Hello, If you haven’t already, do consider taking this course. Just remove the quotation marks surrounding the.number. =IF(C95<>"",1,"")

Hello Anand, It is always easier if we have a sample file showing the data plus the expected outcome. If the data is formatted differently, then it...

Hello, See attached file, column L. I have used the formula that Mynda wrote.

Hello, ’Check outsearch for SSRS and you will find several courses.

Hello Melanie, Have you seen these articles linked to below? They show two different methods to add drop down lists in Excel.

Hello Ali, Welcome to this forum. I will gladly help with any questions you might have in order to learn how to accomplish what you want Excel to d...

Hello Paul, Currently viewing your file from my tablet and don’t have full view or functionality, but will try to give some help anyway. Update:...

Hello Joseph, If you are new to working with Excel tables then I can only recommend you to participate in this Excel Tables course. It gives you go...

Hello Joseph, Thanks for the data. For the ease of working with and maintaining the data I would suggest that you gather the time attendance dat...

Hello Paul, See attached file for two different solutions. For the Index/Match formula, you can read more information about the technique used i...

Hello, Your attachment seems to be without data. If you haven’t already, do check out this article, it contains good info.

Hello FS, The calculation you use in your sample file is (removing the IFs) =B2/A2-1 which is just another method to calculate and is correct. A...

Hello, I have tested too and can't replicate your error. A question though, instead of using the Full Screen command have you tried using the Auto-...

Hello, Not sure what you are looking for, as for when checking your sample file you get correct result with your current formula. Or have I misunde...