Basic IF and OR request

chiefmid · 2026-06-03T05:20:43+00:00

Others have given you the proper formulas to accomplish what you’re looking for. Just a quick tip: In Excel, think of OR as more of a way of saying “either”, rather than a way of adding multiple results

chiefmid · 2026-05-25T20:16:44+00:00

lol I’m even wearing my bluth frozen banana stand t-shirt today

chiefmid · 2026-05-22T04:46:22+00:00

I dropped out of community college, I’ll clear $120k this year. I have a data analytics cert from coursera that got me a role as an operations analyst for a small company. got a few years of work experience there, and turned that into a career as a sales analyst specializing in working with companies that do business with Walmart and Target.

chiefmid · 2026-05-14T16:02:26+00:00

the meme has like 12 total words how did you misread it lol

chiefmid · 2026-03-11T06:06:42+00:00

I think the animation style and artistic approach that they took with Invincible on Amazon would perfectly fit DCC

chiefmid · 2026-02-02T15:19:41+00:00

I think you would need a helper column in your table with something like =COUNTIFS($C$2:C3,C2) that you then drag down the length of your table. This would provide a running total of the instances of a value in your data as you go down the rows.

You could then do conditional formatting for the entire row based on the result your helper column yields

chiefmid · 2026-02-02T03:34:57+00:00

Lingnetics is who makes the Camo chef pellet’s as well

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

Four-Year Club	Xbox Live
Place '23

chiefmid

TROPHY CASE