Excel 2003 :: Delete Duplicates Based On Value In One Column

Jun 5, 2014

Excel 2003 - delete duplicates based on value in one coloumn.

very simple but how!i want the whole row deleted where there are duplicates in one column but ONLY the duplicates, so, if they're 3 duplicates in the column i want 2 deleted leaving 1 unique record.

View 4 Replies


ADVERTISEMENT

Excel 2003 :: List Duplicates In Separate Column

Jun 14, 2013

Running Excel 2003. I have a list in column B, of numerical codes. What I want to do is find the duplicates, and list the duplicates in column D. Is this possible?

View 11 Replies View Related

Excel 2003 :: Translating Remove Duplicates Function To Work

Oct 16, 2013

I've been left with a macro built in 2010--but I need it to run in 2003.

I've identified a Remove Duplicates function as the cause of a bug, how to translate this to a 2003-friendly macro? This will be an action in a much longer macro. What I am trying to do is check for duplicates in a particular column (Column C), and remove any duplicate row (it doesn't matter which duplicate is removed).

VB:

'Remove duplicates
Sheets("Input sheet").Select
ActiveSheet.Range("$B$4:$H$2005").RemoveDuplicates Columns:=3, Header:= _
xlYes

View 3 Replies View Related

Delete Duplicates From A Column

Jun 19, 2013

I have a column with text values, I would like to remove all the duplicates. How can I do that??

View 4 Replies View Related

Delete Duplicates In Column D Only?

Jun 3, 2014

how to Delete Duplicates in Column D with a macro. It would search all of Column D and look for Duplicates and if it finds an exact value match it will delete one of the rows containing the duplicates. This is running in between a much longer macro which is the reason why I can't do it with conditional formatting.

View 12 Replies View Related

Delete Duplicates In Column D?

Jun 4, 2014

I'm trying to create a macro that will Delete Rows of Duplicates found in Column D. It will start with the first row it finds that is yellow and check to see if that Column D matches any other yellow Column D's. If it does then the row the match is in gets deleted. Right now it searches in between the yellow rows, but for this portion I'm looking for it to use the yellow rows only. I included a file that has the examples on sheet1 and the expected outcome on sheet2.

View 6 Replies View Related

Delete Duplicates In Column

Jul 2, 2009

Hi, the code in the codebox under here, which I wrote, is supposed to delete all duplicate records in the column. Which column to uniquify is stated in cell Skin!B17. I searched the internet round, and there are different solutions everywhere. I have been unable though to find the right one - so I thought, why not ask here. If you have a solution, I'd be happy to hear it ...

View 14 Replies View Related

Delete Duplicates In A Column

May 9, 2007

Here in the excel sheet i have columns upto K with rows upto 3295 In these columns the F column has Duplicates in that columns

My question is how we can delete the duplicates in that F column so that i can see my excel sheet without any duplicates in that F column.

View 3 Replies View Related

Delete Rows Based On Duplicates In X Columns

May 14, 2006

I've been looking through various forums looking for a macro for a particular task, but I have not found something that works yet. Maybe someone could help me out? It's pretty straightforward situation.

I need a macro that removes an entire row when: information in column B and column C are both found in other rows ( duplicates).

I'm dealing with a worksheet with store record information ... Store Name (column B), Street Name (column C), State/Province, etc. I import new store records all the time and many are invalid because they share the same name and street address and therefore need to be removed. The ones that Iíve played with unfortunately end up deleting the cells only and not the entire row.

It's a tedious process to do manually remove entire rows (for duplicate column B&C) when dealing with thousands of rows and I would very much appreciate any assistance or insight into how simplify the process with a macro. I've attached a sample of what I'm working with.

View 9 Replies View Related

Delete Duplicates Rows Based On 2 Columns

Dec 6, 2006

I want to delete the current row if the data on row A and Row B match. Its hard to explain so I posted an example.

View 5 Replies View Related

2003 Delete Rows With Specific Value In Column C

Apr 13, 2009

I need a code that will go thru column C and delete the whole row if cell value is 78315, Also it needs to shift the the rows up so there is no empty rows wheneverything is done done. I used some codes but they take forever to go thru whole sheet.

View 4 Replies View Related

Compare Two Columns-delete Duplicates From Just ONE Column

Oct 7, 2009

I have column A that is 1,500 records.
I have column B with 40,000 records.

Among the 40,000 records in column B, duplicates of ALL 1,500 records from column A exist.

My question is: How do I find WHERE the 1,500 dupes are and how can I delete JUST those records?

View 3 Replies View Related

Excel 2003 :: Use Find And Replace To Delete Word?

Dec 1, 2005

I'm looking to simply delete certain words that are in cells, without having to delete rows, columns or the entire cell. I can use 'find and replace' and replace the particular word with a space, but I really want to delete the word. I'm using both Excel 2003 and 2000.

View 4 Replies View Related

Excel 2003 :: Data Validation - Disable Delete Key

Mar 31, 2010

I'm using Excel 2003

Cell D7 - data validation reads as such: It is a List and the source is I6:I7. I have In-Cell dropdown selected. Ignore Blank is not checked.

I now password protect the sheet and only D7 is unlocked. real simple, the person using it can only use D7 and select one of two in the drop down menu.

The problem is, if the user clicks on D7 and hits delete, the cell goes blank. How can I avoid this?

View 8 Replies View Related

Excel 2003 :: VB Code To Delete ALL Named Ranges

Mar 22, 2012

I have a spreadsheet, but it came from another file using the detach sheet method. It has therefore taken with it, all the named ranges that are now superfluous.

It seems a bit long-winded to delete these named ranges one by one manually. Would there be an easy to understand script that would delete them all, so I can start with a "clean sheet".

I'm using Excel 2003.

View 5 Replies View Related

Excel 2003 :: Macro To Delete Rows In A Table

May 19, 2013

a VBA problem I have and I do not know how to solve. I use Excel 2003.

I have a workbook with a table; all cells except the table area are locked so at users cannot add any data. The table is on D2: H?. The workbook is password protected (users can only "Select unlocked cells", "Format cells" and "Sort"), and for that reason there is a "Add Rows" macro button so they can add more rows if necessary. It works well.

There is also a "Delete Rows" button, but it does not work as I want it to do. If the table is for example on D2:H4, and I select a cell on row #3 (ex. D3, or E3, or H3) and click on the button it deletes row #3, if I click on the button again it deletes row #4, and if I click on the button again it also deletes row #5 and so on, but it should not do it because all rows below row #4 are locked and should not be deleted.

I found on the Internet a code that I modified, but I do not get it to work. Below are the two macros.

My original macro (it deletes even locked rows):

Sub DeleteRows()
'
ActiveSheet.Unprotect Password:="123"
'
Selection.EntireRow.Delete
'
ActiveSheet.Protect Password:="123", DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowFormattingCells:=True, AllowSorting:=True
End Sub

The macro found and modified (the original rows are commented):

Sub DelRows_2()
Dim rngDelete As Range
Do While rngDelete Is Nothing
On Error Resume Next

[Code]....

View 2 Replies View Related

Excel 2003 :: Userform - Ok Button To Delete Data When Clicked On In Combobox

May 8, 2012

I have a userform that has a combobox in it that also has an OK button and a Cancel Button. Need getting the combobox to pull in the correct list? The data for this list will be in cells A2 through A16. But not all 15 lines will always have data in them so I'd like to only show the ones with data. Then next issue i have is I would like the OK button on this userform to actually erase the data the user has clikced on in the combobox. It's a list of kids that the userform is asking which one needs to be deleted. So it might be the kid in cell A9. so when the user clicks on that kid in the combobox form a9 and hits ok I'd like to have all the kids below A9 move up one row.

Windows XP
excel 2003

View 6 Replies View Related

Excel 2007 :: Search Worksheets And Delete Entire Row When Duplicates Found?

Jul 17, 2013

I have a excel 2007 workbook that has 5 sheets "MASTER" , "RED" , "WHITE", "GOLD" & "BLUE". There are 7 columns in each sheet and the master has about 8,000 rows . In column D of each sheet there is a unique number (approx. 8 - 10 digits ) that I would like to at the press of a command button search through sheets "RED" "WHITE" "GOLD" & "BLUE" against the unique numbers in the "MASTER" sheet and if there any duplicates numbers delete the entire row but leave all the data in the master sheet.

View 2 Replies View Related

Excel 2003 :: Count Column A When Y Appears Only When Column B Has X?

May 14, 2013

I need to populate sheet 1 of the spreadsheet attached.

I have tried several formula's but don't work and am getting desperate!

I need to count Column A of sheet2, when "Adverse SEN" occurs but only when there is an "x" in Column B of sheet 2 appears next to "Adverse SEN".

So basically i need to populate Sheet1 of the spreadsheet with the data is sheet2 of the spreadsheet.

I need a formula to calculate how many time an adverse SEN was - where there is an x - resubmitted, approved at meeting, delegate approval obtained, approval outstanding, rejected or approval not required.

I am using excel 2003, so please don't provide me countif functions.

View 2 Replies View Related

Excel 2007 :: Remove Duplicates In Column B For Each Value In Column A?

Jan 8, 2014

I need to remove the duplicates under column B for each item under column A and I can't seem to figure out how to do it.

I'm using Excel 2007; I would prefer a VBA solution, as I have to do this on a monthly basis. However, if a formula is the best way to go, then that's just fine. Either way, I'm preparing the data for a pivot table. I am unable to post the actual document in the interest of data protection.

Essentially, I'd like to turn this-

_ A B
1 Paris Bill
2 Paris Bill
3 Paris Mike
4 Paris Derek
5 Paris Derek
6 London Mike
7 London Bill
8 London Mike
9 London Bill
10 London Derek
11 Tokyo Derek
12 Tokyo Derek
13 Tokyo Derek

into this-

_ A B
1 Paris Bill
2 Paris Mike
3 Paris Derek
4 London Mike
5 London Bill
6 London Derek
7 Tokyo Derek

In other words, each city should have only one instance of any name that accompanies it; not all names will accompany each city.

View 8 Replies View Related

Excel 2003 :: Macro - Move Row Down Based On Value

May 20, 2014

I'm new to macros. I have a data range of A6:H100.

If cells in column H (Complete?) = Yes I want the row moving down to the next available empty row.

Collection DateCustomer Order NumberNo of PalletsHaulierContact Date Collected Complete?

(I'm using 2003)

View 1 Replies View Related

Excel 2003 :: Highlight Row Based On Specified Columns?

Dec 19, 2012

I would like to have Excel 2003 be able to highlight the row if there is data in certain columns. Specifically if there is a number greater than zero.

For example the following could work:

[CODE][=OR(LEN(H9),LEN(I9),LEN(K9),LEN(Q9),LEN(R9),LEN(S9),LEN(W9),LEN(X9),LEN(Y9),LEN(AB9),LEN(AD9))/CODE]

However, there are times when I need to add a column/criteria. Thus I would have to go into conditional format and redo all the rows in the worksheet. Is there a smarter way to do this?

I was hoping to provide a list of cell address from the header or better than that look for specific numbers in the header row and if there is a number greater than zero, then highlight the entire row.

There is no specific pattern as to which columns would trigger the requirement.

Also how do you keep the ranges from moving when copying across and down. Sometimes I run into that issue. Maybe highlight the entire row and then enter the conditional format?

View 9 Replies View Related

Excel 2003 :: Formula To Sum Every 6th Row Of E Column?

Feb 4, 2014

The following formula was, several weeks ago, very graciously offered to me from one of Excel Forum's contributors.

=SUMPRODUCT(--(MOD(ROW(E8:E6782),2)=0),E8:E6782)

My request was to find a formula that would add each 6th row starting in row e8 (e8+e14+e20+e26+e32 etc. through e6782) in column "e" when the column was 6782 rows deep from top to bottom. (i am not trying to add every number in column e, just each 6th row, starting at e8 and going through row e6782).

I entered the formula into my spread sheet and, voila, I had a sum that I assumed was accurate for my spread sheet of ticket sales. I began to question the functionality of the formula when I altered the E8:E6782 parameters (which represented the gross ticket sales) to E4:E6778, in an effort to sum up the E4 values e4,e10,e16, e22,e28,etc. . . (which represents the net values after commissions were deducted). The difference in the two sums (e8 values Versus the e4 values) was incorrect and did not represent the appropriate commissions (which should have been 15%).

View 1 Replies View Related

Excel 2003 :: Cannot Unhide Column

Nov 30, 2011

I have an Excel 2003 application where one of the columns (column D) has been hidden by some user.

When I try to unhide nothing happens. I select column C and E followed by a right-click on column E where I choose Unhide -> column D stays hidden.

View 7 Replies View Related

Excel 2003 :: Return Last Value In Column

May 25, 2012

Using Excel 2003,

Column A Column B C1 Column D
10062 01-01-2012 3:00 PM 01-02-2012
10062 01-02-2012 6:00 PM 10055
10062 01-02-2012 9:00 PM 10062
10062 01-03-2012 4:30 PM
10055 01-02-2012 1:45 PM
10055 01-02-2012 3:15 PM
10055 01-04-2012 8:30 PM

I am looking for a formula to place in C2 that will macth the number in column D with the number in column A and return the LAST date/time from column B that matches the day from cell C1.

If correct, C2 would return 01-02-2012 3:15 PM (Last date/time for 10055 on 1-2-2012)
C3 would return 01-02-2012 9:00 PM (Last date/time for 10062 on 1-2-2012)

View 9 Replies View Related

Macro That Duplicates Lines Based On Value Of Column?

Aug 22, 2014

I need a macro that duplicates lines based on the value of a Column. So in Attached excel D1 is 10 - I need it to create 9 entries for that line, so there are 10 total duplicate lines.

I had a Macro that worked that is in the document, I even had everything set up the same, which it is not now, but could not get it to work.

A Macro or a Finished document is fine, Just need this to produce raffle tickets for the church

Raffle Tickets.xls

View 2 Replies View Related

Excel 2003 :: Copying Row To Different Sheet Based On Condition

Feb 16, 2013

I wanted to know if it was possible for me to be able to copy a whole row into a different sheet based on a column value. For example, if B6 = CLOSE, the whole row would be coppied to the sheet name CLOSE. If B6 = OCCUPIED it would be copied to sheet name OCCUPIED. I also need if W7 = to a date thats passed today it would be added to the sheet name EXP PRD. An off topic question, i have this code for column "W":

=COUNTIF(W6:AD155,">"&TODAY()+15)

It works just fine, but I also have "N/A" / "INDEF" in the blocks as well so it's not giving me the correct results. I'm using Excel 2003.

View 8 Replies View Related

Removing Duplicates Based On Column Values And Criteria?

Apr 3, 2013

removing duplicate names. Students were allowed to take a quiz as many times as they wanted. I need to remove the duplicate entry by keeping the highest grade.

Here is the setup of my excel file. Column 1 has surnames, Column 2, has first name, and column 3 has grade.

I can't figure out how to filter them based on first and last name because some students have the same name. with the grade as the criteria

I would need an excel formula not macro

View 9 Replies View Related

Excel 2003 :: Get Sums Based On Codes In Dropdowns By Week?

Jan 24, 2014

I am using Excel 2003.I need two distinct sums:

I need to calculate out the loan amount of approved loans by week (weekending on Sunday). For example for the week ending December 28th, 2013

$1,234,567,890 in total loans

I also need to have a list of sums of the loan amounts per code types of approved loans. For the week ending December 28th, 2013

$123,456.00 in total loans for Code: LTV/TLTV > Guideline max
$987,654.00 in total loans for Code: FICO > 10 pts below Guideline min

I need to ignore any loan amounts and codes for any loans that have not yet had a approved date entered and also ignore all loan amounts for any loans that are denied. I have tried doing this in many different ways with Pivot Tables and I am not getting the results I need.

View 1 Replies View Related

Excel 2003 :: Copying Cells Based On Alternate Cell Value?

Sep 26, 2011

I am wondering if it possible to automate the copying of data from particular cells, based on a value in a different cell, into a different format.

So to go from this simplified table:

AB1NameLevel2Arthur2a3Briony3c4Catherine3b5David3a6Edward2a7Felicity3c8George3c
to something like this:

FGHI12a3c3b3a2ArthurBrionyCatherineDavid3EdwardFelicity

4
George

At the moment I do it all manually, and it takes forever. I am sure there must be a simple way of doing it. I am using Excel 2003, but could work in a newer version if required.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved