for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

101 watchers

um May 2023 4:56pm, 16 May 2023 7,396 posts	0 um What version do you have? If 2019 or beyond, there's a FILTER function : support.microsoft.com
um May 2023 5:03pm, 16 May 2023 7,397 posts	0 um Failing that, I'd suggest filtering the complete file and then pasting to separate sheets. Or have separate sheets for each office and set a macro (just record what you do) to run each time. Checking that any selection of results is either generically coded, or selects way more than you'll ever likely need.
JK chameleon May 2023 7:44pm, 16 May 2023 17,681 posts	0 JK chameleon Oh, thanks both. Filter looks handy, not sure VLookup will work as it's not a sorted list - but they're a couple of good ideas to set my brain at tomorrow
Fizz :-) May 2023 8:03pm, 16 May 2023 7,994 posts	0 Fizz :-) It’s xlookup - newer and better (although the experts on here would probably disagree )
JK chameleon May 2023 8:07pm, 16 May 2023 17,682 posts	0 JK chameleon Ah, well spotted. Never used (or heard of) xlookup so that's something to play with. Cheers all!
larkim May 2023 9:00pm, 16 May 2023 21,118 posts	0 larkim Vlookup doesn't need a sorted list if you use the ,false) final clause. Though index(match) is technically better I believe - I usually forget the syntax though!
GlennR May 2023 9:42pm, 16 May 2023 70,265 posts	0 GlennR I do index(match) automatically. I haven't looked at xlookup yet though.
Joe Hawk May 2023 10:19pm, 16 May 2023 5,769 posts	0 Joe Hawk Hi All I have a spreadsheet that I download and then need to seperate in to multiple sheets as per the info in column A is there a way to do this via a macro or VBA ? Currently I am filtering and copy / paste which is a pain.
SPR May 2023 10:25pm, 16 May 2023 40,533 posts	0 SPR I also do Index match automatically. Xlookup looks good although given its not in 2016 or 2019 I'll probably stick with Index match.
GlennR May 2023 11:14pm, 16 May 2023 70,268 posts	0 GlennR Office 365. Get with the groove, dad-i-o.