If I had a column of numbers starting from A1
1
1
2
2
2
3
3
What formula would give me the row number of the first instance of the largest value inside the column? In this case, it would be row 6 because that's where the largest number 3 first appears down the column. Many thanks, y'all.
Try
=MATCH(MAX(A:A),A:A,0)
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
that did the trick, many thanks
Glad it helped
VBA Noob
Ok Little more complicate.
Formula for returning last line # of a range of cell that has a value of 5 or more.
Born2fly,
Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks