Jamieneedshelp
New Member
- Joined
- Jan 24, 2024
- Messages
- 23
- Office Version
- 2019
- Platform
- Windows
Sorry to be a bother. Someone here very kindly created a filter for me which worked perfectly for what I needed, however, I've now realised I need it to be in an older version of excel that doesn't have the =Filter function. Can anyone help me with convert the below to work in the old version
=FILTER(FILTER($A$61:$T$68,$A$3=$A$60:$T$60,""),FILTER($A$61:$T$68,$A$3=$A$60:$T$60,"")<>"","")
=FILTER(FILTER($A$61:$T$68,$A$3=$A$60:$T$60,""),FILTER($A$61:$T$68,$A$3=$A$60:$T$60,"")<>"","")