min max

Hi there, This is my first post since I am lost. Thanks for setting up this site! I received this huge sheet with a list of projects in column A. Each Project uses Deliverables (Columns B to Z+). The goals are: - Find total $-amount spent on deliverables for each KEYWORD found in row 2. -...

I get tables of Unit Type (# of Bedrooms), Prices, and SquareFootage ranges regularly. I need to condense this information into a table that shows units of the same time, with a minimum to maximum of price, and a minimum to maximum of SquareFeet. I've been sorting the columns for unit type...

I have a project where 60K records from the original worksheet have duplicate client # numbers. As in, the client placed multiple orders using the same client project key but we supplied different transaction ID's. The client has asked for report showing the difference in MARKET price...

I have a chart that changes dynamically with data that is entered on another sheet. I then make a scatter plot from this chart. The data goes from 0 to a maximum value (which is what is always changing) then returns back to zero. I want the graph to ignore the returning or down slope of the...

Hi all, I'm working on a macro, which looks up a date in an excelsheet with up to 30000 rows. Each row contains date values (column C) and temperature values (column E). I have about 250 rows per day and I would like to return the minimum, maximum and average temperature for each day. I tried...

I need help coming up with a formula that will allow me to input multiple criteria within a range and pull all matching data from a list. Below is a sample spreadsheet with the desired answers to the right. Any help would be greatly appreciated! Thanks, Mike <TABLE style="WIDTH: 844pt...