Excel

I made this spreadsheet to calculate minecraft item prices based on the time it takes to produce them but im having trouble to select the proportion of each item to divide the time (and value) between them, i need to be sure that each item is at least the average price for that item in the market. if they cant it means i dont produce with an average technique.

cross-posted from: https://sopuli.xyz/post/13827941

IMHO same as previous month. Not much. Some usual improvements to web version, some new copilot AI.

For the latter in some way it's cool for non advanced users but in others what would be their ability to check for complex formulas if there is no shortcomings in what copilot proposed or what they asked.

Summary from article :

Generating multiple formula columns, creating complex formula columns that span across multiple tables, and new ways to engage with Copilot in Excel are now available to Excel users on web and Windows. Copying and pasting improvements and sharing links to sheet views are also available in Excel for the web, and the ink to text pen is rolling out to Insiders running Excel for Windows.

cross-posted from: https://lemmy.world/post/13779795

Microsoft is introducing Python in Excel as a Public Preview for Microsoft 365 Insiders in the Beta channel.

I’ve been making charts forever and whenever the data is negative, I move the x-axis labels to bottom-centre to get them out of the way of the bars. Suddenly, this isn’t working anymore.

I choose ‘bottom-centre’ or ‘middle’ and they just don’t move.

Any suggestions?

Attached is a Google pic of what it should be doing. Note the x-axis labels are at the bottom (A, B, C, D etc). I can’t move mine at all.

No, the options to move the labels aren’t greyed out. They’re selectable, they just do nothing.

EDIT: Fixed. It’s been moved to Labels > Labels Position. There must have been an update.

Immediately humbled by gigachad index match

Had to vent somewhere; spent a few week on and off developing a compensation system in Excel and PowerBI for a company with several divisions. Pretty simple stuff; they just wanted to benchmark and log compensations across different geographies.

In order to populate some dropdowns I used the functions SORT, UNIQUE and FILTER for the first time. Was told all clients use Excel 2019 whereas I have a office 365 subscription. Well it turns out these functions are not available in excel 2019 home and business; only in the Office 365 version. (Even though I checked the version numbers of excel and we were all using the same).

What kind of money grabbing scheme is this.... Was a simple workaround by creating the same functionality with a few lines of VBA but even so.....

I'm using Google Sheets. In column A there are dates at irregular intervals. In column B there are names of fruit. I'd like to add some conditional formatting depending on the date corresponding to the fruit or, if the fruit doesn't have one, the lowest one above it (you may assume there will always be a date in cell A1). The effect is that a date affects the fruit next to it and all consecutive fruits up until the next date given.

I imagine I'd have to add a lookup by criterion NOT(ISBLANK()) to the conditional formatting custom formula. Is there a function that could do that? Is there some other way I can achieve the desired result?

Example image: