Search results

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

Fantastic! Thank you so much! What is the purpose of the "*" ? I don't get how that works..can you please explain!? Thanks so much! Also, what if I want to throw in a third criteria - would that work as well?

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

Ok, Narayan, I used your suggestions as a starting point and came up with this formula. =IF(ISBLANK(VLOOKUP($A3,'RS Dates'!$A:$AI,$I$1,FALSE)),I3,VLOOKUP($A3,'RS Dates'!$A:$AI,$I$1,FALSE)) I tried to simplify the ask - my worksheet has 2 tabs - 1 of those tabs contains a helper table. The...

Narayan, Thank you very much. I can't seem to figure out how you solved this, with all the multiple tabs and formulas. It appears it is well beyond my knowledge of excel formulas. I'm sorry to put you through all this trouble. Unless you have any other knowledge or a simpler way to get this...

Hi Narayank991: You got it! Thank you for the efficient summary. Clarity on cases: For cases b+c - I never envisioned there to be some other data in those cells. For example - Tab 2 will either have a date or be blank. Tab 3 will either have a 1 or be blank. However, if it's easy to plan...

Hi There, Dan_I: the google doc has been edited with the data in tabs 2,3. Reminder: I would like to have formulas in Tab 1 - cells B3 - G8 that looks at tab 2 and tab 3 to see what values are to be displayed in tab 1. I gave some sample answers in red in tab 1. Narayank991: The rules I...

Hi There, Dan - I will try to move the data in the google docs to multiple spreadsheets, It will take an hour or so - when I arrive at work. Srinidhi - my goal is to have the same formula in all the cells that automagically calculates the rules based on the data in tabs 2 + 3. Do you...

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

Fantastic. This worked like a charm, Narayan! Thanks again!

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

You all ROCK! Thank you Thank you! You helped me think through this a little better, and helped me learn more about countifs. However, I decided to add a new helper column to my data that says "Yes" or "No" if the data is relevant and should be counted. Then, I use "Yes" or "No" as a countif...

I have another question - I've tried to research to no avail. I'm using COUNTIFS formula. I have a list of items in criteria_range1, I want to count certain items and exclude others. I've been using formula below, but it doesn't work as it appears trying to use multiple criteria in a range...

This has worked out great. Truly appreciative.

Thank you. I wasn't sure how to add to Countifs. Seems very easy. Can you please explain to me the logic with the functions - what does the "@" mean? Thanks again!

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

Thank you very much Narayan. You've been a great help!

Here's an example of the =MAX and =IF that's not working for me. FORMULAS USED ARE IN {BRACKETS}. For Rankings: "Good, Unsatisfactory, Alert" I used formula:{=IF(H56<3.99,"GOOD",IF(H56<10.99,"ALERT","UNSATISFACTORY"))} ------Data------ PASSED TESTS 14 FAILED TESTS 4 YTD FAIL %...

Confirmed Fred. There's so many mistakes (by me) riddled throughout this ask. I tried to be as accurate as possible, but decided to change things at the last minute and forgot to update my figures here and there. Fail rate is 11/71. Thrilled that you and Narayan were able to follow along...

Hi. Sorry. =MIN function used in H12 and =IF function used in I12 of spreadsheet. I want cell H12 to select the lowest of the values and then the I12 to display the cooresponding text (Good, Alert, Unsatisfactory) based on values previously provided.

Oh yes, I didn't realize I did that. H11 = H56.If MIN formula returns 15.5% - I want "unsatisfactory" displayed - but it doesn't seeem to do that for me!

Ok, you're correct. Can you please review my formula to see if the correct verbiage appears when using the MIN formula? =IF(H56<3.99,"GOOD",IF(H56<10.99,"ALERT","UNSATISFACTORY")) For example - the MIN formula correctly retrns 15.5% but text that is displayed should coorespond...

How can I say thank you? You are such a great help!

OK. Thank you kindly. For H11, yes, I enter in some number. I was trying to put in a value of 3.98 (for example) into celll H11 because I thought the student did a "good" job. But when I entered in 3.98 in H11, I saw unexpected results with the Min formula (=MIN didn't work correctly). Is...

What a great help you are! I placed the suggested formulas in my workbook and they worked PERFECT! I can't believed you figured out what I needed amongst all my "chicken scratch". H11 = "Grade" it's a # that I enter as a result of how responsive the student is. H12 = I select the lowest of...