Forum Widgets
Latest Discussions
Formula help - daily pay vs supplement monthly payments
Hi all, I have two sets of data for bonus calculations. SET ONE is in multiple rows by employee, e.g. the annual pay from 1 Jan to 31 Mar. Then 1 Apr to 31 Dec - when their pay has changed from 1 Apr onwards. And then a count of the number of days per row. I use this count to calculate the annual bonus. SET TWO is any annual supplement paid, by calendar month, that I need to split by days relevant to their pay in SET ONE and add to their salary for that period. So how can i take the data in SET TWO, and split by the same time period in SET ONE - and cut the Supp Amount and add to the Supplement Row column, thus updating the Total Paid column? I have 2k employees to calculate e.g. Thanks
Help with a Formula
Below is a formula I created to return specified rows and columns for a sheet named Detail and in the case or column 49 detect if there are comma separated values and explode them into separate columns. The formula works when there Is not comma separated values and returns and error #VALUE! instead. Can someone help me with this formula? =LET( f, FILTER( Detail!$A:$BZ, (COUNTIF($B$16:$B$25, Detail!$BP:$BP) > 0) * (TRIM(SUBSTITUTE(Detail!$AW:$AW, CHAR(160), "")) <> "")), base, CHOOSECOLS(f, 1,3,4,5,68),split49,TRIM( TEXTSPLIT(SUBSTITUTE(CHOOSECOLS(f,49), CHAR(160), ""),",")), split53,TRIM(TEXTSPLIT(SUBSTITUTE(CHOOSECOLS(f,53), CHAR(160), ""),",")), SORT(UNIQUE(HSTACK(base, split49, split53)),1, TRUE))Welcome to the Excel Community
The Excel Community is a place we've built for all of you. You can learn more about how to do something with Excel, discuss your work, and connect with experts that build and use the product. With over half a billion Excel customers, we want to engage with you in fundamentally different ways and the community is a starting point for that. Our community helps answer your product questions with responses from other knowledgeable community members. We love hearing feedback and feature requests from you which helps us build the best version of Excel ever. If you have found an outage or a bug please post at our Answers forum. We look forward to getting to know you! Sangeeta Mudnal & Olaf Hubel on behalf of the Excel Team
Excel template
In our company we have created our own inhouse Excel style. I've made this into a template by merging the style with a new workbook and saved this as a .xtlx file. I've saved this in all the XLSTART folders I could find, but also in the custom template folder. This should be enough to be able to start up Excel and see all the cellstyles we have created. Unfortunately this doesn't work. When I open a new worksheet, the styles are not visible. I've troubleshooted with Copilot, and tried all it suggested, but nothing worked. I've restarted Excel and my computer, but that doesn't change anything. What am I doing wrong?
Cannot delete a macro
Windows 10 desktop computer, Excel I recorded a macro, seems to have an error. Want to Delete it and try again. When I go into Macros, I see it listed and highlighted (it is the only one), try to click Delete, but get message : "Cannot edit a macro on a hidden workbook. Unhide the workbook using the Unhide command" Don't know what this means. I don't know of any hidden workbooks, never did anything to hide any workbook. Help for "unhide" says go to Home-->(Cells) Format-->Visibility-->Hide&Unhide, but when I go there, the entry for Unhide Sheet is grayed out. so cannot do that anyway. I just want to delete the macro I recorded before and try to record it again to get rid of whatever error it contains. This is a macro I intended to use in any Excel workbook and is listed as PERSONAL.XLSB!(name) and below the list of Macro names there is a box Macros in: All Open Workbooks It is the only macro listed, there are no others.Excel "IF" function
I'm creating a spreadsheet for my golf club. We have special rules. One of them is that if a player has fewer than 30 Stableford points after a round, their handicap increases by 1 point. Can I do this with an "IF" function? And what would that look like? I have separate columns for stableford points and handicaps.
