minif

I am looking to calculate the "Cst Info" data based on the filtered data available on the "Data" worksheet. I have so far tried searching the forum, but have been unable to find something similar. Example workbook uploaded here. This is how my "Data" worksheet looks like (after filtering for...

Hi, I have two-pronged question though the most important one will be the 1st bullet and the less important will be the 2nd bullet. The uploaded excel will show the same format for the aggregate data on the top and the different sets of data outlined in black below it. Unsure if sumifs and...

Hi All, Hope you're all well. I am trying to do the following, if possible. I have found a way around it using formaulas but can't do it using conditional formatting. What I want to do is to find highest value in a ROW if greater than n% to the second highest (say green) and also finding the...

Hi all, not a ton on this since i think Maxifs are for the newer version of excel? Anyway, here is the formula I'm trying to use: =MAXIFS(B:B,LEFT(F:F,3),K1) K1 contains the first 3 letters of a postal code, column F has full 6 digit postal codes, column B has numbers that i want to return...

Hi All, I recently discovered a way to use the aggregate function in conjunction with index / match to identify min / max values for like records in a table (i.e. if I have a table of animals and their weights, I could use this function to identify the smallest dog, or the largest cat, etc.)...

I'm trying to create a list of unique project numbers that have outstanding invoices. I have a data query which pulls data into my Data! tab, the query returns the age of the invoices in date range buckets (eg <60 days, 61-90 days, >90 days). That is, column L has the amount of money owed that...

Hello all, I am having some trouble with my latest spreadsheet and havnt figured it out yet. Below is a breakdown of what is going on: I have names in E2:E53 on sheet FY15, FY16, FY17. I have a % in E:E53 on sheet FY15, FY16, FY17. On each sheet, the same name may appear more than once...

I want to create/assign a new value in to some rows in my data depending on the average, maximum or minimum of an multiple criteria if based calculation on rows other than the current row. I've created a regular xl file to illustrate where I want to go, however, I can't post attachments yet. In...

Hi All, Long time reader, first time poster here. Basically I am having an issue with reporting some of the data on one of my massive spreadsheets. Ultimately what I am looking to do is have one cell report the maximum time taken to achieve a goal (read from column AJ3), but based on the...