Forum Discussion
Solved
Help with filtering out data
Hi, above is a works holiday sheet. I want to be able to find out what weeks a specific person appears in. I.e. 'C.Hipkiss' has w/c 'a,b,c & d' off. I've used a VLOOKUP to what find who's off o...
PeterBartholomew1 's formula only works in Excel for Microsoft 365 Insiders.
In the attached workbook you'll find an 'old-fashioned' formula that should work in all versions of Excel. It uses a helper column.
Thanks for all the replies and answers. All very helpful. I actually think I'm running 365 on my laptop but the spreadsheet I'm working on is from work which is based on an older version of excel which caused some issues.