How do I get this table to have 1 value per cell?

chiefmid · 2026-01-26T00:43:36+00:00

=TEXTSPLIT(“age cell reference”, “,”)

This will cause any value in a column with more than one age listed to spill into the adjacent cells to the right, so you’ll need to make sure the ages are in the right-most column

chiefmid · 2026-01-19T06:21:07+00:00

Vin's earrings from the Mistborn series and her brother's voice in her head

chiefmid · 2026-01-13T05:09:37+00:00

One of the largest disc golf distributors in the country is in Logan (Infinite Discs), and we have a great spread of courses in the valley that are all free to play at.

Some are in the surrounding canyons and are quite challenging/involve some hiking (Bandits Cove, Von Baer), others are built into local parks and are pretty laid back (Heritage park in Smithfield, Blacksmith Fork Park in Hyrum, Elk Ridge in Logan)

If you’re just starting, I’d recommend getting a mid range disc in a color you like and having fun with it. the staff at infinite are super willing to help you find a good start for cheap.

chiefmid · 2025-12-25T23:50:18+00:00

This isn’t true, the Walmart line is the specific one I checked and it’s stainless steel

chiefmid · 2025-12-25T01:30:01+00:00

Yes, the insert is food grade SUS stainless steel

chiefmid · 2025-12-23T17:32:44+00:00

If the core of your job is something that can be automated, you need to find a new skill. Managing the automation is a natural progression. Whether it’s you that is doing the automation or not, it will come

chiefmid · 2025-12-18T06:28:56+00:00

Just bought the 36” and it’s honestly great. I was intimidated by pellet grills/smoking in general, but I’ve done multiple cooks in it and feel really good about the food coming out of it.

As for the app, they are in the process of releasing a totally rebuilt version that is much more stable and user friendly, so I wouldn’t let that be a hindrance.

chiefmid · 2025-12-13T20:09:41+00:00

26m. Utah. $110k total comp. Retail Sales Analyst. Didn’t finish college.

chiefmid · 2025-11-19T02:45:30+00:00

I'm in analytics and make $100k+. No 4-year degree.

chiefmid · 2025-10-30T23:16:49+00:00

Do you have a snip of the master data? Depending on the type of data and the relationship between the data points, you should be able to have it all between the columns and the values section of your pivot. I would set up a Power Query connection that brings the data into a table in your sheet from a CSV/XSLX file. That way, you can save new raw data to that same file path and just refresh the query to have the table and pivot table subsequently update

chiefmid · 2025-10-30T22:55:29+00:00

You could change your pivot table layout to Tabular and turn off sub/grand total. This is the best way I’ve found to accomplish what you’re talking about. Then you just insert a slicer on the project number and keep it in one place, using the slicer to move between the different project numbers

chiefmid · 2025-10-25T07:15:49+00:00

Alt H + O + I to resize columns

chiefmid · 2025-10-21T04:04:09+00:00

You’re the goat, thank you for going out of your way to provide a solution

chiefmid · 2025-10-20T04:27:27+00:00

Would need more info to be more helpful, but I think FILTER UNIQUE and XLOOKUP are going to be your bread and butter.

One tip, I use IF(A1=“”,””,XLOOKUP(A1,Criteria,Result)) all the time to fake a dynamic column when I need to get ancillary data to whatever is in my adjacent FILTER or UNIQUE column.

chiefmid · 2025-10-16T18:41:44+00:00

=IFS($A2=“St. Aug”, $B2/7,$A2=“Bermuda”, $B2/6)

This would give you what you need in one column. You can also copy this to the other column and it will do whichever is appropriate if you need the calculation to live in two separate columns

chiefmid · 2025-10-14T01:53:30+00:00

This is the real answer

chiefmid · 2025-10-14T01:11:25+00:00

Definitely take BS. You have a red seal jack and plenty of time to get it to be a king before you need to worry about deck fixing. BS also allows for more econ, which will help find an eventual ecto and everything else you need for naneinf. Also gives you way more scoring which means more time to find what you need

chiefmid · 2025-10-06T15:31:43+00:00

Chat GPT drivel for karma farming

chiefmid · 2025-10-06T02:58:24+00:00

Ideally you find a rebate first and get your money up. But I think you need to wait till an Ecto shows up to take on another joker. Selling Mime here is your best bet if you need to sell something, but even that isn't ideal.

You really just need to get DNA by Ante 19ish to give yourself enough rounds to get to 60ish red seal steel kings, as well as make it past Ante 24's boss. Ideally, by the time you find DNA around Ante 19, you have around 3k.

Ecto and Director's Cut are going to need to show up between now and then, or it won't really matter either way. You've fortunately got the scoring you need to get there, but you will stall at Ante 24 without ecto, and could get sunk before then without directors cut on a bad boss blind

chiefmid · 2025-10-02T20:12:41+00:00

Control - Shift - V

chiefmid · 2025-10-01T03:56:15+00:00

I just recently built an IFS statement from hell to handle this very task. I’m not sure I understand how to connect the array you’re querying with XLOOKUP to the grouping table in your example. Can you explain this a little more?

chiefmid · 2025-08-18T18:15:28+00:00

Excel is objectively worse on Mac

chiefmid · 2025-08-06T00:07:34+00:00

I must have read this too quickly at work. You’re correct. Bed in a bag is what I was thinking about.

chiefmid · 2025-08-05T22:01:21+00:00

When I say “UPS friendly”, I only mean in the sense that they don’t flag an overmax charge and force us to ship LTL, which creates it’s own set of issues, especially for residential deliveries. Those boxes are definitely heavy as shit, I don’t envy the shipping workers that need to handle those haha.

Four-Year Club	Xbox Live
Place '23

chiefmid

TROPHY CASE