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

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    • Started by ipbr21054
    • Replies: 37
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    • Started by Moeey
    • Replies: 34
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    • Started by AllisterB
    • Replies: 30
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top