for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

1 lurker | 102 watchers

Snail Aug 2023 5:33pm, 5 Aug 2023 2,187 posts	Quote Pin Snail Thanks Um (Not sure you can be tagged as your name is 2 rather than 3 letters) - for the "SMALL" function advice, a couple of weeks back - it did the trick - Thanks
Bowman 🇸🇪 Aug 2023 6:03pm, 5 Aug 2023 2,884 posts	Quote Pin Bowman 🇸🇪 Thanks Um (Not sure you can be tagged as your name is 2 rather than 3 letters) - for the "SMALL" function advice, a couple of weeks back - it did the trick - Thanks You can if you get his id on the site which is 43889 Here you go um
Snail Aug 2023 6:21pm, 5 Aug 2023 2,188 posts	Quote Pin Snail Thanks Bowman 🇸🇪
um Aug 2023 7:06pm, 5 Aug 2023 7,617 posts	Quote Pin um No worries on the tagging, I follow the thread so I'd see it anyway. I'd never heard of SMALL until I started looking at a solve, so thank you as well!
GregP Aug 2023 8:16am, 18 Aug 2023 147,494 posts	Quote Pin GregP This is basic (I hope and assume), I've just not needed to do it before Green 1 Blue 2 Yellow 1 Red 2 Black 2 Brown 2 Maroon 1 (say - two columns) I want another column to automatically just have all the 1s in it Green Yellow Maroon Help?
um Aug 2023 8:41am, 18 Aug 2023 7,652 posts	Quote Pin um How about a variant of my function fun from page 415 Greg? Or use the Filter function. (2019 version onwards, or as run free said a page or two back, free on line if you have a microsoft account)
GregP Aug 2023 8:46am, 18 Aug 2023 147,496 posts	Quote Pin GregP Thanks Um - I'll have a look. I just tried something else and got a "formula spilled" error. That's a new one on me.
GregP Aug 2023 9:01am, 18 Aug 2023 147,497 posts	Quote Pin GregP I was trying something deeply simple and optimistic: =IF(C2:C8=1, B2:B8)
SPR Aug 2023 9:13am, 18 Aug 2023 42,248 posts	Quote Pin SPR I surprised you got a spill error on that range rather than the results (which would be unfiltered). You basically need to put that criteria in filter as Um suggests. Then you won't get the false results. =FILTER(B2:B8, C2:C8=1)
GregP Aug 2023 11:56am, 18 Aug 2023 147,499 posts	Quote Pin GregP SPR I love you and I want to have your babies. That's absolutely perfect.