Search results

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

Thank you all for great feedback. I used this formula: =SUMIFS('[GOS.xlsx]GOS - Detail(1)'!$AB:$AB,'[GOS.xlsx]Global Open Supply - Detail(1)'!$E:$E,$D$3,'[GOS.xlsx]GOS - Detail(1)'!$Y:$Y,">="&$AD$52) where AD52 = is 1/1/13. This worked great. Thanks again!

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

This appears to be working fantastically! Thank you! Will post additional questions if needed. Thanks Sajan!

Hi Sajan, How do I incorporate this into a countifs statement? As I do have other data to filter as well. Would it be something like this: =countifs(SUMPRODUCT(--(TEXT(DateRange, "yymm")=TEXT(A1,"yymm"))>1,Name,"Ben", Number,")) Thanks again!

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

This works GREAT! I went with Chandoo's solution! Thank you so much. I also utilized "ISERROR" function to get rid of any #NUM! errors. My final formula looks like this: =IFERROR(INDEX([WeeklyData.xls]qryBVFailandSCLX_Date!$V:$V, MATCH(LARGE([WeeklyData.xls]qryBVFailandSCLX_Date!$W:$W...

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, You are correct. Thanks. I am excited to see the outcome! I did notice that I made a "conditional formatting" mistake with tab 3 "sort examples". In example 1 I accidently colored red the wrong set of 3 numbers. I should have highlighted those numbers marked as 12.1% (not 15.6...

Hi Sir JB7 and Narayan, Thank you for your patience. Can you please confirm you can see 4 tabs in this worksheet? http://speedy.sh/CnQab/chandoo-help.2.xlsx In regards to your comments (thank you,again): - there are no macros as it's an .xlsx file, so no sort procedures Yes - I don't have...

Hi SirJB7, Thank you for the reply. I don't understand why my values aren't sorting correctly. Can you please help me understand? For example - open the spreadsheet from yesterday. Go to Tab 2 "Formulas" and try to auto-filter and sort using cell B3 (2009 Fail %). The numbers that are 0%...

Hi There, Thanks for the response. Sir JB7, understood what you are saying, but how can I get around - I need excel to sort on results, not on formula. I understand that there's ways of creating helper formulas, but can't figure out how to do this. Narayan - Thank you, but that does not...

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

Thanks for the help SirJB7! I struggled with that for so long, but the solution is really simple!

Fantastic! Thank you very much SirJB7 and Luke M

I'm not going to have EO Month column (B) can we account for this? THank you so much for the assist, SirJB7!

Hi There, Thanks for the quick reply! I didn't mean, "if both". I need to formula to prioritize text. If Unsatisfactory EVER appears..display it over any other text. If ALERT apppears, and Unsatisfactory does not. Show Alert. If Neither Unsat NOR Alert appears, show GOOD. Example: [A2...

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

thank you very much!!!

That works great. I guess for P2, what I was going for is this: - The default cell entry is 0. If it contains anything other than 0, then invoke " - DNU" Thoughts? Thank you, Luke!

Thank you very much! I am thrilled that I figured out a solutin for my first question. And thank you for condensing. However, I am still working on removing the "#N/A" as a result. It's a shame because I don't mind it being there. Here's another example...

Thank you so much! I actually figured out why my formula broke - not sure if you have any solutions. Some of my datapoints in col A and B may have (as an actual piece of data the characters) "#N/A" - the minute that is a data point, the formula breaks. Do you know why this occurs and how to...