pickup

Hello, I have data set that looks like 10/25/19 02:03:00 PM. I want to find a way to change another cell IF this cell's time is after 02:00:00 PM. Essentally, if the order was created after 2 PM, my pickup date (Column F) should be +1 data set looks like this Column D Create date D1 Cell ...

Hello, I have a file that I declare as "ml" with the renamed as "list" This file has two fields I'm interested in, "Addr8" and "Pickup" Unfortunately, these two columns change for each campaign so I can't reliably tell the Vlookup that Addr8 is [U] and Pickup is [AA] Here's what I have...

Hello all, hope you're doing fine.. So I made this dashboard with some data I insert every once and a while, and in the table that contains all that data I have two columns stating the some locations. It's a simple table where I insert the pickup location in one column and the delivery location...

I have a set of data in an excel spreadsheet that I have filtered. I would like to find the 75th percentile of some of the data, but I do not want to pickup the “hidden/filtered” rows in the data set.Does anyone know a formula that circumvents this? Thank you!

Hello there, I am trying to repurpose coding that is used in another workbook to make it effective for the one I'm trying to create now. Essentially, it combines all the data from dozens of files into a single file where I can extract the data and/or utilize in pivot tables. There's a line in...

Hi, I am working on an excel wherein there is login and logout mentioned for employees. I am looking out for a formula which will count from row 1 all the time related cells and give me an output. For Eg. In row 2 the Pickup should be 0 and the Drop should be 1 (since there is time on 6/9/17...

Hi I have two pictures, Picture 1 and Picture 2. I Need a macro that will allow me to assign picture from Picture 1 to Picture 2. If I use shapes with picture fill, I can use PickUp and Apply, yet, I'd rather use pictures. Is there a way to do something similar with pictures? Thx for help