View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.macintosh
Michael Levin[_2_] Michael Levin[_2_] is offline
external usenet poster
 
Posts: 1
Default 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