On a number of forums, I found the following suggested formulas for returning the last TEXT value in a column. These are pretty good and they allow the range to include blanks, error values (like #N/A), and numeric values.=VLOOKUP(REPT("z",255),A:A,1) or=INDEX(A:A,MATCH(REPT("z",255),A:A))(For the formula that returns the last NUMERIC value in a column, see my previous post)I prefer the formula
. Read More........
Tampilkan postingan dengan label lookup. Tampilkan semua postingan
Tampilkan postingan dengan label lookup. Tampilkan semua postingan
Return the Last Numeric Value in a Column
Returning the final value in a column is particularly useful for spreadsheets that involve running balances, where you want to reference the final balance regardless of whether it is the smallest or largest value in the column.After trying a variety of different formulas for returning the last numeric value in a column, I settled on the following two.=VLOOKUP(9.99999999999999E+307,A:A,1) or=
. Read More........
Langganan:
Postingan (RSS)
