Need help recording max values an array changes going down a column

[BoomerGooner]

I am sure something like this has been answered numerous times but I cannot seem to find something similar. Basically, I need excel to record the max value in Column A in Column B as it goes down Column A. I have attached an image showing what I need from a sample set by manually solving my issue. The sample set is only 37 rows so its easy to eye ball the data and get the values. The actual data set is 37,000 rows and therefore I need a formula or vba code. Please ask questions if there is confusion. Thank you.

Sample Values:

1​

2​

3​

4​

5​

6​

7​

8​

5​

6​

5​

4​

3​

5​

6​

7​

10​

12​

9​

8​

7​

14​

13​

12​

18​

19​

22​

14​

13​

16​

17​

19​

21​

23​

18​

19​

20​

 

[BoomerGooner]

Swear I thought about this for a while before posting and came up with nothing useful but of course, minutes after posting I figure it out haha. If a mod wants to delete the thread, be my guest, but I'll post my solution in case someone may want it. The way I did it is probably very clunky and im sure can be combined/made better but it works for me.

If Column A is the data set then Column B should have the formula =IF(A2>B1,A2,B1). This will find the max value as you move down the column. In Column C the use of the formula =IF(B3=B2, "", B3) will remove the duplicates.