Hi, I would really appreciate some help with something I am asked to do at work. I have been asked to create another table which will show the next 20 visits from todays date. I am not too savvy with excel and have looked all over the internet. I have tried ifs and ranks with countifs but I keep getting duplicated results. I require them to be unique because the different managers will have visits on the same day and these need to be seen separately. I was wondering if there is a formula that will produce such a table. Any help will be appreciated.
247.9 KB Views: 9