received

Hi, I have the following input table: <!-- Please do not remove this header --> <!-- Table easily created from Excel with ASAP Utilities (https://www.asap-utilities.com) --> <table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellpadding="0"> <tr><td bgcolor="#FFFFFF"...

Hi I have this formula but I want to adapt it to find any special character not only a slash. Any advice gratefully received. the rest carries on to another IF statement. =IF(COUNTIF([@[Network ID (08) POS]],"*/*"),"SP CHARCTER", Many thanks

I have a need to match data from one column to another and then post in a third column (received) Using a scanner to read a barcode to post in the second column. Want the number posted to look at column one and find the matching number and then reach to a hidden cell to pick up the (Received)...

Hello everyone, Please see the data; <tbody> Installment Due Date Installment Receipt Date 31-01-2019 28-01-2019 28-02-2019 30-03-2019 30-04-2018 </tbody> the first column is Installment date while the second is the actual received date. As i have a large data i want some formula...

Hi, I have a spreadsheet for work with bookings in it, there’s multiple columns but I need to transfer data from one cell to another based on the following IF column A has a certain date in it AND column B has a certain time in it AND column C has a certain word in it then I want it to take...

Hello everybody. Every hour I receive a mail from the address example@example.com (no others mail are received from this address). I need two things: 1) save the attachment in a specified folder (received in csv.7z, saved in xls); 2) trigger a macro from vba Excel that is supposed to elaborate...

This is my first time posting, hopefully doing it correctly, will happily clarify anything as needed. I would like some help creating a worksheet to track papers received and sent out for corrections. Where I enter the initial numbers of papers received in the top cell, and then enter the...

Can someone help I have the below problem. The first column is the PO, each PO contains a SKU or multiple SKU's There is also columns for expected and received qty's . At the end is a % against the SKU . What I want to do is just to have what the % is based on the PO and if there is a line with...

I need code that will be triggered when a date filed is changed. I want to put a value (the number of days between two dates) in an unbound field on my form "KickOff_A" I need to "Dim" and then set the values (If that makes any sense). I know this is wrong but I assume it would be something...

I have read many post about "Countdowns" and "Timers". None of which provide me with the correct formula or knowledge into what I am actually looking for. So I figured I would ask the question here specifically to see if I could grab some help and understanding. Back ground: This is need for...

I created an expression from tables. in the formular, I referenced the tables. See below on DailyUsageForecast. I want to take the daily forecast below and multiply it by 7. Must I reference a table? I received an error when I did not. I am not sure what table to reference since it is the...

Hi guys, Trying to calculate the instances of certain occurrences happening. Count EVERY 1 to 1 Count first instance of Group 1, 2 and 3 Do not count Absent: I want to calculate it at the bottom of the range B5:B16 (so in cell B17). can get certain aspects of the formula but not fully working...

Hi, I am trying to create a formula to count worded cells, but to exclude certain words. the basic chart is: Column Q 12/10/17 1) yes 2) always 3) DNA 4) Yes all the time 5) Occasionally 6) Only on a Wednesday 7) Absent 8) All the time 9) Each 3rd Month 10) Never So I want to find I...

Hello, I have been working on this formula for the past few days and it is just not working at all, please help? In sheet 1 - in column A, I input dates from Sheet2 and Sheet3 and insert the desire formula in C2-C9 it should pull in the invoice# and the quantities in D2-C9 from sheet2 and...

Hi ALL, Can anyone help me with this? I opened Excel and received this error message: Before this happened I installed Office 2016 64bit Thanks for any help!

I developed and tested some VBA code using Office 2013 and was working perfectly. BUT when I ran it on Office 2007, the code breaks at this line... ActiveSheet.Range("D6").Value = "=" & Worksheets("Formula").Range("AlarmsStatusFormula").Value the error msg I received was Run-time error 1004...

Hi Experts, i want to calculate 8 hour TAT Senerio:-Working Hours 8:00:00 Am to 5:00:00 PM and Sat and Sunday Week off if i received one file at May/30/2018 9:30:00 AM for this we should calculate 8 hours TAT (Ex:-i have received one file at May/30/2018 9:30:00 AM for this file tat is next...

Hi, I have 24 different sub-Processes and all has different deadlines, for e.g. Sub-Process A needs to be completed in 24 hours from the received date. Sub-Process B needs to be completed in 10 Business days from the received date. If from the drop down a sub-process is selected and received...

Hi, I have a workbook containing some data. Some of the columns contain more than 1 data put together in 1 cell. Now I have responsibility to separate them and make a new sheet with each item in its own column. The sheet contains 11 columns Columns 2, 4, 8 and 9 contain mixed entries Col2 =...

Hi I'm trying to filter a list of items received. I'm drawing the data from my POWERPIVOT. I have received items many times and need to know the # of weeks on the floor. Then I want to filter only items that are new IE first received in the last 4 weeks. I've tried these with some adjustments...