# Vba :a column date, bc column is the value, column b minus c column, according to the period of f2, g2, the maximum and minimum values are displayed in f3 and g3 respectively.

Asked by: Linda Watson 225 views IT

A B C F G

2 20180201 2000 1000 20180201 --- 20180207 Time period is your own input

3 20180201 1500 1000 2500 600 Show maximum and minimum values at f3, g3

4 20180202 2500 1500

5 20180203 2000 4000

6 20180203 2000 1900

7 20180204 2000 1000

8 ,

n 20181220 2000 1000

There are multiple rows of data in a day, so the maximum and minimum values are calculated by date. The third row of the above data is the maximum value.

The fifth row is the minimum value of 500, but the sixth row value is 600. Date, so the minimum value should display 600

Addition: Expert help

Addition: To display the maximum value and minimum value accumulated by date

Addition : I added a screenshot, please help me! ! !

+5

VotesThe fifth line is how the minimum value is 500?

The sixth line is the minimum 600?

Please say it again

Eric- January 24, 2019 |