visit

I need to calculate the year for the following data. What I want to know for the year column is if there is a date in the Visit date 2018 column bring back 2018 in the year column, if there is a date in the visit date 2019 it will bring back 2019 in the year column, if there is a date in both...

Hi All I have the date of visit and Visitor ID . I need a formula thathighlight if a visitor made a visit within the same time in other words they alsoclaimed to make a visit between Arrival time and Departure time on same date. In other word I have visitors claiming they were on onevisit but...

Hi folks, I need a formula column to aggregate the codes billed per customer visit (solution would look like E2:E10 below). Then later I can include the results in a PivotTable to see the combo frequency of codes billed at this store. There is a large list of customer transactions. Each row...

ok, I've tried about 2 dozen methods to acheive this, so I'm putting up a post to see if anyone here can help me. Here's what I'm trying to acheive: I have a sheet with 10 columns Date Served, Last Initial, First initial, Zip, First Time Visit, Current month discount, over 60, Men, Women...

Thank you for taking the time to read. I put together a lot of visit timetables and my issue is they constantly change. For example a visit can start in cell A1 at 09:00 with that section due to finish in cell B1 at 09:20. The next part of the visit could be from cell A2 at 09:20 to cell B2 at...

Hi everyone, It is my first time using this service so hoping I will find the answer I need... I got this table named TableTimeData: OPP Number [Project: Created Date] [Site Visit - Completed Date] 0001 11/01/2018...

Hi - I was hoping somebody could help me out with an excel formula. I'm in operations at a landscaping company, and I'd like a better way to keep track of how many days it's been since the property was last serviced. Below is an example of the spreadsheet I have. Let's say today's hypothetical...

Hello Excel Experts. I am facing some challenges in sorting an excel document, where there are occupancy percentage values by date (e.g. from Jan 1, 2018 to Yesterday) on one sheet and other sheet just have date ranges for a person's visit at our facility e.g. Mr. X visited from Sep. 23 to...

Hello, Is it possible to work with gaps.There must be a gap of 8 days between visits throughout the year.Can I do this automatically?Location X must be scheduled every 8 days for a visit, starting on 2 JanuaryI do not succeed with macrosWho can help me dave

I need to return a latest date from a table but filter down on an ID I have 2 tables AD Visit - Holds details of visit dates and can have multiple visits for an ID AD Completed - Holds the ID and needs to show the latest date for an ID The last vist date needs to work on up to the last 8...

Hello, Lets say that i am trying to predict when will a customer come back to my shop. 1 means that customer has visited my shop, meanwhile blank cell means that customer did not visit I recorded data of 10 days and i need to predict next visit. It is obvious that customer1 visits every 2...

I am trying to create a quality assurance report. This report has Photo Timestamps that should have been taken in between the start and end times of the visit conducted. I have a column in the report that flags any photo timestamp outside of the visit start / end times, but that means if it...

I have this formula which I use to find if a value exists in a range; For Each cell In Sheet14.Range("B4:B23") Set found = Sheet4.Columns("N").Find(what:=cell.Offset(0, 15), LookIn:=xlValues, LookAt:=xlWhole) If found Is Nothing Then Exit Sub If cell.Offset(0, 2) = "Area" Or cell.Offset(0, 2)...

Hi, I’m trying to create/find a code that will help me populate my spreadsheet, I have a maintenance spreadsheet that I need to enter new works into. For example, I need to visit one address, 8 x for $100 for 0-2 months, than I will need to visit 16 x $100 for 3-6 months and so on, so I’m after...

Hi, I am new to this forum and this is my 1st post for help. I have outlined the problem below: <tbody> A B C D E F G H I J K 1 Job number visit date Job type Status 1st 2nd 3rd 4th 5th 2 23502-3 04/04/2017 Contract Visit completed 1 2 3 4 5 3 23502-4...

Hello, I have been searching this forum and youtube all day to figure out this issue. Sorry if this is a repeat. My scenario: I am attempting to do a crosswalk. Basically comparing a legacy system data to an upgraded new system. I am trying to create a formula in the "Proposed S2...

Hello - I was wondering if I could get extra eyes/minds to the following post I created at OzGrid.com. Would greatly appreciated. I would explain but it would make more sense to visit the following link. Please advise if this post is in violation of any Mr.Excel rules. Thank you...

I'm trying to lookup values from Master Data worksheet check if "CONDITION 1" is true and to populate with "Value" each column with header "SITE # 1" in Project Visit worksheet having empty row using VBA. Note that number of row and columns will remain variable, hence I'm want to use <code...

Hi, I am looking for a solution to check redo based on multiple criteria. There are basically 2 values in column P and Q it should check both in another sheet named "Previous" if value of P Q matches values in "Previous" and is with 1 month (matching value "Visit") or 3 months (Matching value...

Hi Friends, Please, If anyone can help me in this scenario. I have created an email template into excel. When I had build a macro to copy this template to clipboard to copy it into outlook body, it comes with table format. Then I had tried to copy this template through adding a textbox and it...