Excel Unigue Entries

[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

 

[Frank Kabel]

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

 

[Manish Bajpai]

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

 

[Manish Bajpai]

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

 

[buffalo411]

Thank you so much for your help. that save me a ton of
work.

 

[Kevin]

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
.