Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello
I hope i am not duplicating any previous query. I am trying to generate a minimum and maximum summary for a list that includes similar logical labels. For example If my list is Community Park.....10ha District Park...20ha Canal..3ha Open Space..4ha Lake...1ha I want to find the min/ max of all types of Green spaces (Community Park, District Park and Open Space) and Water Bodies (Lake, Canal). Is there an easy way to do this without adding another column? For example one could add a col that identifies Community Park, District Park and Open Space as Green Spaces and search the min/ max in this but as my list is long and needs frequent updates it would be a pain to maintain. Thanks in advance. Manosh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding minimum value across selected rows of an array | Excel Worksheet Functions |