i have an xls which has 20000 records in it, it has peoples names in the
first collumn with dob names and addresses in, i want to delete people who
only occur once or are unique however as the other fields for the same person
are different when i do an auto filter selecting unique records, it displays
every record as being unique as there are different values in each field.
eg
bloggs joe 23/01/20 21 25 12 42 25
bloggs joe 23/01/20 21 20 11 42 85
smith sarah 01/05/06 20 12 51 28 42
smith julie 10/10/80 10 25 32 14 21
smith julie 10/10/80 15 24 24 28 95
from the table i want to delete sarah smith as she only occurs once but
doing a advanced filter wouldnt single that record out as the other values
are unique
any help would be greatly appreciated
I have a spreadsheet that looks like this:
ACCT LAST DISPO BAL Fwd RET DTE ACTION LPY
1234 MOUSE 1234 1111 22 1/25/06 GW 4/6/96
1234 MOUSE 1234 1111 22 2/3/06 GW 4/6/96
1234 MOUSE 1234 1111 22 3/5/06 GW 4/6/96
1345 SMITH 1234 1111 33 5/6/06 GW 5/5/06
1345 SMITH 1234 1111 33 7/16/06 GW 5/5/06
This goes on with different accounts for 10,000 lines. What I am looking to
do is only keep the accounts where the RET DTE is the most recent of however
many may be the same. So what I want to see is this:
ACCT LAST DISPO BAL Fwd RET DTE ACTION LPY
1234 MOUSE 1234 1111 22 3/5/06 GW 4/6/96
1345 SMITH 1234 1111 33 7/16/06 GW 5/5/06
Is it possible to do this?
Good morning -
I am having a bit of trouble trying to delete a certain number of records from a table based on another tables information. For example, record # 456 has 6 instances of an action. The other source table is telling me that 3 of those instances need to be removed based on duplication. Both tables have a matching reference number and process date, so it doesn't matter which records are removed exactly just that I have 3 remaining...
I was thinking of doing a count of reference number for each table and then deleting the number of records from the difference...
Any ideas?
Thanks in advance!
I have two tables: Hours History and Hours Adjustments. Both have the same fields: EmpNo, EmpName, DBA, NumHrs, and Date. Is there a way to have a record deleted from Hours History if it matches identically to a record in Hours Adjustment? I do not want to delete the record in Hours Adjustment, only in Hours History.
Thanks in advance for any assistance you can offer
Foxhound
I have a spreadsheet that contains duplicate references in Col H. I would like VBA code that will retain either the first or second duplicate, except where the reference begins with an Alpha Character.All references beginning with an Alpha character must be retained
In the example below all the references beginning with an Alpha for eg F14890 must be retained. One of the rows containing the duplicate references for eg 203432/1 must be deleted and the other one retained i.e one unique record must be retained
Your assistance in this regard will be most appreciated
******** ******************** ************************************************************************>
Microsoft Excel - Duplicate Records.xlsx
___Running: 12.0 : OS = Windows XP
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
A26
=
A
B
C
D
E
F
G
H
26
10-03-2011
INV
PARTS ORDER
30I00223
-6,199.32
203434
27
10-03-2011
PMT
PARTS ORDER
453,208.67
F14890
28
10-03-2011
PMT
PARTS ORDER
27,118.04
F14890
29
10-03-2011
PMT
PARTS ORDER
27,118.04
F14890
30
10-03-2011
INV
PARTS ORDER
30I00225
-729.50
203432/1
31
10-03-2011
INV
PARTS ORDER
30I00222
-1,286.83
203433/1
32
10-12-2010
JDR
PARTS ORDER
8424
8,513.92
8424
33
10-12-2010
JDR
PARTS ORDER
8424
8,513.92
8424
34
11-02-2011
INV
PARTS ORDER
30I00080
-26,243.49
199979
35
11-02-2011
INV
PARTS ORDER
30I00080
-26,243.49
199979
36
11-02-2011
INV
PARTS ORDER
30I00079
-6,985.30
199980
37
11-02-2011
INV
PARTS ORDER
30I00079
-6,985.30
199980
38
11-02-2011
INV
PARTS ORDER
30I00015
-519.16
199981
39
11-02-2011
INV
PARTS ORDER
30I00015
-519.16
199981
Sheet1
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
Hi,
I wanted to count the Unique records in ColumnA of TableXYZ.
Using the Group by and count will give me all the records in ColumnA, but I just want the unique total records. Do you know how to do this.
... I know I can just use the "group by" and then see how long the table is but I wanted to get the result as an output.
Also do you know how to set a variable in a macro equal to the count of this query? I tried fiddling with the sql statement but I couldnt get it to work.
Thanks
Hello,
I have a column of numbers, where some are duplicated.
The 'filter unique records' feature gives us the first entry of a duplicate.
Is there any way to make Excel choose the last duplicate instead?
Thanks,
David
I have a simple delete query.
Made up of 2 queries.
Query 1 [Upper and Lower dates] finds the max and min out of set of records [Lower1]
Query 2 contains the data.[Demand]
What I want to do is delete the data that is less than [Demand].[WkYr]
DELETE DISTINCTROW demand.*, demand.WkYr
FROM demand, [Upper and Lower Dates]
WHERE (((demand.WkYr)
I have a question on Excel, I'll try to explain.
I am a data analyst and I received data to analyse monthly. This data is overlapping, in other words I will receive October data and then receive November data and some of the data overlaps or duplicates the prior months data. Is there a way I can merge the two months of data and then extract only the most current data from the two months, eliminating duplicate entries? You guys are the best if you can figure this one out.
Thanks for your help, George
Hi:
I have the following list:
AIS - 12.50
BOS - 11.50
CCU - 10.00
BOS - 12.50
AIS - 45.00
CCU - 58.00
BOS - 12.00
How do I get the sum for the unique records in the list. (the sum for AIS, BOS,...)
Thank you.
