Determine what the common factor is in these βrandomβ data points and filter them out somehow, perhaps using Power Query?
24.07.2025 05:43 β π 0 π 0 π¬ 1 π 0@ronh.bsky.social
Determine what the common factor is in these βrandomβ data points and filter them out somehow, perhaps using Power Query?
24.07.2025 05:43 β π 0 π 0 π¬ 1 π 0They already have that limitation and sometimes it is stupid cause even the passenger canβt change certain settings while moving.
06.05.2025 15:15 β π 1 π 0 π¬ 0 π 0Walmart, Amazon, eBay
04.05.2025 20:30 β π 1 π 0 π¬ 0 π 0Good luck, I hope he/she will be found soon! (Maybe itβs good to list in which state this is)
20.04.2025 00:52 β π 0 π 0 π¬ 1 π 0I 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.
13.04.2025 16:42 β π 4 π 0 π¬ 1 π 0Hereβs your answer: they wipe their beak on something suitable.
13.04.2025 16:23 β π 5 π 0 π¬ 1 π 0Jog on? Is that a variant of FO? Cause she really should dtmfa.
12.04.2025 17:18 β π 6 π 0 π¬ 0 π 0Thanks to our bird feeder I can now recognise some birds by their butt
12.04.2025 17:11 β π 8 π 1 π¬ 2 π 0I donβt know if this helps or is good enough? Looks like there might always be AM/PM regardless of country settings.
05.04.2025 22:10 β π 1 π 0 π¬ 2 π 0You mean they didnβt criticise Biden?
05.04.2025 15:46 β π 0 π 0 π¬ 0 π 0Iβve got stuff to do butβ¦..
27.03.2025 15:28 β π 14 π 1 π¬ 0 π 1She 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
26.03.2025 23:53 β π 3 π 0 π¬ 1 π 0Or, 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
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
12.03.2025 22:37 β π 0 π 0 π¬ 1 π 0Wait π€ all rows into one. Like this? (I used BYCOL over several columns and that spills to the right.
12.03.2025 21:44 β π 0 π 0 π¬ 1 π 0Sheβs going for the peanut butter on the banana.
12.03.2025 15:11 β π 1 π 0 π¬ 0 π 0I 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.
10.03.2025 17:54 β π 0 π 0 π¬ 1 π 0π€ 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.
Freshly baked lemon cake. (Trust me; Molly also gets all the good healthy bird food too)
@lavawitch.bsky.social
Molly might like banana bread better than banana on bread.
If she makes these sounds while eating it means she really does like it. @lavawitch.bsky.social
Look at the date amp.cnn.com/cnn/2024/07/...
27.02.2025 01:12 β π 0 π 0 π¬ 0 π 0They already did a year ago?
amp.cnn.com/cnn/2024/07/...
Not her favourite, but Molly does eat banana @lavawitch.bsky.social
27.02.2025 01:06 β π 130 π 5 π¬ 4 π 1Yep. Dtmfa, RUN
24.02.2025 17:42 β π 9 π 0 π¬ 0 π 0Yes π
23.02.2025 21:14 β π 2 π 0 π¬ 0 π 0Beak grinding @lavawitch.bsky.social
23.02.2025 19:12 β π 58 π 2 π¬ 7 π 0Tolerates? Sometimes she tries to stop me from cutting the banana cause she wants a bite first.
21.02.2025 19:01 β π 7 π 0 π¬ 0 π 0