max if

Hi guys. For the love of my life I can't work out a Max if formula. What I am trying to achieve here is to get the correspondent value from C to the latest date in column A. My idea was to get an array of the same fruits, then with the max get the largest date. Then try to match index match it...

Hi Everyone, If you’re reading this, thank you. BACKGROUND My role at my company requires of me to report the most currentprices stored in our databases. Sometimes I get requests to pull prices forproducts that first billed several quarters ago. The challenge with this is thefact that the price...

Hello, I have 4 columns of data, like this: <tbody> NE NW SE SW Prevailing 45 30 22 31 NE 25 59 51 42 NW 71 44 21 18 NE 9 5 22 56 SW </tbody> The first 4 columns contain numbers of wind data. In the fifth column I want to write a command, by which the name of the prevailing wind...

Can someone please help me with the following case: A spreadsheet containing dates and values (multiple times same date is occuring): A(date) B (Silo) C (lab value) 12.03.2018 15 30 12.03.2018...

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

Hi all, I have a sheet of data with two columns I want to run a formula against. The first column contains device names, the second, version numbers of a piece of software. Both are text (the device name is alphanumeric and the software version is numerical but with major, minor and subminor...

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

Looking for a way to use array formula with false criteria or a better way to create a formula to achieve desired outcome. So, if Exercise = shoulder press and Up W = U then find max of AW else use number in Deload column My array formula worked will until I added an additional criteria to the...

I am pretty new to VBA and have been tasked with creating a rather complex email reminder system. We have a list of equipment which have unique IDs. Each row has various details relating to that equipment ID such as calibration instructions, dates calibrations are due, last calibrated date...

I have a bunch of dates with two numbers connected to it. They are not in order and relate to many different items. I need to be able to output into a different table the next following date and the next two numbers if one or both of the numbers change. Example: "Current" Data <tbody> Item...

=IF(SUMPRODUCT(COUNTIF(F2:F7,"*"&'GraphData'!BP2:DR2&"*"))>0,COUNTIF(MAX(IF(H2:H7=H2,I2:I7)),">115"),0) The above code is what I'm having problems with. I have blank cells including: H3:H7, I6,I7 Any help greatly appreciated.

I have a pivot table that I am taking data from. Currently, I am able to take data compared to a certain date and display the most recent date's serial number in a separate cell. Now, I want to display that max date instead. Currently, I use this to pull the most current date completed on an...

I've thought that the new =maxifs() function could help me here but I do not have access to it yet in my version of excel. Basically I have a very large data set from which I need to sum some specific values based on a number of criteria. I've used =sumifs() until now, but every so often there...

I am comparing 2 sets of account balances and want to find the account with the largest change in balance from day to day for a specific product category (Personal Accounts) and location (10). The accounts are separated into groups by a product code and location ID. Below is a data sample...

I am attempting to create an Excel file that will allow my supervisors to view the last date an employee entered activities into their excel file. A workbook is set up for each employee with column K holding employee numbers and column a holding the dates. There is a different sheet for each...

Hi, I have the following data where I need to return whether I am on the maximum row based on multiple criteria I will have the formula in the formula column for each row in the example below with a TRUE or FALSE. In the example below, I should see TRUE in Rows 2 and 15. Basically for each...

Hi, I have the following data set where I have three columns: Name, Date and ID. I am trying to identify the latest date against each name and in some cases where the dates are duplicated (as in case of John, 15/05/15) I want to be able to identify the name against latest date and highest ID...

I've been trying to make a purchase order number generate automatically using excel. I got it down so far and have hit a brick wall. The formula I'm using at the minute is...

Hello folks I am novoice in VBA programming and am stuck on a program, need help from you experts. I did read many threads on this subject but issue remains.. I am looking to use Max if function (multiple conditions) in VBA using Evaluate but everytime I run this program I get the "Type...

Hello, I'm trying to compare 5 items in a pivot and then finding the max value. Whichever is the max value will filter the next Pivot. As of right now I have a super long code that works but I was wondering if someone could help me condense it a little. There are 2 pivots exactly the same; one...