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
VBAMicrosoft ExcelMicrosoft Office
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.


Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros