Forum Discussion
data validation & progress report
It turns out there was a problem if there is a new empty row below the cell where you enter/edit a percentage
In the attached version I added a helper column to get around it.
See the attached version. I changed the data range into a table and used two defined names to refer to the Date and Progress columns.
HansVogelaar Thanks for reply
My issue is with dates, i want to check progress based on date, for example if my progress on 17/9/22 was 22% , and for some reason i entered a progress of 23% on 10-9-22 then it should give an error as progress on past date cannot be more than progress on future date, dont know if am clear enough, i put one example with yellow highlight in the file
It turns out there was a problem if there is a new empty row below the cell where you enter/edit a percentage
In the attached version I added a helper column to get around it.
- Thanks Hans, it worked, ill try to tweak it so it works on all excel versions as MAXifs doesnt work on old excels like 2010