| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MATCH gone Awry....
Hi
try =MATCH(TRUE,L55:L580,0) and enter this as array formula with CTRL+SHIFT+ENTER -- Regards Frank Kabel Frankfurt, Germany "Bill Buckner" schrieb im Newsbeitrag ... Here is my formula: =MATCH(TRUE,(L55:L58)0,0) In L55:L58 I have: 0 0 1 2 This should return 3, but it keeps returning #NA. This used to work before I converted a few of my longer cell calculations to VB. Now I have to hit <ctrl<alt<F9 to get my sheets calculated. H E L P ..... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Formula: Return 1st match, then 2nd match, then 3rd match | Excel Discussion (Misc queries) | |||
| simple counting gone awry | Excel Worksheet Functions | |||
| Formula gone awry | Excel Worksheet Functions | |||
| index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
| MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
Linear Mode
