I need a formula to look at two columns and alert me if there are duplicates. Column M is the DATE and the Column P is the HOTEL NAME. I need to know if I have double booked the same hotel on the same date.
=sumproduct(($m$2:$m$27=m2)*($n$2:$n$27=n2))
Hi
Ranges in the example= MI:M8 & P1:P8
Then try this.
=IF(COUNTIF($M$1:$M$8;M1)/COUNTIF($P$1:$P$8;P1)=0,4;"Doumble booked";"OK!!"))
Pull down to Row 8.
Hope to helps you.
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks