unique records

  1. P

    Automatically select ranges and apply Concatenate Unique

    I have a table of 100,000 plus rows containing finance related data in which I would like to concatenate all the AccountTypes associated with a specific Journal Entry Identifier (JEIdentifier). Column 1 gives the JEIdentifier, Column 2 the AccountTypes, Column3 shows the AccountTypes prefixed...
  2. J

    Excel pivot: Unique records, frequency distribution, etc.

    I have a list with more than 10 000 rows containing Units/Sub-units. Each unit can have from 1 to n sub-units, and are characterised by a set of properties as shown below. Unit Sub-unit Property1 Property2 Fabrication status A 1 a d Not started A 2 b d Started A 3 a e Completed B 1 b d...
  3. C

    count unique records and summarize large amount of data

    Hi and thank you for reading this post. I am using Excel 2013 and Windows 7 Professional, and have limited experience with formulas and none with VBA. I have 51k records that list units of service and am trying to summarize the data, specifically : unique CYDID Sum of "Count" field per unique...
  4. K

    Sum costs from unique records having a given type

    <tbody> A B C D 1 Job# Description PO Type 2 3 5400 311 11st job 4 1101 NC Ward 350.00 deck 5 1102 IL Cotr flex 6 1101 NC Ward 350.00 deck 7 5204 600 Pat Place job 8 1102 IL Cotr 407.00 deck 9 1103 WA Brown flex 10 11...
  5. RudeRam

    Hide Rows based on cell content after unique records sort

    I have worksheet were folks will paste info into column A and Vlookup returns results. I have set a sort my unique records only, what I want to have happen if there is no data in column B 1 want that row to be hidden also. Ideally I’d like to combine with what I have recorded for the sort...
  6. F

    unique record list with formula condition to month

    I NEED THE UNIQUE RECORD LIST WITH FORMULA, OF EACH SELECTED MONTH <TBODY> NAMES</SPAN> DATE</SPAN> JOHN</SPAN> 5-Jan-12</SPAN> UNIQUE RECORD OF MONTH</SPAN> Feb-12</SPAN> FAIZAN</SPAN> 6-Jan-12</SPAN> ZEESHAN</SPAN> 5-Jan-12</SPAN> FAIZAN</SPAN> 10-Jan-12</SPAN>...
  7. J

    Summing Unique Combinations of Records in Data Table (like Pivot Table)

    Here's my starting data: <TABLE style="WIDTH: 144pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=192><COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR...
  8. B

    Duplicate Records

    I am trying to remove ALL duplicate records including the initial record. Using the "unique records only" leaves a version of the record. ie: Red Red Yellow Pink Green Green Blue with the "unique records only" function will leave you with Red Yellow Pink Green Blue I need something...
  9. N

    count number of unique records for each date

    Hi, I have a large report, that I want to be able to count the number of vehicles that worked on a specific date. This is how the data is being presented:- A B C 1 Truck: Truck 1 SEMI TRAILER 2 Hauler: abc cartage 3 20/04/2010 12:06:13 PM 8158540 4...
  10. J

    Unique Records Search

    I have a formula for counting unique text records. However, is it possible to count unioque records based on certain conditions. For example, I have a stats sheet for a sports league and I want to count all the unique teams for dsivision 'North'. Coloumn A has the division, coloumn B has the...
  11. G

    unique records of a column

    Hi all, is there any way to get unique records from a specific column in Ms excel by formula or VBA. i need to check unique records from specefic column and based on that criteria i want to paste all data from master sheet to other sheet. i have written a code to do the this but it works...
  12. N

    Unique records help

    Hello, I have downloaded data to an excel spreadsheet by day and need to calculate the unique records by day. Then all the daily totals should equal the monthly total if I ran the same date range for the month by removing the duplicates to get the unique records. How can I do this? nolanstern

Watch MrExcel Video

This Week's Hot Topics

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