ronh.bsky.social
@ronh.bsky.social
Determine what the common factor is in these “random” data points and filter them out somehow, perhaps using Power Query?
July 24, 2025 at 5:43 AM
They already have that limitation and sometimes it is stupid cause even the passenger can’t change certain settings while moving.
May 6, 2025 at 3:15 PM
Walmart, Amazon, eBay
May 4, 2025 at 8:30 PM
Good luck, I hope he/she will be found soon! (Maybe it’s good to list in which state this is)
April 20, 2025 at 12:52 AM
I remember that when this was an issue in the U.K. it was tracked back to bad procedures in slaughter houses. Incubation period can be 10 years. There is no cure, 70% dies in the first year after diagnosis.
April 13, 2025 at 4:42 PM
Here’s your answer: they wipe their beak on something suitable.
April 13, 2025 at 4:23 PM
Jog on? Is that a variant of FO? Cause she really should dtmfa.
April 12, 2025 at 5:18 PM
Thanks to our bird feeder I can now recognise some birds by their butt
April 12, 2025 at 5:11 PM
I don’t know if this helps or is good enough? Looks like there might always be AM/PM regardless of country settings.
April 5, 2025 at 10:10 PM
You mean they didn’t criticise Biden?
April 5, 2025 at 3:46 PM
She eats it too. But if there are traces of peanut butter she goes for that. I’m making peanut butter sandwiches with banana slices. Some days she doesn’t wait and eats banana. Other days she waits and goes for the peanut butter and seeds in the bread
March 26, 2025 at 11:53 PM
Or, if data is a table and you select the whole table range, you get this.
This is nicer cause it won’t accidentally count stuff under the first data area. If stuff is added to table the formula will catch that too
March 12, 2025 at 10:40 PM
What is a group? The company name? The bycol(range, sum) sums everything in the column range you specify. In my case the whole column, for all columns from B to E
March 12, 2025 at 10:37 PM
Wait 🤔 all rows into one. Like this? (I used BYCOL over several columns and that spills to the right.
March 12, 2025 at 9:44 PM
She’s going for the peanut butter on the banana.
March 12, 2025 at 3:11 PM
I tried to do it simple but you’re right it doesn’t work. I’ll give it some thought 🤔 if I do eventually figure it out I’ll let you know.
March 10, 2025 at 5:54 PM
🤔 does the area change?
If not then =sum(B2:G5)
Area changes: make it a table with totals horizontally and reference to the table total.
March 10, 2025 at 3:43 PM
Yep. Dtmfa, RUN
February 24, 2025 at 5:42 PM