kent

Hi All, Would it be possible (via VBA) to replace text in an already existing column IF a cell is not blank, the existing text is as follows (in one column on worksheet one): <colgroup><col></colgroup><tbody> Name:Clark Kent Address:Smallville State:Kansas Country:US </tbody> on...

Hi all At Power Bi how to make it? If the customer have positive for continuous 4 days, will automatic show how many days.No matter on which day, as long as continuous 4 days. example 1: kent continuous already exceed 4 days (positive) , he total got 6 days (positive). then automatic show me...

Hello all, I hope this is a nice simple fix but I can't work it out. I have two sheets P - Paste and F - Front On Paste sheet, the four relevant columns are: <tbody> C M N Q 1 Advert Code Paper Name Template Size 2 Holland Cruise RT Kent Courier - Mon 16x5 3 France Beach RT Kent...

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...