Visit Tracker

Krust710

New Member
Joined
Nov 26, 2019
Messages
4
Office Version
2010
Platform
Windows
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.
 

Attachments

Rijnsent

Well-known Member
Joined
Oct 17, 2005
Messages
1,149
Office Version
365
Platform
Windows
Hi Krust,
how would you see what the next 20 visits from today are? Is that the "Visit booked" column? Please tell a bit more about your data and the desired output, is that mainly the table you posted, but than sorted by date and filtered for the first 20 visits from today on?
Thanks,
Koen
 

Krust710

New Member
Joined
Nov 26, 2019
Messages
4
Office Version
2010
Platform
Windows
Hi Koen,

Thank you for getting back to me.

The Team leader wants an overview page which will show various information from this sheet. As there are alot of sponsors an overview page is beneficial for the team leader. I have managed to do that no problem. This sheet, is the second sheet is what the account managers fill in. The frequency of visits, last visit etc and it is from the "visit booked" column that I need to extract the information from. They would like a table that shows the name of account manager, name of sponsor and then the date the book is visited. This is so they can see the amount of people that are going to be away from the office at a snap shot. Now I can use lookup etc to get the account manager and sponsor. However, this messes up when more than one sponsor has the same visit date. I dont know how do get unique results when there are duplicated dates especially seen as there are around 200 sponsors. I have attached an example of what they would like on the overview sheet. It looks so simple but has been so complicated. Any help at all would be appreciated.

Thank you

Krust
 

Attachments

Forum statistics

Threads
1,081,723
Messages
5,360,865
Members
400,602
Latest member
newaqua

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top