Forum Widgets
Latest Discussions
I 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. GiGI
Calculate 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!Non-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.
How 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.Excel 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?
