User Profile

MattP817

Copper Contributor

Joined 4 years ago

13 Posts1 Like

View All Badges

User Widgets

Recent Discussions

Re: Help with excel formula
This looked like it would work, but I have info that changes in the column. For instance, In T3 Data D15, I need to add cells ('B1 Data'D16:F16,'Retail Blend Data'D16:F16, 'Retail Blend Data'D19:F19,'Retail Blend Data'D22:F22)
Sep 14, 2023 Place Excel
1.3KViews
0likes
1Comment
Re: Help with excel formula
How would I "lock" that range of cells when I drag it over? In this case, I need it to add the three cells from each day (three shifts), but in future sheets, I will be adding areas that only work two shifts.
Sep 14, 2023 Place Excel
1.3KViews
0likes
0Comments
Help with excel formula
Hello, I need some help linking multiple sheets. I need to pull data into ‘T3 Data’ D4, from (‘Titanium Data’ D5,E5)&(‘Dryer Data’ D5,E5,F5)&(‘B1 Data’ D5,E5,F5)&(‘Retail Blend Data’ D5,E5,F5) My other formulas on my “Display” sheets pull the info from singular data sets based on the date and/or shift information. T1 Display pulls previous shift data, T2 will be past 24 hours (multiple shifts from that same day. T3 will add all data sets for the previous 24 hours Can somebody help me throw this together? Way above my knowledge level.
Sep 13, 2023 Place Excel
excel
Formulas and Functions
1.5KViews
0likes
5Comments
Help with Xlookup syntax
Hello I am in need of some help. This is a production KPI/Tier board that I am setting up. I need help setting up the general formula that I can continue on the rest of the sheet. On the data sheet, production is going to the date and shift located at the top of the sheet, and then working down, they are entering the data points. I would like to have the formula lookup the date in C2(Titan T1 Display Sheet) and then the shift from D2 then pull the data point from that KPI from the data sheet. Here is my formula that I am getting a "#Value" error on: =XLOOKUP($C$2,'Titanium Data'!3:3,XLOOKUP('Titan T1 Display Sheet'!$D$2,'Titanium Data'!4:4,XLOOKUP(C4,'Titanium Data'!$C$5:$C$45,'Titanium Data'!$D$5:$ARY$45)))
Solved
Sep 06, 2023 Place Excel
excel
Formulas and Functions
1.2KViews
0likes
1Comment
Re: Help setting a large amount of cells to Absolute Reference
You Sir, are a gentleman and a scholar. I appreciate your help! Signing up for some extra Excel classes this semester. I need to be able to understand more of these complex formulas.
Jan 14, 2022 Place Excel
2.2KViews
0likes
0Comments
Re: Help setting a large amount of cells to Absolute Reference
That worked for column A and B! Thank you! This is way above my Excel knowledge base. I still need help on column C. I have an extra division step in that column and I cannot figure out how to implement it into the new formula. Can you take a look at that one for me?
Jan 13, 2022 Place Excel
2.3KViews
0likes
2Comments
Help setting a large amount of cells to Absolute Reference
I have three columns with 4380 cells each that I need to change them to absolute references. Long story short. This is a database that is fed from Power Automate forms. Every time a new row is added into the "ShiftData" table on the "Data" sheet my formatting gets messed up. I have an additional sheet that is pulling the calculations, and than I reference that cell on my "Data" sheet to bring in the calculation. I have everything working correctly, now I just need to make them absolute so that the correct data carries over and the cell references do not change. I was trying to setup these formulas into the data sheet where PowerAutomate drops the data, but it wouldn't maintain the formulas. I thought setting up a separate sheet that grabbed the data and completed the formula, I could reference those cells on the data sheet. A4, A7, A10, A13 - B4, B7, B10, B13 - C4, C7, C10, C13 are all setup correctly. I dragged the formulas down, but when new data is entered the formulas end up changing. I am thinking that if I switch all of the formulas to absolute, It should work smoothly...I hope. I have tried macros that I have found on threads, but I cannot get them to work correctly. PLEASE HELP 🙂
Solved
Jan 13, 2022 Place Excel
excel
Formulas and Functions
2.4KViews
0likes
4Comments
Re: Multiple IF statements, I think
YOU ARE A GENTLEMAN AND A SCHOLAR!
Dec 06, 2021 Place Excel
2.2KViews
1like
0Comments
Re: Multiple IF statements, I think
mtarler Thanks for the update! I have a couple more issues. I have the formula loaded (XLOOKUP). I have a few errors I am trying to work out. I owe you big time for all of your help! On G1072 it is looking for the previous time we ran that material and it is pulling the data from cell F270 giving me a negative. Same thing on G1036, pulling from F891. On cell G714, we switched POs, but ran the same material. How would I be able to fix an error like this
Dec 06, 2021 Place Excel
2.3KViews
0likes
2Comments
Re: Multiple IF statements, I think
It won't always be 0 after a changeover. They might finish the changeover early in the hour and still produce units before the next hour.
Nov 23, 2021 Place Excel
2.3KViews
0likes
4Comments
Re: Multiple IF statements, I think
mtarler a) can you share the sheet? Attached b) can I assume columns C and D will be #s for non-test time? Column C is a material number that they are producing. Column D is just an informational column for the production line. E is a changeover event. F is the last unit # that was produced during that hour. G is a run rate based off the difference between the previous hour to current hour. H is a target based on the material number (VLOOKUP). I is the difference on units ran vs target (G-H). J is based off the units ran and the weight of the units they are producing. c) looks like you need to have special condition for 5am in general. d) I'm not sure why/how the formula is failing in the above case. From what I see I would expect it to fail because of the merged cell/line just above it but that isn't what appears to be happening e) i assume you mean subtract red from blue (but in this case it is 0 either way). That said, if it will always be 0 (i.e. it starts up where it left off after testing) then that could make this all much easier. Yes. My apologies.
Nov 23, 2021 Place Excel
2.3KViews
0likes
0Comments
Re: Multiple IF statements, I think
mtarler So I got the formula plugged in for the 6:00 am hour to the following 5:00 am hour. When I move to the next day, it is not jumping to the line that is prior to the "WTN". I need to subtract the light blue cell (F1184) from the red cell (F1175). Is there a way to have the formula skip anything >"" in the E column when production resumes, but still calculate the formula in during the changeover event?
Nov 22, 2021 Place Excel
2.3KViews
0likes
7Comments
Multiple IF statements, I think
I have a production run sheet with a column that indicates a clean. After the clean, when our operators enter the production unit # they are on, I need it to reference the production unit # they were on prior to the clean. Right now, I have a Vlookup referencing the run rate based on the item # (Column H). The operators manually enter the unit # they are on (Column F). I have an IF statement =IF(F1174<F1173,F1174,(F1174-F1173)) to calculate the hourly run rate. If they start a new product, it will take the new unit #. If there is a clean in column E, I would like to find a way to reference the previous unit # in column F that they were on before the clean. PLEASE HELP 🙂
Solved
Nov 19, 2021 Place Excel
excel
2.6KViews
0likes
9Comments

Recent Blog Articles

No content to show