I have sheets with many numbers in many rows and columns. I m making a statistic about the time, so the number on a row below the other one means that numbers showed up later. There are numbers that are in the sheet more than once, in a different row and column, but what I need is how to get the number of the last row that number is on? I m not sure if excel has a formula for it or if I have to write a macro to do it. If I have to write a macro, tell me how to do it if you can help.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
how to get the number of the last row?
- Thread starter Lottoguy
- Start date
That formula didnt work in my excel. It was saying and invalid formula. But someone else this morning told me to try this one, and it worked. It did exactly what I want. But thanks for your attention. This is my favority excel forum.
Upvote
0
Excel Facts
Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
