kent

  1. E

    Replace text if a cell is populated via vba

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

    Power Bi how to meke continuous exceed 4 days (positive), will automatic show total Positive days

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

    VBA - De-duplicating columns, pasting vertical values horizontally

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

    Lookup unique values from two different columns

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

    Advanced filtering on two criteria not working

    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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top