10/1/2018

  1. M

    macro or logic to remove duplicates by time/date

    I’ve got a problem with removing duplicates from set of data Column A is a client Column B is a product Column C is the date when it’s effective What I want to do is few steps which I can’t figure out how tocombine: Sort by columnC – Newest to oldest Removeduplicate rows – here’s the...
  2. P

    Count Unique Values with Multiple Criteria

    How do I count the unique Dates (Col B) for each project (Col A)? I'm expecting 6 for Project A and 2 for Project B (in the sample below). <colgroup><col><col><col><col><col></colgroup><tbody> Project Sprint Project # of Sprints A 9/17/2018 A 6 A 10/1/2018 B 2 A 10/1/2018 A...
  3. D

    Max of date not working

    Hello. I have a query where I am doing Totals to get the Max date. The table has dates of 1/1/2018, 4/1/2018, 7/1/2018, and 10/1/2018. Each date may or may not have a different price for any item. When I do MAX in the date Total row I get 1/1/2018 AND 10/1/2018. Not just 10/1/2018. Price is...
  4. D

    Formula Assistance

    I have 2 columns of time stamps that track when a case owner changes hands and would like to pull the last time stamp when the case was closed (In Bold - column E) and subtract it from the time the case was opened (In Bold - column C). Is it possible to search the first time for case # 12806301...
  5. T

    Excel Macro

    <tbody> <tbody> Below is a sample of our payment register. Our check register prints the total of the check on the first line and then the account breakdown of the checks on the lines below. I need the check number and the Check Name to show up on every line of the account breakdown...
  6. L

    Merge multiple rows with unique ID but keep notes

    Hi Team, Looking to see if this is possible with excel VBA. I have a spreadsheet that has 4 columns 1) LeadId 2) ActionDateTime 3) ActionTaken 4) ActionNote 5) Finalized Note On this spreadsheet I need the "LeadId" to be de-duped, but the different log entries of the...
  7. S

    Comparing two columns in different sheets with unique identifier

    I am trying to compare two columns in excel with the same unique identifier and highlight the cell if it is different: <colgroup><col><col><col><col span="2"><col><col></colgroup><tbody> Unique Description Date Unique Description Date 123 Test 10/1/2018 126 Test 10/5/2018 124 Test...
  8. B

    Vlookup/Index match question

    HEllo Guys, I need help. I have an excel spreadsheet with three columns. Column A has store numbers, B has dates and C has dollar values as displayed below. I want to display column C values on another sheet that has Column A (store numbers) in a column and the dates in a row. I want to...
  9. J

    Converting data Wide to long with dates

    Hello, I was trying to convert the following table <colgroup><col width="94" style="width: 71pt; mso-width-source: userset; mso-width-alt: 3437;"> <col width="85" style="width: 64pt; mso-width-source: userset; mso-width-alt: 3108;"> <col width="68" style="width: 51pt; mso-width-source...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top