creative999
Board Regular
- Joined
- Jul 7, 2021
- Messages
- 108
- Office Version
- 365
- 2019
- Platform
- Windows
- MacOS
Hi
I have a formula which shows the latest sale (below) but also need to show the second oldest. Any suggestions?
=IFERROR(INDEX(SORT(FILTER(SALES!A:M,(SALES!F:F=A1)),4,1),1,3),"--")
I have a formula which shows the latest sale (below) but also need to show the second oldest. Any suggestions?
=IFERROR(INDEX(SORT(FILTER(SALES!A:M,(SALES!F:F=A1)),4,1),1,3),"--")