Formula to Auto-populate Sheet from Raw Data by Searching Data for Repetitive Instance

Hi there!

I have attached a dummy workbook of what I'm trying to do. I have a raw data sheet that auto populates from an hmi database. On the raw data sheet, date & time are populated for every minute over the course of 30 days. For each date & time instance, a code runs (in the hmi) to see if any pieces of equipment have turned off or started back up during that minute timestamp. If a piece of equipment has shut off, it will say "start" under "Downtime Start", else it will say "no start". If the equipment comes back on during that timestamp, it will say "end" under "Downtime End", else it will say "no end". These columns can be sorted to find the desired information to populate the next sheet in the workbook via copy/paste, but with the large volume of data and equipment and time, it would be a lot easier if I could figure out how to write a formula for each piece of equipment to search the Downtime start column for the instances of "start" and the following column for the instances of "end" and populate the corresponding time stamps onto the second sheet. I think I may need another sheet to first collect the useful data separated by piece of equipment before populating it all into one sheet? Maybe not. I started to do this with a logical IF function but there's no way to skip over the data that doesn't meet the criteria, so I still end up with a list that needs sorted for true/false instances. Also, for a vlookup, it just returns the first instance from each column repeatedly. Please help!!

Hi everyone!

I'm sure you get asked this often but I can't find what I'm looking for on the internet so I'm asking and yes I'm a new-be! No laughing

I have a spreadsheet of 9 cells across A4 - I4 (white)and around 900+ down (but will be adding to this number and that's where you all come in...). It'a a list across of company names, legal name, street address, city, state, zip, phone numbers, website and business type. I want to be able to pick a cell like A3 (green) to entering all new info across then click a cell preferably A1 (blue) to be formulated to "Auto Sort" where it will put the row alphabetically down where it below...simple right? I worked off a spreadsheet at my previous job and can work within it, but have no idea how to create one?

Can you help?

NardiScreen Shot.jpg

Hi Nardi.

Unfortunately your post breaks one of the forum rules..

2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread. You may include up to 3 links to other URLs in a single post, no more, so only link to the relevant pages.

Please take a moment to read the forum rules (there is a link at the top of this page) and create your own thread, linking back to this thread if you feel that it is relevant.