Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hi.
I have little problemo. I have data like this in excel : Time Level (dB) 0.05 77.66 0.1 75.68 0.15 77.82 0.2 76.93 0.25 76.93 0.3 78.15 0.35 79.14 0.4 74.36 0.45 77.7 0.5 78.86 0.55 79.35 0.6 77.87 0.65 78.69 0.7 79.26 0.75 81 0.8 79.98 0.85 81.56 0.9 79.42 0.95 77.99 1 78.1 Let's say the average of the Level is X. I want to locate the value which nearly equall, maximal 1.0 above or 1.0 below the (X-5). Can somebody help me write some excel macro for it? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Searching data | Excel Discussion (Misc queries) | |||
Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) | |||
Searching Macro | Excel Discussion (Misc queries) | |||
searching different files macro | Excel Programming | |||
Column searching using macro or VB | Excel Programming |