How do I?...

[erickguz]

In Col A, I have the month (could be 10 rows, or 100), and in Col B, I have an amount. Is it possible for me to place in C1 through C12 the Max value for each month automatically? (without having to do a manual sum function)

JAN $185
JAN $210
JAN $333
FEB $10
FEB $444
FEB $38
FEB $69
FEB $418
FEB $332
MAR $0
APR $89
APR $112

For example, the formulas would give me the following results:
JAN $333
FEB $444
MAR $0
APR $112

(Again, I know I can enter a manual formula "SUM(B4:B9)" to figure out FEB result, but can I enter a formula to return the max for each month? I have about 2,000 entries for the year...)

[Ron Coderre]

1) Bad Title.....Please change it to something more descriptive first chance you get.

2) Try this:

Please Login or Register  to view this content.

Copy C1 down through C12

Does that help?

[erickguz]

Ron - awesome... worked like I needed. Thanks for sharing expertise.

RE: Post Title
Yes, I actually tried to change the title after I had made the post but did not spot where I could edit...