| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return across Row Numeric Values Matching EXACT Month & Year for Criteria
Hi Domenic,
That's Perfect! Thank you so much. Cheers, Sam Domenic wrote: Try replacing... INT((COLUMN()-COLUMN($C2))/COLUMNS(Data))+1 with 3-(INT((COLUMN()-COLUMN($C2))/COLUMNS(Data))) Hope this helps! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200610/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return all matching values | Excel Worksheet Functions | |||
| holiday dates | Excel Worksheet Functions | |||
| Return Summed Count of Multiple Consecutive Numeric Values | Excel Worksheet Functions | |||
| How to use an array or matrix to return text vs. numeric values | Excel Worksheet Functions | |||
| Month Year Date Format | Excel Worksheet Functions | |||
Threaded Mode
