Forum Discussion
Two values in one cell
Hi, I am struggling with a formula in a spreadsheet. I am in a library course. We haven't been taught any Excel during class and need to write up an Excel spreadsheet from scratch. The spreads...
Hello Naomi
I set up a quick Power Query solution.
I assumed you only wanted to see the overdue items and not the complete list. In your table every item is an overdue item - even when it is not.
I hardcoded the values for Loan Period and Overdue action period.
I used conditional formatting for the most overdue item(s) and a pivot chart for the distribution of the item types.