Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need some help.
I have two columns with data. In my case it is time - columns "One" and "Two" I need to find for each value in Two the value in One, that is closest, i.e. I need to substract values from Two with each value from One and to get the MIN non negative value. Example: 10:11 from "Two" is related to 10:09 from "One" because the min non negative value after a substraction is 0:02 One Two Result 10:00 10:01 0:01 10:03 10:03 0:00 10:06 10:11 10:09 10:13 0:02 10:12 Thanks in advance, Yakimo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Subtracting positive amts from negative and positive from positive | Excel Worksheet Functions | |||
find first positive number in column | Excel Discussion (Misc queries) | |||
Find first positive value in a column | Excel Discussion (Misc queries) | |||
FIND POSITIVE VALUE | Excel Discussion (Misc queries) | |||
Find first positive value in row 3 and return date from row 1 | Excel Worksheet Functions |