| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I return the first non-blank value in a row?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I return the first non-blank value in a row?
Array enter (enter using Ctrl-Shift-Enter)
=INDEX(1:1,MIN(IF(1:1<"",COLUMN(1:1),300))) Change the 1:1 to the row of interest... HTH, Bernie MS Excel MVP "BBA" wrote in message ... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I return the first non-blank value in a row?
Here's another way...
=INDEX(A1:Z1,MATCH(TRUE,INDEX(A1:Z1<"",0),0)) or =INDEX(1:1,MATCH(TRUE,INDEX(1:1<"",0),0)) Hope this helps! In article , BBA wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| enter numbers in blank cells | Excel Worksheet Functions | |||
| How do I return a blank for VLOOKUP instead of #N/A? | Excel Worksheet Functions | |||
| Summarize Out of Stock List | Excel Worksheet Functions | |||
| Counting blank and filled cells within a range. | Excel Discussion (Misc queries) | |||
| referencing cells that return blank results | Excel Worksheet Functions | |||
Linear Mode
