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

Recent content by chloec

  1. C

    Logic Question: Maintaining downloaded / updated Data after you make edits

    Peter, I am so sorry for missing this post. Thank you for the feedback, I'll try it out (I didn't think I got a response so I dropped thinking about the project). Went back to see if I got any responses and was surprised about your note. Picking it back up. Appreciate you @Peter Bartholomew
  2. C

    Logic Question: Maintaining downloaded / updated Data after you make edits

    Hi Folks - Looking for help with a logic question on data maintenance after you download fresh data. 1. My team downloads data from a system into excel (I think Power BI could be used) 2. The data is filtered into multiple tabs based on team name (each team gets their own tab of data) 3. Each...
  3. C

    Take a value, divide by X, Apply the quotient across X number of Columns

    This is PERFECT! This is amazing, you are amazing. Thank you @p45cal
  4. C

    Take a value, divide by X, Apply the quotient across X number of Columns

    Hi Geniuses, I am looking for a formula to do the following: 1. Take a value (($100, for example)) 2. Divide by X ((4, for example)) 3. Apply the quotient ((25)) across X # ((4)) of Columns starting at a particular column as noted by Month and Year - If a column is NOT relevant, it should be...
  5. C

    Help with Rank and Weight Formulas

    Thank you - Looks GREAT @vletm
  6. C

    Help with Rank and Weight Formulas

    Hello. I have Multiple users that submit their ranked choices of dessert flavors, they rank them in order of importance (1st, 2nd, 3rd) and submit to me. I have to choose the top 3 most popular dessert flavors based on rank (1st, 2nd, 3rd) and frequency - how often the appear in the list - but I...
  7. C

    Count Unique Filtred Values In A List: Do Not Count If Meets Criteria

    I just want to say thank you to all contributors! Appreciate all your help, support and technical skills! My problem is RESOLVED. @pecoflyer @Debaser @Peter Bartholomew @bosco_yip I ended up using the formula presented by @bosco_yip because I had challenges (user error) with @pecoflyer (the...
  8. C

    Count Unique Filtred Values In A List: Do Not Count If Meets Criteria

    Thank you so much! @pecoflyer When I tried your suggestion, it didn't work out as expected - but that may have been user error. @Debaser - I was trying to avoid a helper column, but if I have to use one - I will I will continue to test your two solutions and report back. Thank you very much...
  9. C

    Count Unique Filtred Values In A List: Do Not Count If Meets Criteria

    A list where I have filtered out data and only want to count what is being displayed. The filtered list starts in cell F8
  10. C

    Count Unique Filtred Values In A List: Do Not Count If Meets Criteria

    Maybe I can use a helper field instead. Could you suggest a solution for below? 1. Given a filtered list 2. If A certain text appears in my filtered list, count the occurrence once Text A = 1 (doesn't matter how many times it displays in the filtered list, if it shows up once, give me a 1)...
  11. C

    Count Unique Filtred Values In A List: Do Not Count If Meets Criteria

    This didn't work for me Thank you this didn't work for me, it seemed to return a count that included items in the filtered list. I also wanted to count the unique values or iterations that start with User 8 So I could subtract them. Thank you for trying, @pecoflyer
  12. C

    Count Unique Filtred Values In A List: Do Not Count If Meets Criteria

    MS excel for Mac - Microsoft 365 subscription version 16.75.2. @pecoflyer thank you!
  13. C

    Count Unique Filtred Values In A List: Do Not Count If Meets Criteria

    Here is the sample sheet, attached. Thank you @pecoflyer
  14. C

    Count Unique Filtred Values In A List: Do Not Count If Meets Criteria

    Hi Vletm, spelled your name wrong, sorry
  15. C

    Count Unique Filtred Values In A List: Do Not Count If Meets Criteria

    Hi Vietm, I did not intend to shout and have fixed my posting thank you
See more
Back
Top