most recent data

Hi, Bit of a multi part question as new to PQ and PBI. I have an initial table of data storing audits by location, type, date and the score awarded. There are lots of things I want to eventually pull out/ display from the data but two main things to focus on: 1) Finding the most recent score...

Hi, I am trying to set up a calculation that calculates the flow RATE between dates where I actually have data. In the example table below, I have a total flow of 90 gallons on 05/05, and a total flow of 30 gallons on 05/02. Obviously, I don't want to have the formula set up to where its...

SKU STORE A A DATE STORE B B DATE 71011 1.87 2/21/21 1.69 10/7/21 71115 1.07 3/22/22 NA X FPF3 NA X 1.78 3/22/22 650876 6.34 9/21/21 6.08 10/8/21 503EZ NA X 9.00 3/22/22 72014 3.60 2/22/22 NA X 98823 NA X 5.05 2/21/22 PROBLEM: look up SKU and...

I am doing some research that involves importing data sets collected by an external instrument that can only be stored as .txt files. They are always stored in the same folder and importing them with the correct formatting is extremely repetitive and can be tedious. Is there a way for Excel 2016...

Hi I'm trying to build a spreadsheet that will be able to calculate current stock levels by taking into account what the last action was (e.g. stocktake, purchase, order), etc but I don't know how to write formulas that will do what I need them to do. Any data from before the stocktake...

Hi, I had posted a question for an If formula but i am thinking there might be a way of fixing my issue through VBA? This is my problem : I have a worksheet that will be constantly updated. In D53:CU54 i currently have an IF formula which looks at newly Inserted data in D100:DH101 (Via...