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
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...
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...
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...
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...
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...
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)...
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
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...
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...
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...
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...
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
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...
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...
@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...
@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.