Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Min and Max
I have a large data table that is set up like this:
GOUL05C260.00 34.8 GGDL05C320.00 9.3 YVCM08P310.00 64.8 YVCM08P310.00 65.8 YVCA08C320.00 57.1 YVCA08C320.00 58.1 OQDM07P500.00 218.6 I am trying to set up a table that will look at colA above and find the min and max values from colb The table could be like this: Min Max GGDA06C280.00 GGDA06C290.00 GGDA06C300.00 GGDA06C310.00 GGDA06C320.00 Thank you in advance. |
#2
|
|||
|
|||
A Pivot Table will give you the report that you want. The table format
chooser will allow you to format the table as you want it. -- Gary's Student "carl" wrote: I have a large data table that is set up like this: GOUL05C260.00 34.8 GGDL05C320.00 9.3 YVCM08P310.00 64.8 YVCM08P310.00 65.8 YVCA08C320.00 57.1 YVCA08C320.00 58.1 OQDM07P500.00 218.6 I am trying to set up a table that will look at colA above and find the min and max values from colb The table could be like this: Min Max GGDA06C280.00 GGDA06C290.00 GGDA06C300.00 GGDA06C310.00 GGDA06C320.00 Thank you in advance. |
#3
|
|||
|
|||
Assumptions:
1) A1:B7 contains your data 2) Column D contiains your unique values, such as GGDA06C280.00, etc. For minimum... E1, copied down: =MIN(IF($A$1:$A$7=D1,$B$1:$B$7)) ....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. For maximum... F1, copied down: =MAX(IF($A$1:$A$7=D1,$B$1:$B$7)) ....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Hope this helps! In article , "carl" wrote: I have a large data table that is set up like this: GOUL05C260.00 34.8 GGDL05C320.00 9.3 YVCM08P310.00 64.8 YVCM08P310.00 65.8 YVCA08C320.00 57.1 YVCA08C320.00 58.1 OQDM07P500.00 218.6 I am trying to set up a table that will look at colA above and find the min and max values from colb The table could be like this: Min Max GGDA06C280.00 GGDA06C290.00 GGDA06C300.00 GGDA06C310.00 GGDA06C320.00 Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|