• 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. E

    CountIf with preceding cell as criteria?

    Thanks Luke- that was a big help! Now I'm hitting another (probably very simple) wall. I want to represent this in graph form. Specifically, on a pie chart, I'm trying to show the breakdown for how many registered attendants brought 1 guest, how many brought 2, and how many brought 3 or...
  2. E

    CountIf with preceding cell as criteria?

    Hello Excel Masters! I'm working on a guest list for an event we recently had, and I'm trying to figure out how many guests each registered attendant had. However, since many registered attendants brought multiple guests, I have multiple lines of data for the registered attendant. Column C...
  3. E

    Finding Unique Values Across Multiple Columns

    Hey Montrey, Thanks for the video. It really just reinforced what I had tried earlier... I ended up taking the "outsmart excel" approach and created a new spreadsheet with data from the columns I needed filtered, so as to "lock" the filtered data in place. Thanks a MILLION for such a...
  4. E

    Finding Unique Values Across Multiple Columns

    Hello Excel Masters! I am trying to sort through a long list of data (over 21,000 rows) of student profiles in higher education and I need to get specific counts from this data. Unfortunately, the database outputted the data in a less-than-ideal way. For example, each academic concentration...
Back
Top