unique records

Hello, I'll try and keep this simple. Sheet 1: Current 12 Months In column B, I have a list of employee IDs. As this is an absence tracker, each separate occasion of absence for each employee is added as a new row (so the same employee could have multiple rows). Sheet 2: Occasions Current 12...

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

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

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

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

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

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

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

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

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

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

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

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