Excel Question

  • Thread starter Thread starter Jeffrey
  • Start date Start date
J

Jeffrey

I have a table made up of 25 columns. Some of the cells
have values and some of the cells are blank. For each row
I need to find the first column with a non-blank value
among columns B through Z and place the result in column
A. Due to the large number of columns I don't want to use
nested "IF" and "ISBLANK" functions. Is there a way to do
this?
Thanks for your assistance.
 
O no that's not good...

As an array formula
=MIN(IF(B1:Z1<>"";COLUMN(B1:Z1);256))
Entered with CTRL+SHIFT+ENTER

that will work.:-)

Pieter

| Column number in cell A1
| =MIN(SUMPRODUCT((B1:Z1<>"")*(COLUMN(B1:Z1))))
|
| Pieter
|
| | I have a table made up of 25 columns. Some of the cells
| | have values and some of the cells are blank. For each row
| | I need to find the first column with a non-blank value
| | among columns B through Z and place the result in column
| | A. Due to the large number of columns I don't want to use
| | nested "IF" and "ISBLANK" functions. Is there a way to do
| | this?
| | Thanks for your assistance.
| |
|
|
 
Back
Top