answers

  1. L

    Difficult Excel Formula

    I am making a calculator for my website (i make the calculator in the program excel), but i don't know which formula i must take and how to fill it in. It is a formula where the answer depends on the input and bandwidth of the input. Below the input en output: Input: ≤30.000 --> the answer...
  2. C

    Survey Question with Multiple Answers in Multiple Columns

    Hello, I have received a spreadsheet with survey results and many of the questions have multiple answers in multiple columns. For example: <tbody> Respondent Where do you keep the product? a@gmail.com Home Car b@gmail.com Work c@gmail.com Home Car d@gmail.com Rental...
  3. R

    Copying answers from previous calculation

    Hello, I'm trying to add a VBA code into a tool I'm creating for my thesis since the calculation is a repeatable calculation, although a lot of work to do by hand. Perhaps one of you guys is able to help me out on this. In my main worksheet "Resistance", I added a form control button where...
  4. M

    Formula to return multiple answers

    Hi Everyone, I am looking for help with a formula to return multiple answers depending a cells input. For example: 6 = Good performance 5 = Satisfactory performance 4 = Acceptable performance 3 =Requires improvement* and so. and so on. I have a basic formula...
  5. P

    Please moderate & delete wrong answers from users

    Hi. Zack Barresse , PaddyD, Smitty, Richard Schollar, Peter_SSs Kindly where possible, intervene & delete wrong answers suggested by members for any question. Thank you
  6. J

    Averaging Survey Data Based on Multiple Criteria

    Hello, I am looking for a way (other than pivot tables) to average customer satisfaction survey results. Responses are given 1-5 and I need to average the total number of 5's for a category based on the total number of responses. With that said, not all questions are answered so I sometimes I...
  7. R

    Automatic category selection as seen in Yahoo Answers

    Hi, I have a list of keywords with related category of incidents they belong to. I would like to create an automatic category selection in Excel based on the keywords entered by a user. For instance, if a user enters "SAP password reset" I want to match those three words...
  8. S

    Drop downs & lists

    I'm really not sure what to call them since I'm not very good with my excel terminology. I'm creating a survey and for some of the questions I would like to have a "drop down box" so they can choose the appropriate answer. Similar to if you were filling out information on a web site and you get...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top