| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.macintosh
|
|||
|
|||
How to look at the values in 8 columns, pick the two that havenumbers, then compare to another pair of numbers
I'm trying to write a function that can look at the values in eight columns
of a row, pick the two columns that have actual numbers (as opposed to NAs), then compare those two numbers to another pair of numbers. Anyone know how to write a function that can search that way ? Thanks, Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| compare 2 columns of numbers and place the matched numbers in a 3r | Excel Discussion (Misc queries) | |||
| compare two text columns and find the closest matched pair of cells | Excel Programming | |||
| Compare to columns on two different spread sheet, only pick up the | Excel Programming | |||
| etsimate values of a linear trend for each pair of known values | Excel Discussion (Misc queries) | |||
| Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
![Michael Levin[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
