Excel Unigue Entries

  • Thread starter Thread starter buffalo411
  • Start date Start date
B

buffalo411

How can I create a formula to read across a row with 30
columns and tell me where the first non-blank value is.

In the example below, I want the formula to read across
Row 1 and tell me that the value "2" is located in cell
b1. Can this be done?
A B C D E F G
Row 1 2 10 12
 
Hi

to get the position of the first non-blank in a row you can use:
=MATCH(FALSE,ISBLANK(A1:Z1),0)
enter this as array formula (CTRL+SHIFT+ENTER)
For your exmaple it wil return 2 (second column)

HTH
Frank
 
Copy the following formula on Sheet 2 on all rows &
Columns , if the data is on on Sheet 1 :

=IF(ISBLANK(Sheet1!C5)," ",Sheet1!C$3&Sheet1!$A5)

Thanks & regards,

Manish
 
Don't forget to create a Column on the extreme right of
your data to seriall number the rows - 1, 2, 3,

and similarly , a row needs to be created naming all the
columns as a , b,c,d,

These rows & columns , have been concatenated in my
formula posted two minutes back.

Thanks,

Manish
 
Thank you so much
-----Original Message-----
Don't forget to create a Column on the extreme right of
your data to seriall number the rows - 1, 2, 3,

and similarly , a row needs to be created naming all the
columns as a , b,c,d,

These rows & columns , have been concatenated in my
formula posted two minutes back.

Thanks,

Manish
.
Click to expand...
 
Back
Top