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

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    • Replies: 31
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    • Replies: 26
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    • Replies: 24
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    • Replies: 23
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    • Replies: 23
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    • Replies: 23
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top