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

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

    Hello - I would like to Count Unique Filtered Values In A List but Subtract Or Do Not Count if meets criteria Here's the current working formula: =SUM(IF(FREQUENCY(IF(SUBTOTAL(3,OFFSET(F9,ROW(F9:F999)-ROW(F9),,1)), IF(F9:F999>"",MATCH("~"&F9:F999,F9:F999&"",0))),ROW(F9:F999)-ROW(F9)+1),1)) It...
  17. C

    Can you please help me optimize my formulas for CSV export? I use Filter formula and Indirect Formulas

    Hi @BobBridges Thanks again (!!) and your patience and kindness is appreciated. I don't want or need my workbook to act like VBA, such as saving or deleting columns automagically. I just want my helper column to be incorporated into the formula as part of my "match" sequence (w index and...
  18. C

    Can you please help me optimize my formulas for CSV export? I use Filter formula and Indirect Formulas

    Hi @Marc L - thank you! 1) I don't use VBA so wasn't prepared to ask/accept help with VBA. I could follow specific directions and steps but I thought an formula wizard would know how to answer my post using a formula. However, it took a long time for my query to get any attention in the Excel...
  19. C

    Can you please help me optimize my formulas for CSV export? I use Filter formula and Indirect Formulas

    Hi Folks. I think someone (not me) moved my thread into a VBA forum incorrectly thinking I wanted VBA help (see screenshot), but I still stand behind my statement.. I need formula help. I have to research how to move it back. Thanks for all the posts and feelings though, it must be really...
  20. C

    Can you please help me optimize my formulas for CSV export? I use Filter formula and Indirect Formulas

    Bob Bridges, thank you for being a rock star and trying to tackle this. I'll review your feedback soon. Just want to hop on to say thanks!!
  21. C

    Data Dashboard: Bring in Filtered data, add a subtotal and repeat

    Is it possible to delete this query? It is not getting any traction and I have moved on, so would appreciate if I could delete it. Thank you! @moderator @admin
  22. C

    Can you please help me optimize my formulas for CSV export? I use Filter formula and Indirect Formulas

    Hello Excel Experts and Wonderful Wizards, I have an excel workbook attached here that "works" but the formulas need to be optimized, with your kind help. The purpose of the workbook is save the Import Tabs as a CSV, but the way the workbook is set up, I have helper columns that I wish to...
  23. C

    Data Dashboard: Bring in Filtered data, add a subtotal and repeat

    Hello! Can anyone tell me if the below scenario is possible and suggest some formula refinements? Could this be done with a data slicer? or scenario? I have spent hours researching. GOAL: My goal is to automate as much as possible, a dashboard and be able to change any data (#) manually, so I...
  24. C

    3 Criteria aligned with 3 Criteria

    @Peter Bartholomew - #1 - I have edited your spreadsheet with a new criteria. I am using Index & Match to find the box name but in the case where two of criteria have same volume, my index/match is only picking up the first instance. See attached file "package2" for illustration of this. Is...
  25. C

    3 Criteria aligned with 3 Criteria

    @Peter Bartholomew - I think this worked and it's incredible. Still verifying here and there - but you made it so easy. Thank you so much. Will follow up if I have additional questions on this solve.
Back
Top