dynamic search

Hi folks, I'm having difficulty finding a better solution for a work schedule that will sum the total hours of a worker based on the date. I've currently use sumifs but this require an extra dates column in front of each set of timein/timeout/name. My current formula looks something like...

Please forgive the length of this request, as I will try to give as much information as possible. I have a database that consists of three different sheets of information that correlate together. In one of the sheets, is a list of IP addresses that form a path through a network. I need to set...

Hello Everyone, thanks for taking a look at my question. I need to create a macro that will "check" if a file contains certain heater information. Row 1 (sheet: File) contains header info example: FirstName, LastName, PhoneNumber..... however, sometimes these are in the wrong order or are...

Hey all, I retrieved a value from a range, and I am trying to apply a LOOKUP to retrieve a corresponding value, in the cell next to the returned value cell. In the range that I am pulling the data from the corresponding value is to the left of the first value, so a VLOOKUP will not work. The...