Forum Widgets
Latest Discussions
Rename Cell to Various Different Sheet Titles
Hi, I am trying to create a formula that allows me to have cells equal to the names of different sheets. I have read several interesting posts that created solutions for having a cell automatically change to the name of whatever its sheet is, however, I am trying to create a table that automatically fills out the rows as I add new tabs. For example: I add a new sheet and name it "March", the next column title in my table will be "March". Having to do it manually at the scale required would be quite difficult. I believe this may require the use of VBA, and my attempts to teach myself were not very fruit-full. Is this possible? Thanks in advance.Solveddanny1968Jul 10, 2025Copper Contributor115Views0likes5CommentsI need some design help
Hello Excellers, This is what I have: On a Worksheet lets call it Names I have: In Column A 6000 names of people. In Column B for each person I have a skill set codes. P,F,G,I P&I,F&G In Column C I have the time they started their shift In Column D I have the time they ended their shift I need: On a different sheet lets call it Assignments: To make In-Cell Data Validation with Drop Downs in such a way that: If I have a machine that requires Skill P ONLY the people with P or P&I will be in the data validation drop down list. If a machine needs G skill then ONLY the people with G or F&G will be listed in the data validation drop down list If a machine needs skill I only the people with skill I will be in the data validation drop down list Essentially I need to make each data validation drop down list be dependent on the value in the skill column on Sheet Assignments. Now I though of making multiple lists one for all the People who have P skill, one for all the People who have F skill, and one for all the People who have I skill, and so on, and even though the skill sets will change but not often, I thought maintenance will be an issue. Oh and if the person is not working today (there is no start time in Column C) then their name will NOT appear on any list! Also if the person leaves (there is a time in Column D) then the name will stop appearing on any list! Either VBA or worksheet formula solutions will be OK. Any ideas? Thanks in Advance. GiGIGeorgieAnneJul 09, 2025Iron Contributor45Views0likes1CommentExcel automation script: Can it open or get access to other Excel workbooks
Hi Team, Excel automation script: Can it open or get access to other Excel workbooks. And if not, do you think this might change in the near future. Many thanks JamesSolvedJames_PriceJul 09, 2025Copper Contributor50Views0likes4CommentsCalculate Due Dates, excluding Holidays and Weekends
Hello all! I would like to calculate a due date, excluding holidays and weekends. This is my data: The "COH Due" column is being manually entered, but I want it to be automatic. So, starting from whatever day is in the "Date Accepted" column, I want to add 7 business days to it. I'm not sure what formula I would need for that. Any help would be greatly appreciated. Thank you!Solved175429Jul 08, 2025Copper Contributor98Views0likes7CommentsNon-linear interpolation formula
I have been trying to do this for a while but without success. There is a formula somewhere (using a power law relationship or something) but I have not been able to do it. I basically need to find a corresponding value (column B) based on an input in column A. A B 10 5 20 2.5 If the inputted value (in column A) is 15, then the output in column B would be 3.75. Any way of creating such a formula in Excel? Columns A & B hold a non-linear relationship. Any assistance would be hugely appreciated. Thanks.kirkbiddlecombeJul 08, 2025Copper Contributor26Views0likes1CommentCumulate percentage returns.
Hello, I have investment returns which I would like to cumulate. I have positive and negative returns in percentage figures. I am struggling to find the formula, i.e. GEOMEAN doesn't work well with negative returns. I apprecieta every tips and hints! Best wishes, PascalPascal_KJul 08, 2025Occasional Reader50Views0likes1CommentHow to correct "#N/A" when using Rank function and Index function
I am trying to create somewhat of a scoreboard that eliminates the lowest ranking player per level. The problem is, sometimes the players have the same score and my formulas end up showing the them as #N/A. I have enclosed an image to better demonstrate my issue. You will see in column E & F, because three players have a 0 score, the two at the bottom show up as #N/A. The same applies to the two players in Level2 that have a score of 10. I have enclosed the formulas I have been using to the right. Is there a way to correct this so that the names and their score, even though they are the same, show up? Or perhaps is there a better way to do this? Thank you so much. Any assistance will be very much appreciated.itsMontyJul 08, 2025Copper Contributor64Views0likes2CommentsExcel Formulas not Working
The formula (J679) I have in the first image should return a value of 1 if the conditions in B573 and B638 is greater than or = to 1, which should sum the H cells. With nothing in either cell (other than the formulas in the next 2 images), the content in the J679 cell is the sum of the H cells. This can't be correct since there is no 1 being displayed. If I remove the formulas and manually insert 0's or 1's into B573 and B638 the formula in J679 works perfectly. I typed this into AI and it gave me several solutions to try. The format for those cells is General. The font and background colors are different colors (so I would know if there was a 1 in the cell by accident). Any thoughts or suggestions?glarsenJul 08, 2025Copper Contributor44Views0likes2Comments
Resources
Tags
- excel42,897 Topics
- Formulas and Functions24,889 Topics
- Macros and VBA6,448 Topics
- office 3656,097 Topics
- Excel on Mac2,665 Topics
- BI & Data Analysis2,403 Topics
- Excel for web1,942 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,658 Topics