Here is a quick tip that I learned while conducting training classes in Australia.
If you have several dates in a range and you want to find out what the latest date is, just use MAX, like:
=MAX(A1:A10) would give you the latest date.
A Question…,
Assuming you have some dates (not necessarily sorted) in column A, which formula finds the last date (not latest)?
Bonus question: What if there are some gaps (cells with no value)? How would you find the last date?
Go ahead and post your answers in comments. Or share your favorite formula to find latest date in a range.
PS: My Australian trip is over now. On a train from Melbourne to Sydney now and will be leaving to Vizag via Bangkok (and Hyderabad) early tomorrow morning. I am very happy how the whole thing went. More on this later next week.
3 Responses to “Top 5 Excel Skills you need to be a Successful Data Analyst in 2023 (podcast)”
Thanks Chandoo, some great helpful tips here. I'm quite good at Excel (mainly thanks to you!) but I'm always learning. I love the link you gave above to Dynamic Arrays & Spill Ranges, I understand them a bit more now, and can see some uses for them.
I am glad you enjoyed the show Dermot.
Great to see you back! Enjoyed when you first started the podcast and super excited to start listening to you again!