| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Array to find rows need to insert date criteria
How do I include a date limitation for a selected month into this array, the
date column is C the date is in J4 enters as 8/1/07 This returns the correct row numbers =SMALL(IF(Data!$AE$2:Data!$AE$30000,ROW(Data!$AE$ 2:Data!$AE$3000)),ROW(1:1)) =SMALL(IF(Data!$AE$2:Data!$AE$30000,ROW(Data!$AE$ 2:Data!$AE$3000)*MONTH(Data!$C$2:Data!$C$3000=MONT H($J$4))),ROW(1:1)) Thanks SPB |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find date that meets a criteria | Excel Discussion (Misc queries) | |||
| find date that meets a criteria | Excel Discussion (Misc queries) | |||
| In an array, I need to find the row # that meets 2 criteria | Excel Worksheet Functions | |||
| Can I use "find / replace" to automatically "Insert Rows" in a do. | Excel Discussion (Misc queries) | |||
| Insert Rows into an existing array | New Users to Excel | |||
Threaded Mode
