Finding the Right Most Cell in a Row with a Value in Excel

1. Select the cell where you want to display the result.

1. Use the following formula:
   Formula:

   =LOOKUP(2,1/(A1:X1<""),COLUMN(A1:X1)) 

2. Replace A1:X1 with the range of cells in the row that you want to search.
3. Press Enter to see the result.

This formula works by first checking if each cell in the specified row is not empty. If a cell is not empty, the formula returns the column number of that cell. The LOOKUP function then finds the largest value in the array of column numbers, which is the right most cell with a value in it.

Note that this formula assumes that there is only one cell with a value in the specified row. If there are multiple cells with values, the formula will return the column number of the right most cell with a value in it.