ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Match Problem (https://www.excelbanter.com/excel-discussion-misc-queries/139911-match-problem.html)

Micos3

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