Excel Search

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to run a search in excel that runs in the same row across columns from
Right to Left and understands to skip empty cells and stop as soon as it gets
to a cell with any number in it. I would put this formula in a totals column
on the far right so i dont have to manual update data. Thank You
 
=LOOKUP(9.99999999999999E+307,A2:K2)

would return the last numeric value from A2:K2.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Hide columns based on row values 2
Excel VBA 1
Help needed 0
search function 2
using the =page! feature to transpose a row to column 0
Lookup Across Multiple Rows / Columns 5
Nameing a function 1

Back
Top