Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hope someone can help me with this query !
I have a spreadsheet with 3 columns of numerical data (with a header row at the top) which is created by pasting in data from another application. When the data in one of the columns is within the range 133-137, I want to find the max and min values within that range. I also want to find the max and min values in the adjacent columns within the same row range. Obviously I can do this manually just using max/min functions but I want the data to be found automatically - so either have a formula in a cell that returns the result when the data is pasted in, or a macro that can be run to report the values. The start and end of the range of interest will be different each time data is pasted in but the total amount of data and the criteria will be the same. I am using Excel2002 Thanks in anticipation ! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding Average with Criteria | Excel Worksheet Functions | |||
Finding a number based on a criteria | Excel Worksheet Functions | |||
Finding the lowest value according to multiple criteria | Charts and Charting in Excel | |||
finding an entry from two criteria. | Excel Worksheet Functions | |||
Finding One Value, Matching Three Criteria | Excel Discussion (Misc queries) |