This is the value that the match would be looking for in the specified data set.Īnd the second argument is the range within which the MATCH function is going to look for the first argument.
The first argument is the lookup value (143^143 in the above formula). Here is the MATCH formula part: MATCH(143^143,A:A) In this example, I’m using an approximate match as I do not know the last number (and there is also a possibility that there could be repetitions)
When you do an exact match lookup, the MATCH function would only give you the position of the cell in case it finds the exact match. With the MATCH function, you can either do an exact-match lookup or an approximate match lookup. So, if I have a column that has 10 numbers (without any blank cells), the match function would give me 10, which is the position of the last cell with a number in the data set. I have used the MATCH function to find out the position of the cell that has the last number in the column. Now let’s understand the genius in this formula. In case you have a cell that has a text string after the last numeric value, this formula would still give you the numeric value. It also only gives you the last numeric value. The above formula would give you the right result even if you have blank cells in the dataset The below formula would do that: =INDEX(A:A,MATCH(143^143,A:A)) Suppose you have a data set as shown below, and you want to quickly know the last value in this data. Get the Last Number in a Column (when you have numbers) Get the Last Value in a Column (that has both Numbers & Text).Get the Last Number in a Column (when you have numbers).
0 kommentar(er)
