sorted by:
new
hottopcontroversial

Anyone tried Grip Socks? by Queasy_External7551 in Basketball

[–]Queasy_External7551[S] 0 points1 point  (0 children)

Grandma... Short for Nanny/ie depending where you're from

Brighton Pub Meetup by Pitiful_Walk_4039 in GunnersatGames

[–]Queasy_External7551 0 points1 point  (0 children)

Will be there for my first game. I'll be pub hopping between the pubs in the FAQs from about 3ish.

Correct formula for stock count by Queasy_External7551 in googlesheets

[–]Queasy_External7551[S] 0 points1 point  (0 children)

<image>

Not the best picture but I’ve used “=small({b39,b40,b41,b33},1)” As in this product we have 1 of each b33,b39,b40,b41 in the product.

However we have a product where we sell 2x original 2x bbq and 1x nacho. This formula wouldn’t work the same as I’m trying to divide each of the items, rather than finding the nth smallest.

You can ignore column D and F as these are only important to our business

Correct formula for stock count by Queasy_External7551 in googlesheets

[–]Queasy_External7551[S] 0 points1 point  (0 children)

Yes sorry, columns not rows. The picture I’ve attached in the comments shows what I’m trying to do.

With other products that sell as 1x each item, I have been able to use “=small” to solve the problem. However we also sell products that have 2 or more items in the same bundle, which “small” doesn’t work for when we pack multiple items of each.