![]() |
Match Problem
Hi!
I have a table with some kind of calendar, in wich i have the vacations one person that a mark as M(marked) and F(Vacancies). In other sheet i want to know when are the vacancies near with a warning. I thought to use if and Match formula, but i have the problem of letters among the numbers. So How can i do? i.e. Jan - 1 2 3 4 5 6 7 8 F F F F F F 15 16 17 18 ... 2007 Feb - 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17... 2007 Mar - .... Apr - .... May - 1 2 3 4 M M M M 9 10 11 12 13... 2007 I need the M and F to know the days that were taked off and the days that are marked, and it works fine, but the letters dificults me. Is there solution? I Count with your precious and wise advices. Thanks |
All times are GMT +1. The time now is 10:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com