| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find the position of a date
Hi,
I have in column A descending dates as: Mar 1/11 Feb 1/11 Jan 3/11 Dec 1/10 Nov 1/10 Oct 1/10 Sep 1/10 Aug 2/10 Jul 1/10 Jun 1/10 May 3/10 Apr 1/10 Mar 1/10 Feb 1/10 Jan 4/10 Dec 1/09 Nov 2/09 I need a formula, that given a month (as number, 12 for example in cell B1) and the year (2009 for example, in cell B2) gives me the position of the matching date (16). I think it should be and array formula= Match(...... Thanks Mika |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you find the position of the first value (< 0) in a list | Excel Discussion (Misc queries) | |||
| Array to find relative position - is there a better way? | Excel Worksheet Functions | |||
| How do I find the position of the lowest value in a row? | Excel Discussion (Misc queries) | |||
| find nth position of a string | Excel Discussion (Misc queries) | |||
| Use MATCH to find position of max in 2D range? | Excel Worksheet Functions | |||
Threaded Mode
