ohio

Hi Excel Masters! I have a situation here. I've created a search function where I can search a data set by typing in a client name (or partial name), and my table will return all entries with at least a partial match. I.e. search "Ohio" and it returns Ohio State, Ohio State University, Ohio...

Hello! If I use the formula in H2 and bring it down to H7, I get the desired results, unfortunately when it reaches H8 I get the #NUM result. I know that if I change the ROWS(F$2:F8) to ROWS(F$8:F8) I get the required result, but I'm just wondering if there's a way that would do it...

I have been all over the place with this one. What I'm looking for is a small piece of code to do the following. I get a monthly file with the turnover from departments from multiple states. I the files are stored on the Y:drive Every month the send the file in with a slightly different name...

I'm looking for a formula to help me determine the lowest set of data based on these characteristics. We have contests that we run that have certain base criteria. Here is what the criteria is for the 2 different states. For Michigan you need to be 15% above the minimum and for Ohio you need...