Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Find Date of highest and Second highest Values & lowest values in a Range Excel formula or VBA

Avatar of Adam Elsheimer
Adam ElsheimerFlag for Germany asked on
Microsoft OfficeMicrosoft ExcelVBA
4 Comments1 Solution209 ViewsLast Modified:
I am looking for a formula to find the Date/Time in Col A  for the highest & second highest Value in Col C. The same for the lowest value and second lowest value in Col D.

In sheet 1 is the data

1. Search the H1/H2 vice versa L1/L2 values in a range and extract the date/time
2.  Populate the extracted date/time in sheet 2 (calc)


Any assistance will be greatly appreciated.

Thank you.


Avatar of Rgonzo1971
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answers