repetitive sumifs, maxifs, minifs - is there a way to only run the formula once?

All, new to the forum. Not even sure what this is called, so forgive me if its been answered before.

I'm trying to apply some KPI's to a large (130K+ rows, 5 columns) data set. Each row is a work order or invoice for a specific piece of equipment. So unique identifiers are the invoice # itself, along with serial # of the asset (repeats as it ages, more work orders accrue, etc.).

My formulas are in the green columns (F-J). The formulas work and give me what I need, but all the maxifs, minifs, maxifs etc. really bog my computer down. In this snipet that I'm providing they're fine, but trying to drag down to 130K rows crashes my computer. I only need the formulas to run once per serial # occurrence (Column A). Is there any way to do this, or another way I'm not thinking about?

Thanks in advance.

Edit - file attached

You can post a workbook, but not links. Instructions below:

Will you please attach a small sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

Hello bicbuck and Welcome to Excel Forum.
I feel that the whole column references in columns G, I and J are the culprits. For example the formula in column G = MAXIFS(B:B,A:A,A2)-MINIFS(B:B,A:A,A2) is looking to find the MAX of 1048576 Hour Meters where 1048576 Serial Numbers match the one in cell A2, then the same happens again with finding the MIN. 130K is a lot but still only 12% of an entire column.
As the data will expand I suggest converting the range to a table and modify the formulas in G, I and J to reference only the cells in the table. As the table expands the formulas should automatically update (i.e. when I added row 438 to the sample).
You may also want to consider adding another column (K) that would calculate =MAXIFS(C$2:C$437,A$2:A$437,A2)-MINIFS(C$2:C$437,A$2:A$437,A2)
This result could then be used in both columns I:J so that they don't both run the same calculation.
For I: =G2/(K2*0.711841205)
For J: =F2/(K2/30.4375)
Let us know if you have any questions.