clark

Thank you for your time. I need a vlookup formula that says the following: If, in workbook x, column C you see any of the words in this workbook cell D2, AND you also see a number that matches the number in cell G2 of this workbook, then please put the number in cell G2 into cell H2. Example...

Hi everyone, I would like to be able to summarize unique values from two different columns. Here is my example: Column A (Month) | Column B (Name) January John Doe January John Doe January Clark Kent February...

I have a data set of 72,000+ rows. I want to filter that data based on two criteria. The problem is that I'm getting way more data that I'm supposed to. Example: <tbody> Employee Name Employee ID Hours Job Code Clark Kent 123456789 8 YX890 Hal Jordan 987654321 8.5 AB123 Clark...

Hi, I am trying to learn how to use index match function when there is multiple variables. I am getting NA error below is the screen shot can somebody explain where i am going wrong and what i need to be careful when i am using the formula. I am using ctrl+shift+enter to sun this formuls...

Hello I just like to pick your brain. I have a column which has the firstname and lastname (one space between them). I want a new column which has the "lastname, firstname". One way I am thinking of is to use Text-to-Columns to separate the firstname from the lastname, then I will use...

I'm trying to parse out text strings from a source that is not consistently formatted. These extractions will be inserted into separate cells. In a "perfect scenario", the data source should be formatted in the following manner: Cell C1 1. Business, Clark Kent 2. Solution, Diana Prince 3...