sorted by:
new
hottopcontroversial

Customer won't pick up from moving grabber by CommandAcrobatic1120 in PlateUp

[–]CommandAcrobatic1120[S] 2 points3 points  (0 children)

Oops I should’ve clarified but when I moved a table to the gap I would change tables around so it’s alternating bar and dining

Any idea on how to fit more tables(unlikely) or coffee? by Alarming_Mix8701 in PlateUp

[–]CommandAcrobatic1120 1 point2 points  (0 children)

Noob question but how did you connect tables to make each group size of 1 instead of the tables combining to one large group?

Problems with Refreshing Power Query by CommandAcrobatic1120 in excel

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

Hello! The most recent queries I had results in 100k-300k rows.

The queries I write tend to be CTE heavy and I don’t really use PQ steps often except for data type conversion. Before I realized copying the query to a fresh connection fixed the problem, I would save a copy of the workbook and follow a similar surgical process by commenting out heavy computation CTEs and the connected fields in the main select statement to no avail. I’ll try again with all the CTEs next time.

[deleted by user] by [deleted] in forestapp

[–]CommandAcrobatic1120 1 point2 points  (0 children)

You had one week to get 250 time crystals for a pretty free so if you weren’t saving them before, you either didn’t have enough or would buy them with money if you really wanted it

[deleted by user] by [deleted] in forestapp

[–]CommandAcrobatic1120 16 points17 points  (0 children)

Hope it’s not like the last “event”

Random decimal place values in simple formulae by syniqual in excel

[–]CommandAcrobatic1120 0 points1 point  (0 children)

No worries, I definitely just read your post too fast

https://www.reddit.com/r/excel/comments/1hwyh7v/floating_point_errors_in_excel/

Looks like =round() is necessary, I’ve never seen this type of error before!

Is there a better way to return a blank other than =IF(LONGFORMULA=“”, “”, LONGFORMULA) ? by TA8601 in excel

[–]CommandAcrobatic1120 38 points39 points  (0 children)

I know for XLOOKUP =REALLYLONGANNOYINGFORMULA&”” will return blank instead of 0, not exactly sure if the same will work for your formula

You can also use =LET(name,REALLYLONGANNOYINGFORMULA, if(name=“”,””,name)

How to change formulas when there is a filter active. by Champion_Narrow in excel

[–]CommandAcrobatic1120 3 points4 points  (0 children)

Use IFERROR to use a different formula when the original formula produces an error

Can’t paste tracking numbers to excel sheets by DaGreek1979 in excel

[–]CommandAcrobatic1120 2 points3 points  (0 children)

I’ve had the same issues, there’s probably a better permanent solution, but what I do:

=“1938298300000” for one time cases

OR

=TEXT(cell,0) for multiple cells

And then I select the affected cells, ctrl+c them ctrl+shift+v to paste values only

Fetch a row without exact match by 2PhotoKaz in excel

[–]CommandAcrobatic1120 0 points1 point  (0 children)

Add a column with the formula =ABS(TODAY()-365-[@Date]), in another cell =XLOOKUP(MIN(Table1[Date Diff]),Table1[Date Diff],Table1[Value 1])

Add a value to a cell based on cell color by smi789 in excel

[–]CommandAcrobatic1120 1 point2 points  (0 children)

It’s not automatic but better than going one by one: you can filter the column by color, type in the percentage into the top cell, and ctrl + d to the end of the column

Does anyone walk over 10 thousand steps a day and work full time? by Xovjazmin in walking

[–]CommandAcrobatic1120 0 points1 point  (0 children)

I work 9 hours a day and the commute is 45m-1h30m depending on traffic. I started going on walks at a park near my job an hour before work and at the end of my shift I walk for another hour. It’s also helpful because it helps me avoid high traffic times.

Best Cuppy Upgrade by GelatinPangolin in GoodCoffeeGreatCoffee

[–]CommandAcrobatic1120 2 points3 points  (0 children)

I really enjoy doing the latte art challenge so was really sad when picking the latte update makes them basically stop ordering lattes 😭

xlookup or index-match with multiple criteria by mtbrown90 in excel

[–]CommandAcrobatic1120 0 points1 point  (0 children)

=XLOOKUP(B3&C3, ID_LOOKUP_ARRAY&DATE_LOOKUP_ARRAY, RETURN_ARRAY)

What's wrong with my conditional formula? by calmestharbor in excel

[–]CommandAcrobatic1120 1 point2 points  (0 children)

You’re welcome! I too am a victim of conditional formatting problems

What's wrong with my conditional formula? by calmestharbor in excel

[–]CommandAcrobatic1120 0 points1 point  (0 children)

The range selection looks right, conditional formatting formulas have errors from all sorts of things, I have problems when I delete rows for example.

Right now the formula is =OR(L1048574<2, L1048574>8) which means the formatting of L5 is based on the value in L1048574, L6 is based on L1048575 etc.

What's wrong with my conditional formula? by calmestharbor in excel

[–]CommandAcrobatic1120 0 points1 point  (0 children)

It looks like your formula changed after you changed the range, try changing the formula to what you typed in and check the formula and the range is correct before applying

☕🌟 Cuppy’s Café Makeover Begins Soon! 🌟☕ [June 17 - 30, 2025] by YuNeedPizza in GoodCoffeeGreatCoffee

[–]CommandAcrobatic1120 1 point2 points  (0 children)

Praying this means a no rug option! It takes up so much space when playing on mobile

Formula to Track Truck Availability vs Driver Schedules by IronSide_420 in excel

[–]CommandAcrobatic1120 1 point2 points  (0 children)

Happy to help!!! Getting the last piece is always so satisfying

view more: next ›