• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    Macro: Copy data from sheet 1 over to sheet 2 in different format

    Hello All! I have a form on Sheet 1. This form takes account number, items and quantities, phone number, and a name of a customer. I need a Macro that will take the data from those fields and move it to Sheet 2 which will be a straight horizontal format. I also need this macro to clear...
  2. A

    Averageif: criteria in Column B is met, average range Help

    Kyle: That worked great! Thank you for the additional options!
  3. A

    Averageif: criteria in Column B is met, average range Help

    Nice Trick Prasaddn!
  4. A

    Averageif: criteria in Column B is met, average range Help

    I have tried a few different ways with AverageIf but haven't been able to make that work. Still stumped on it.
  5. A

    Averageif: criteria in Column B is met, average range Help

    LUKE!!! Nevermind! I was trying to use a Range Name for the B2:B4 part of the formula and that seemed to be throwing it off so I changed it to be just the cell range and VIOLA! it worked like a charm! Thank you so much for your help! Now I am going to try to use that same formula but as an...
  6. A

    Averageif: criteria in Column B is met, average range Help

    Hello Luke, That did not work. When I hit Ctrl+shift+Enter, if give me a #N/A as a result
  7. A

    Averageif: criteria in Column B is met, average range Help

    Hello Everyone, I am putting together a spreadsheet that is composed of 2 teams. I want to list the players in alpha order, which is no problem, but this mixes up the teams. They get a score every month and I want to break down the average by team while excluding the other team's scores. So...
Back
Top