min if

Hey All, Been working on this for a while and couldn't figure it out, tried offset, and Match/INDEX. I still cant get around the issue of the range not being a consistent nth row. <tbody> 10:00 100% 10:01 95% 10:02 100% 10:03 95% 10:04 92% </tbody> As the above table illustrates the...

I have a data set where I need to find the closest 3 results of a given number. column a speed 47 36 12 6 1 column b group 1 2 2 2 1 Given number "25" in c5 I want to be able to have the closest numbers to "25" in each group I can get the closest to it using...

Hello, Very simply, there are sections of my data I want to exclude in my Max- and Min-If statements, but these sections are not continuous. These formulas work for excluding all account numbers less than 9700000...

I am really stumped on this one. I am trying to find the min and max piece of data for particular months. To do that I am using MAX IF and MIN IF: =MAX(IF(B:B=F,G:G) =MIN(IF(B:B=F,G:G) Literally the only difference is the MIN and MAX part. And to add insult to injury, I have just realized...

Hi All, I have a column of numbers. Some rows are 0. I want to get the min of this column excluding the 0's. So far my formula is: {MIN(IF($A$76:$A$341=A8,$H$76:$H$341))} Column H is the column that contains 0 Column A contains unit types. Thank you for your help.

I was wondering if you could help. I am trying to use Min If to return the lowest date that we invoiced a client. we have thousands of rows of invoices and i am using the IF function to match the client name and site before it returns the earliest date. The formula i am using is ...

Hi Guys need help with the following formulas in Excel 2007. I have spent hours on this including web-searches. I have data recorded during different times of the day. I need a min/ave/max for every day. I discovered AVERAGEIFS which works fantastically well, but doesn't for min/max. Here...