received

Hi All, I am looking for a formula to extract data from a list dependent on what is in columns D ie the list on sheet 1 will be A1 : Parts B1 : Description C1 : Cost D1 : Status On sheet 2 I need A1 : Parts only with "Ordered","Partially Received" or "Pending" status B1 : Description with...

I have a date a file was received in one column then in another I have a if statement that says if its complete countdown 30 days from the time the file was received but minus weekends. Your help appreciated , thank you!

Hi I've created a formula to calculate the OH as of 1 YR ago today. But I would like to find a way to figure out the OH as of any date I enter into a cell or select from a drop down (Calendar table) What the current formula does is take OH now + units sold in the last 364 days, - whats been...

Hello all, First of all, let me present you my sheet: I have an EXCEL file used to store all received quantities of different products for a project. The first columns contain info such as: designation, supplier, reference. Then: D = total qty received until now E = total qty received in the...

Will just get right into it: In column E, I have a received date (for new accounts). In column U, I have expiration dates (for existing accounts). In column J, I have account statutes. I want to put a formula in another column that basically does the following: If column J says "pending"...

Hi, Is it possible to have the watermark, in this case "DRAFT" permanently showing in the worksheet rather than just coming out when the worksheet is printed? Any assistance would be gratefully received. Regards Ben

Hi, I'm having trouble coming up with a formula (or formulas) needed as part of an SLA calculation. A1: Case Received Date and Time (in MM/DD/YYYY hh:mm AM/PM format) B1: Case Completed Date and Time (same format) I need to compare these two dates to identify if the case was completed within...