max if

I have tried 2 different ways to find the Max value in a column based on 2 variables. You can see in example 2, I even tried to hard code the variable name instead of using the cell reference just to make sure it was not an issue with my validate fields in A@ and G2...

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

Dear all, Having some difficulty with the max if formula.... example of my data. <tbody> Column A Column B A 401580 A 385780 B 103500 B 103500 A 95220 </tbody> I would like to find the max value if column A is "A". I have the following coding but it returns "#NAME?" Sub max_if()...

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, In column A I have "reported period" and in column C I have "account name". Each month I have new series data contains reported period and account name, and now I want to select MAX date for looking account. Example: <tbody> Reported Period (column A) Account Name (column C) 12/09/2014...

Hi There, I have a problem I need to not only return the highest value per sales rep but the name of the deal. <tbody> Opportunity Name Opportunity Owner Unique Sales Price Arriva_Mittelstand Andrea Junge 130.000 Siemens-CIT-ARIS Design Server Denis Wachsmuth 17.600 Telefónica Alfabet...

Hi, I am working with the below table, I need to get 2 things, the row number of the max value in C, and the value of column B. <tbody> A B C D E F G H <colgroup><col width="92"></colgroup><tbody> 505953841882 </tbody> a 0 505953841882 <colgroup><col...

I have a summary with dropdown boxes and accodring to the selection I make, the table changes since I have put SUMIF formulas. I have created a chart that reads the data that is filtered and the chart is modified automatically. Now, the summary is just a summary of multiple projects that...

Thanks for your help. I have read through all of the various Match If posts and still having trouble. The goal is to find the max value within a column (spend on a product), restricted by another parameter (industry), and then subsequently use those restrictions to return a value in another...

HI there I was wondering if someone can help me. I am working on a project that is incredibly hard to test, therefore we decided to come up with a simplified problem to take the first steps in resolving our problems. My problem is that I can't solve this simple problem using maths in excel so...

Hello, I wondering if someone can help me with a relatively simple questionL I am looking for a solution (formula) that look for the latest date within a category (column) - but the latest closest to a certain date (the if part). <tbody> Product: Product 1 Model...

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