Search results

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

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

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

My question: I want to use formula to decide optimal box to use for each product - minimizing extra air space in box and using smallest box possible to fit product. I also want to establish, using a formula how efficient my box packing is. So maybe need a % of how much extra space will be in...

Hello. Thanks in advance for help. I am trying to transpose data using formulas. I want to fill the formula to the right and down. For example: =INDEX($B$2:$B$12,COLUMNS($C:D)) When I pull formula to the right, it works great. When I pull it down, I would like to change formula to this...

I always find it confusing to create formulas with dates. Especially when the formulas have different date formats. Any help or places for me to learn more how to manage dates is very much appreciated. Here's my specific problem: Formula: SUMIFS('[GOS 8-12-13.xlsx]GOS -...

Hello. I have a scenario where I have 12 cells with dates in them: Cell A1 Has =Today() and then the remaining 11 months are created like this - =EDATE(A1,-1),=EDATE(A2,-1),=EDATE(A3,-1)...and so on. (Each cell should have the current month, and then the previous 11 months). Then I want...

Hi There, I have a complex lookup statement where I need to bring in complex data into another tab. It should function like this. Look in some other tab and look at col W. Col W can have unlimited rows and a header row. The data consists of blank rows and some rows with a number in it. If...

Hi There, I am trying to sort a spreadsheet by FORMULA RESULTS. Whenever I invoke the sort feature, the items do not line up properly, I think this is because it sorts the formula. My ultimate goal is to create a sortable list with different columns with the highest 5 values highlighted red...

I am not sure how to structure this argument. I need a to return data from a countifs query using a range of dates. Making things complicated is that the range of dates are in two different cells. Can you please help me adjust the formula properly? My attempt...

Here's another item I have been struggling with: 1. Field number 1 has this formula: =IF(I53="","N/A",IF(I53*100<3.49,"GOOD",IF(I53*100<5.5,"ALERT","UNSATISFACTORY"))) 2. Field number 2 has this formula...

Hello - I would appreciate help with the following problem. 1. I have a rolling 12 months: (Year-Month) My months are listed at the start of the month (1 June 2011) but item 3 needs to account for the WHOLE month (June 1, 2011 - June 30, 2011) 6/1/2011 7/1/2011 8/1/2011 9/1/2011 10/1/2011...

Hi There, I am not sure why the formula below not working for me. Can you please help me understand if anything should be fixed? =IF(ROWS(F$68:F68)<=G51,INDEX($B$2:$B$10,SMALL(IF($A$2:$A$10=$D$5,ROW($A$2:$A$10)-ROW($A$2)+1),ROWS(F$68:F68))),"") I know that the formula is entered as an...

Goal: Use Lookup to find intersection of Style and Supplier – Return result the corresponding “date”. This result is shown in the last column to the right. If two dates appear with the same supplier /date (like 3-Abby) return the most recent date. I tried this and it doesn’t work...

Hi. Looking for some help with a vlookup/index/match formula. Worksheet has 3 tabs. Data samples at Google Docs: http://bit.ly/zGKtNL. Tried this every which way but can't seem to figure it out. Reaching out to excel ninjas for help. Thanks in advance! Tab 1: Where I plan to post my...

Hi Can you please tell me why this IF/AND statement is not working? =IF(AND(EXACT(E1,E2)="FALSE",VLOOKUP(A2,Tannery,2,FALSE)="YES"),A2,CONCATENATE(A2," - DNU")) What I am trying to compute is: Evaluate if E1 and E2 are exact and Evaluate if they are on my tannery helper list. If they DO...

Having trouble figuring out this formula. I need to figure out how to add the data below with a countif formula and make the data series cumulative. Please note the data is always going to be a rolling 12 months...but I have space constraints in this text field. 11-Feb 11-Mar 11-Apr 11-May...

Hi. I have two questions. Need formula help. Need to figure out a formula for Cumulative Fail Rate Month by Month. PASSED FAILED Jan 0 0 Feb 0 0 Mar 0 3 Apr 3 1 May 5 6 Jun 2 0 Jul 4 0 Aug 4 0 Sep 21 0 Oct 3 0 Nov 12 1 Dec 6 0 Formula to accomplish the following: 1. Look at...