10/1/2018

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

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

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

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

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

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

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

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

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