CODEWITHSUNDEEP
excelexcel-formula
Valami
Valami

Reputation: 39

Find a value in Excel in the rightest place?

I have an excel table for example:

    A         B        C        D
1  Value1
2  Value2   Value1
3  Value1   Value3  Value4
4  Value2

Is there any way to find the value on the rightes place in a row? For example is there a way to get the values from each rows from column A..D?

With this wanted solution I would get:

Value1
Value1
Value4
Value2

Is there any excel formula to get this wanted solution?

Upvotes: 0

Views: 523

Answers (1)

rwilson
rwilson

Reputation: 2145

Insert this formula and adjust the range 1:1 as necessary to avoid circular references:

=LOOKUP(REPT("z",255),1:1)

enter image description here

Upvotes: 2

Related Questions