Sorting the highest value with dates
Closed
josh07429
Posts
14
Registration date
Friday June 23, 2017
Status
Member
Last seen
November 20, 2017
-
Jun 23, 2017 at 02:58 PM
Blocked Profile - Jun 27, 2017 at 05:00 PM
Blocked Profile - Jun 27, 2017 at 05:00 PM
Need help with formula or script
Where I need to look for the Van's highest Passenger# with the latest month available

for example
van 800's latest month is 6(JUNE) and his highest passenger # is 13, I need to get 13 and delete the other van 800
van 805's latest month is 5(MAY) and his highest passenger # is 14, I need to get 14 and delete the other van 805
I need a formula or script that will look for the vans latest month and highest passenger #
Thanks in advance
Where I need to look for the Van's highest Passenger# with the latest month available

for example
van 800's latest month is 6(JUNE) and his highest passenger # is 13, I need to get 13 and delete the other van 800
van 805's latest month is 5(MAY) and his highest passenger # is 14, I need to get 14 and delete the other van 805
I need a formula or script that will look for the vans latest month and highest passenger #
Thanks in advance
Related:
- Sorting the highest value with dates
- Sorting bookmarks in chrome - Guide
- Different dates of "end to end encryption message" on blank chat? - Excel Forum
- Instagram comment sorting - Instagram Forum
- Defcon dates - Guide
- Annual mileage calculator with odometer dates ✓ - Excel Forum
2 responses
No, you need to just sort the list. Highlight the columns you would like to sort in order, and select SORT. No programming needed!
But if you must, take a look at this:
The key1 entry is the column you wish to sort by!
But if you must, take a look at this:
Range("A6:AZ9999").Sort key1:=Range("AW5"), _
order1:=xlDescending, Header:=xlNo
The key1 entry is the column you wish to sort by!
Jun 23, 2017 at 04:56 PM
I am trying to create a macro tool that will sort the list to get the A(Van#) with the latest month(column B) that has the highest value(passenger #) then eliminate the duplicates with low passenger number and old month
If you could help me with the macro script that would be great.
this is just 1 process from the tool i am creating the resukt from this worksheet will be reference to my vlookup to get the correct columnC (highest passenger #)
Updated on Jun 26, 2017 at 04:29 PM
Have you looked into the MAX function? SOmething like:
=MAX(A1:A16)
Jun 26, 2017 at 04:52 PM
I tried to change to date by using =month so that i can get the numbers of the month instead of the whole date then I tried using MAX twice like get van#300 and its max in column B then get its max in column C. but its a little trickier that i thought lol
Jun 26, 2017 at 04:57 PM
Hang in there!