| Home |
| Search |
| Today's Posts |
|
#29
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Unquie Values
Javier Diaz wrote...
.... . . . Remember, we're messing with dates that are lookedup not hard keyed. .... So are they just dates or dates with times but formatted to show only the date portion? Check using the formula =SUMPRODUCT(SIGN(MOD(H$20:H$44,1))) If this returns 0, then there are dates with times in H20:H44. If you want to treat them as dates alone, change all references to H$2:H $44 to INT(H$2:H$44). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use LOOKUP to return a range of values, then SUM values? | Excel Worksheet Functions | |||
| find largest values, then return corresponding row values. | Excel Discussion (Misc queries) | |||
| Search multiple values to return single values | Excel Worksheet Functions | |||
| How to return min value, but only values>1 ? | Excel Discussion (Misc queries) | |||
| return last values | Excel Discussion (Misc queries) | |||
Threaded Mode
