I need some kind of magical formula to find the Min, Max & Avg (for each specific Acct # in one column) and place the result in a completely different worksheet

Example:

"Sheet 1"

So for this example, the results would be on "Sheet 2" and would show the Max for Acct 25 to be 56.23 (and the Avg would need to calculate all of the amounts in rows 1-4 since they are all the same Acct)

Then so on an so forth for each different Acct listed in Col A

The problem I am running into is that there are hundreds of Accts in Col A

HELP!!!

Example:

"Sheet 1"

_____**Row**_______**Col A****Col E**__1____Acct 25__26.79__

2____Acct 25__56.23

3____Acct 25__37.84

4____Acct 25__10.15

5____Acct 52__10.45

6____Acct 52__29.75

7____Acct 52__11.79

8____Acct 52__28.742____Acct 25__56.23

3____Acct 25__37.84

4____Acct 25__10.15

5____Acct 52__10.45

6____Acct 52__29.75

7____Acct 52__11.79

8____Acct 52__28.74

So for this example, the results would be on "Sheet 2" and would show the Max for Acct 25 to be 56.23 (and the Avg would need to calculate all of the amounts in rows 1-4 since they are all the same Acct)

Then so on an so forth for each different Acct listed in Col A

The problem I am running into is that there are hundreds of Accts in Col A

HELP!!!

Last edited: