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
Calculating Two Cells Based on each other
I have a basic task i am trying to complete and i am going through the web to learn how to solve this. Looking for help. I have CAD Currency and USD Currency. I have two cells side by side and depending on what i put in one i want the other to adjust. So if enter to dollars CAD in once cell the other cell will adjust to the equivalent in USD based on a exchange rate in another cell. Any assistance on this would appreciated or even a link to resource to learn how
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.
