Highlighting Duplicates Entries Across Specific Sheets
Jan 20, 2012
I have 13 sheets of data in my open workbook. Column D, which includes blank cells at times, across each of these sheets maps the same info. of orders. However, I know there are several duplicates, and I want to clean them out. I am trying to figure out a way to highlight all the duplicates that appear only in column D beginning with sheet 4 and ending with sheet 13. I will leave the duplicates that appear on Sheets 5-13 alone, but I want to have them highlighted, so I can review the ones that appear on sheet 4 first, and then delete them.
View 1 Replies
ADVERTISEMENT
Feb 15, 2013
I found this spreadsheet on here and I have been trying to customize it to what I need. I am trying to have scores from skins match highlighted. I want only the minimum score to be highlighted but if there is another duplicate minimum score I don't want it to highlight anything. I also need to find a way to count the skins won by each player and have it off to the side.
For those not familiar with golf a Skin is a game where you try to get the lowest amount of strokes on a specific hole. Ex- 4 people play the hole one. P1 scores 4, P2 gets a 3, P3 and P4 get 6. The skin would go to P2 who has the lowest score on that hole.
Highlight lowest number in each column not highlighting if there are duplicates starting at L6 down to L11 and for each column till AC. And the same for the group just to the right on attached file.
On row 13 and 14 it tells me who won a skin. I want to tally up the total skins won by each player. so if Joe's names shows up twice on R14 I want it to tell me somewhere in the sheet Joe = 2
View 6 Replies
View Related
Nov 24, 2009
I would like to check column B and if any of these values match values in column J hightlight the cell on the same row as the match on column E green. I don't know much about excel but this would be a tremendous help because i'm looking through quite a bit of data. I've tried using conditional formatting and i can't seem to get that to work for my needs. Let me know if you need anymore information.
View 13 Replies
View Related
Dec 15, 2008
Range from AK1:AK8 to AT1:AT8. These are eight rows, total eighty entries. Can a formula or conditional formitting determine if there are duplicates values in eighty entries . The need is not column-based rather row based.
View 10 Replies
View Related
Apr 17, 2014
I have a spreadsheet with thousands rows of items on. I am trying to identify duplicate entries based on two or three cells within each row. If those two or three cells are duplicated for that particular ID then the duplicate entry (row) should be highlighted for deletion.
Better still it would be great if there was a macro or formula which would delete that duplicate row.
So for example on the spreadsheet I have attached, I would like rows 6 and 9 deleted or highlighted as the criteria for deletion is a duplication of the entry in the 'YEAR' column AND the 'VALUE' column for the REFERENCEs AB-1234 and AB-9876 which are the unique identifiers for each individual case.
This would leave the end result as per the table below on the attached spreadsheet.
View 4 Replies
View Related
Jun 7, 2013
My sheet cotains a variable number of duplicates (2 up to 12 duplicates) that can each have different amounts.
Ex: 9879 = 7
9879 = 0
I would like to be able to highlight all the duplicates for that show only 0 as their value (all the duplicates must have a total value of 0). I've tried nested if functions and conditional formating but to no avail.
I've attached a small file that shows the end result.
Example.xls
View 2 Replies
View Related
Jun 7, 2013
My sheet contains a variable number of duplicates (2 up to 14 duplicates) that can each have different amounts.
Ex: 9879 = 7
9879 = 0
I would like to be able to highlight all the duplicates for that show only 0 as their value (all the duplicates must have a total value of 0). I've tried nested if functions and conditional formating but to no avail.
I've attached a small file that shows the end result. Attachment 241407
View 9 Replies
View Related
Apr 17, 2014
I am trying to set up a workbook for work that will highlight duplicates. I know how to use conditional formatting to do this, however, I would like each duplicate "set" to be a different color in order to better identify. The area that I need to search for duplicates is E3:E27. How can this be accomplished?
View 2 Replies
View Related
Dec 12, 2011
I have conditional formatting set to hilight duplicates, but I a, wonder if there is a way to exclude special characters (in this case specifically dashes).
View 5 Replies
View Related
May 7, 2014
What I need to do is sort certain entries in longer list (column A, it is in .csv format and needs to be in it so coordinates and names and ID, all sorted with commas) and I have another list (column C) which is shorter list of certain IDs. I googled and tried and got some results for the basic structure but the fuction seems to fail. It doesn't matter how I get that third list done, but there is only one criteria: since the list in column A is really long and those entries need to keep the .csv formatting, the function should copy that info what is in the matching cells.
Let me try to put it simple: .csv cells from column A that have matching ID from column C should be copied to column B (or N).
the function I'm working with right now is
=IF(ISERROR(FIND($C:$C; A1))=TRUE;"0";A1)
View 13 Replies
View Related
Feb 11, 2009
this seems like such a simple thing to do but I just cannot suus it out. Basically I want to Highlight a cell depending on another cells value:
ie. I have a value in Cell A1 and a value in Cell B1, in Cell C1 I have an IF statement that dsplays the word 'NO' if the values in A1 & B1 are not equal. In Cell D1 I have the word Fault. I would like to highlight Cell D1 if the Cell C1 displays the word 'NO'
View 3 Replies
View Related
May 16, 2009
I have Column A with 380 cells filled in with numbers (A1-A380) i.e. numbers like..456758, 567848 etc etc
Column B has a subset of those numbers, maybe 80-90 or so (B1-B90).
What I want to do is either highlight the numbers in Column A that also appear in Column B in yellow, OR delete them from Column A altogether
View 8 Replies
View Related
Sep 25, 2013
Any method for colour highlighting a row (specific number of cells) as and when any cell of that row is selected, and return to normal when deselected.
View 4 Replies
View Related
Jun 7, 2013
I'm having issues with conditional formatting. I used the INDIRECT formula to highlight specific rows.
For example, column A has the days of the week. I wanted the whole row highlighted if it was a Saturday. I used:
=INDIRECT("a"&Row())="Sat"
What I want to do now is to highlight specific cells (Columns F and G) if column A has Friday in it. I do not want the whole row highlighted if it contains Friday.
View 4 Replies
View Related
Jun 17, 2013
I have a set template for 3 sheets. I copy/paste data into all three sheets within the template. Some data are repeated twice within the 3 sheets. How can I highlight the duplicate data between these sheets?
View 5 Replies
View Related
Jul 3, 2008
I want to link him on all the spreadsheets, but his cell location is always changing because new doctors are being added every year. Is there anyway to link the specialty column with his name so that whenever his name comes up on the other worksheets, the specialty will be automatically filled in with the correct specialty value? I want to be able to do that with all the doctors.
Also, I want to highlight certain doctors in all the seperate sheets, I have Excel 2007 on my home PC, but on my work PC I have Excel 2002. To do this in Excel 07 I would just conditionally format the workbook to highlight certain names, but I cant seem to find a way to do this in Excel 02.
View 9 Replies
View Related
Dec 2, 2013
I have 7 columns x 3 rows with unique numbers. I wish to determine every combination of the above numbers without repeats.
5
11
17
24
29
35
40
[Code] ........
Column 1 would only use column 1 numbers.
Column 2 would only use column 2 numbers...etc.
Also have the same for 5 rows of unique numbers.
I've been working on this for 10 years and this is the last step to finalizing the WINNING numbers.
Back checking using the 5 row technique I would have spent 10,000,000.00 playing over 8 years with a winners purse of 33,000,000.00
With the 3 row I would have spent close to 200k and won 2.5 mil.
Only problem is that I don't have the 10 to start with, the 200k is a maybe .
I need to be able to generate the combinations to play the numbers.
View 9 Replies
View Related
Dec 3, 2013
I have a workbook with the following sheets i do not want to hide called "Detailed Template", "INTERFACES", "STATUS".
I then have a number of worksheets which have their names as cell addresses i.e. "E4", "E5", "D4", "F4", "G7" and so on.
I would like to hide all worksheets (except the 3 mentioned at the top [which are sheets 1-3]) and any which contain say the value of '4'. This value is defined by a cell in the "INTERFACES" worksheet say 'A1' for example.
I want the macro to be able to automatically do this for which ever value is in 'A1'. So if it were to change to '7' it would hide every sheet that doesn't contain '7' in the name.
View 6 Replies
View Related
Apr 7, 2013
I have a database of over 10,000 entries. I am trying to get the average time for four specific entries (department, test 1, test 2, test 3). I did an averageifs for the tests individually and calculated the average time individually.
The three tests comprise of the department.
Average of test 1 = 40.8
Average of test 2 = 39.9
Average of test 3 = 94.8
Average of dept using the averageifs is 41.3
Average of dept by taking the average of the values above is 58.8
Why is that discrepancy there?
View 6 Replies
View Related
Sep 18, 2013
I have this data set which has customers D.O.B's. This a test data set for the MGM Grand Casino and some customers are under aged below 21 or not even born yet (basically wrong inputs). So ultimately I want to retain the row entries of the customers who were born between (1930 - 1992).
mgm_cleaned TEST Â ABCDEFGHIJKLM43928-Sep-20048-Sep-200405.4722000004-Oct-194944969-Sep-20049-Sep-200408.5720.25000004-Oct-1949459320-Apr-200423-Apr-2004010.9255000004-Oct-1949469420-Apr-200420-Apr-200409.2941000004-Oct-1949479121-Apr-200421-Apr-2004019.637.25000004-Oct-1949489221-Apr-200421-Apr-2004016.2941000004-Oct-1949499323-Apr-200323-Apr-2003010.96-10.25000004-Oct-1949509623
[Code] .........
View 2 Replies
View Related
Jan 31, 2013
I have a table which looks like this:
Name 1 IDNumber Name 2 Name 3 Column 5
Tom20148 John Malmo
Tom20148 Will Malmo
Bob20206 Will Malmo
Tom20206 Will Paris
Bob20206 Rob Rotterdam
Bob20207 John Rotterdam
Ray20207 John Paris
Tom20208 John Malmo
Ray20208 Rob London
Ray20209 Rob Paris
Bob20209 Will Malmo
Is it possible to have excel go through this list and assign each row a number in column 5 based on the names and the IDNumber? Basically, I would want each entry that is identical in name 1, 2 and 3 to be assigned numbers 1, 2, 3, 4, 5 etc based on their IDNumber. So Tom/John/Malmo with the IDNumber 20148 would get the number 1 in column 5, while the next match (Tom/John/Malmo/20208) would get the number 2 in column 5. For each different match of Name 1,2 and 3, I would want the count in column 5 to start at 1. So Bob/Will/Malmo/ 20206 would get number 1, Bob/Will/Malmo/20209 number 2 etc.
View 4 Replies
View Related
Mar 18, 2014
I have a couple of spreadsheets that has several columns each containing several hundred thousand rows of codes. To quickly analyze this data, I am trying to come up with a conditional formatting formula to highlight the respective cells when specific values occur next to each other. A particular code will show up in many cells, but the code that is the respective adjacent cell is always different. I need to know when row A contains, for example, '9928559' and row B contains '36415RT'.
View 3 Replies
View Related
Sep 28, 2009
I found the following code to delete duplicates. I want the code to work on close and only on a specific sheet....
View 3 Replies
View Related
Jul 4, 2013
I have a problem regarding highlighting a specific cell, when i entered a specific date in another cell
Let me explain
If there is a Name, joining date, termination date/resignation date in cell A1 A2 & A3 respectively.
If the name is John, Joining date = 01/01/2012, Resignation Date 06/06/13
I need a formula which highlights the cell A2 plus all those cells which have the same date when i entered a date (i.e 01/01/2012) in another cell.
View 2 Replies
View Related
Jan 13, 2014
How to perform this function on Google Spreadsheets (which appears to be slightly different to Excel);
Calculate the sum of the numbers in column D that occur on the 10th January 2014?
And also, Calculate the sum of the numbers in column D that occur between 9am and 10am on the 10th January 2014.
View 1 Replies
View Related
Jan 6, 2010
I use online banking for paying my monthly bills. I get different confirmartion for each pay transection. Pls look attached Excel file. Now I want to find specific bills expense with amount from all my 12 months bank statements. How can I get this task done.
Note: Each time get different confirmation which appears on my bank statement beside paid bill name. for example January 2009 statement GAS Z8A.... Feb 2009 GAS S2W. I hope this clarify. What I have to do if I want to get all my 12 months GAS money withdraw from bank statement. I use csv file for bank statement.
View 11 Replies
View Related
Apr 20, 2013
I need a code to delete all duplicates (all cells) in the range A1: F100?
Exemple:
Before
31
81
43
[Code]....
View 5 Replies
View Related
Feb 10, 2012
I have 2 sheets, List 1 and List 2 Both lists contain generic part numbers in column A, so because there could be 2 manfacturers of the same part there will be duplication of the generic part number.
What I want is to prevent someone entering a generic part number in list 1, which already exists on list 2.
I there any cde which can be put in the sheet which will show an error message for this?
View 9 Replies
View Related
Aug 19, 2008
Need to move data from 14 sheets (1 pay period=14 days)(2 showing on attachment for example purposes) to time cards for each person (number of employees will vary).
Key data to move to the time card is the date of the hours, #Reg Hours, #OT hours, the ticket# and job# for those hours.(ie Chris Adams Aug 15, need Chris's Reg and OT hours (8 Reg and 2 OT) on his time sheet, and the corresponding ticket number and job number (in this case from I1, I2).
Unknown number of ticket/job numbers, but the pattern of cell entries will remain the same along the top of the date sheets.(starting at I1, then L1, O1, the next would be R1)
Unknown number of employees but they will continue filling down where the names are on the date sheets (column A). Each employee would have a time card sheet as well.
View 5 Replies
View Related
Jun 26, 2014
Is there a way to differentiate the number of unique and duplicate entries (considering multiple criterias) using a formula.
I am finding it hard to describe the request hence i have attached a spreadsheet for reference.
The first tab contains the data where I want the result in 'column J'
The second tab contains the metrics of how to calculate the result.
I am sure this will be difficult to understand at first hence feel free to ask as many questions you would like to [only related to the subject ]
For the record, I use Excel 2007 & 2010.
View 3 Replies
View Related