for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

102 watchers

JCB Aug 2023 1:14pm, 1 Aug 2023 4,403 posts	Quote Pin JCB Well done! 🏆
JK chameleon Aug 2023 10:01pm, 1 Aug 2023 17,804 posts	Quote Pin JK chameleon Holy shitballs that looks incredible! Hopefully my tomorrow will be spent painstakingly trying to understand and adapt this, and not dealing with whiny team members preventing me from doing the above!
run free Aug 2023 12:49am, 2 Aug 2023 5,317 posts	Quote Pin run free Great work Um. Also agree will have performance issues and difficult to maintain. If you have a hotmail account, you should be able to check the latest ms Apps online..... just like Google docs
um Aug 2023 8:28am, 2 Aug 2023 7,586 posts	Quote Pin um Too good to be true? or is this the going rate for office these days? ( £4.79 ) gamers-outlet.net How do I get access to check the latest online run free? (I have an outlook rather than hotmail email, but I guess I could get hotmail if needed)
run free Aug 2023 5:28pm, 2 Aug 2023 5,318 posts	Quote Pin run free Yes just get a hotmail account
um Aug 2023 5:51pm, 2 Aug 2023 7,588 posts	Quote Pin um Thanks run free, my outlook MS account gave me access, once I allowed it to open new windows. Just an xxx@outlook.com email, And the I found the filter formula replace my complex workings with a single entry, in sheet2, same data as before, where the data was in sheet1 and I put the desired match date in sheet2 cell A1. Then enter, wherever you like, I used A3 : =FILTER(Sheet1!A2:C48,Sheet1!A2:A48=A1,"") (syntax is array, match, value if empty) Just a touch easier
run free Aug 2023 5:59pm, 2 Aug 2023 5,319 posts	Quote Pin run free
JK chameleon Aug 2023 11:15am, 3 Aug 2023 17,809 posts	Quote Pin JK chameleon run free & um - thank you SO MUCH. I had to do a little jiggery pokery (oo-er) to sort the date formatting out (having to strip out the time of the form's completion as 01/08/23 16:00 <> 01/08/23) but that only bloody works beautifully. I am one extremely happy Jamie right now.
run free Aug 2023 12:18am, 4 Aug 2023 5,320 posts	Quote Pin run free Great work JK FYI: 01/08/23 = 01/08/23 00:00
JK chameleon Aug 2023 6:13am, 4 Aug 2023 17,810 posts	Quote Pin JK chameleon Ta - I've got a RoundDown sorting out the timestamps. My new allocation process for the team goes live on Monday, I can't wait to hear the complaints about it