Screen Shot 2014-09-29 at 11.24.44 PM.png
I have 365 days of the year and I want to find the exact day when a car will be returned. I found how to do it.However,if a car is available at day 13 and on the next day another car is available at day 13,with MATCH function I get just 1.I want to be counted,so that at day 13 I have 2. At some days there are no returns of cars,so we have this empty.However,when it is empty,the MATCH function treats it as #N/A.Is it possible instead of #N/A to have 0 showing.
The formula which I used: =IF(MATCH(A3,$B$2:$B$366,0)>0,1,0)
There is also an attachment. I will truly appreciate all of your help
Thank you very much
Bookmarks