Hello! I have the attached dataset where I am trying to create a formula to derive the closest check-in date to the clean date for the same property.
For the same property, there are different clean dates for one check in date. I would like to simplify the data set to show the check in date closest to the clean date.
Try:
Formula:
Please Login or Register to view this content.
Diana Tanase
If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
Hi Mike and welcome to the forum,
Your question is a bit tough to understand. It seems like you want to show each property only once. You also want the Maximum Check In with the Minimum Clean dates.
See the attached Pivot Table that may give what you want.
PT Check In vs Cleaned Dates.xlsx
You need to play with Pivots a bit and change the Min or Max of each columns to see if that is what makes sense for your question. Time to learn more about pivots??
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks