# min ifs

1. ### MIN If for Multiple Criteria

Hi, Any chance anyone can help me here..I'm looking to find the minimum range based on two criteria. 1. It equals the city 2. It is greater than or equal to the time So, here is a sample of what I have <tbody> A B LA 17:45 LA 06:30 NY 15:00 NY 18:00 LA 18:00 LA 20:00 NY 19:45...
2. ### Display minimum of numbers or text if range criteria is met

=IF(AND(A4:A6>=0,A4:A6<=5,COUNTIF(A4:A6,"NS")),MIN(A4:A6),"NS") This equation doesn't seem to capture the full logic of what I'm trying to accomplish. In column A, we have a validated data cell where the only allowed values are: 1,3,5, NS. In the column where the above equation fits, I would...
3. ### Min IFs

Probably best to start with the Maxif to show you where i am. {=MAX(IF(Data.!A:A=SRLlist!A358,Data.!Z:Z))}. basically, there is list of 'names' (SRLlist!A358 in this case) that match names on another sheet (data! sheet, column A) for which there are multiple entries. This formula gives me the...

### This Week's Hot Topics

• Turn fraction around
Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
• TIme Clock record reformatting to ???
Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
• TextBox Match
hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
• Using Large function based on Multiple Criteria
Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
• Can you check my code please
Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
• Combining 2 pivot tables into 1 chart
Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...