Hi. So I have two workbooks here. I have attached screenshots of both. One is Pickorder. Column A lists the dispatch times. Column B has route codes. Column D has the dispatch areas. Column E has the dsp taking the route. For example, CX19 dispatches at 6:15:00, at STG.A01 for HIQL. I then have...
Excel 2018 conditional formatting for duplicates is limited to the number of rows at the time the conditional formatting is applied, whether by a formula (such as COUNTIF) or by selection of the highlight duplicates rule. Using a named range in a formula simply reverts to the actual cells within...
I have a list of 20 values in excel. I want to pick four by a certain rule, which I have figured out. Now I want to pick 6 randomly from the remaining 16.
I used 'randbetween' for the whole range of values (since I won't know ahead of time which 4 will be picked by the rules) along with a...
Hey there guys (And Girls),
I have a problem i just can't solve, ok here it is i have 2 sheets within my document that will have a VERY similar list in them. i would really like to see if i am putting in duplicates in either list without having to jump back and forth.
I was personally thinking...
May I please seek your help?
I'm trying to vlookup Balance OED as of 31/07/2018 for each account, sample table below, on a separate sheet. However, multiple lines for each account may have the same Balance EOD and I'd like to look it up only once.
I have tried to use this formula...
Can somebody please lend their knowledge to help me fix a small issue. I have two columns of GPS coordinates values. I need a conditional format to check a couple of thousand numbers to know whether their are any duplicate coordinates. For the values to be duplicates they have to be...
Please see the attached Sample on dropbox link. I have a Master sheet that I want to track the total of events that occur each week for a sports team.
On the Engine sheet this will track the possible events each week and...
I'm using the RANK function with COUNTIF to uniquely rank all values within a range (=RANK(A2,$A$2:$A$11,0)+COUNTIF($A$2:A2,A2)-1).
The removing duplicates is working great for most of my values, but I've currently got two values of exactly 7.5% (I've checked using a =A1=A2 style test)...
I need a formula to identify or select a single occurrence of a duplicate value based upon values in other columns of each row. For instance, in the table below, I would want to select the instance in A4- where none of the other row values were blank. Any advice is appreciated.
I have a spreadsheet with just three columns but after using the Conditional Formatting to highlight duplicate values from column A (Name) there are duplicates present as per the first table below. I need to get to a stage as per the second example whereby the duplicate Names have been...
I'm look for a way to remove duplicate values that are not an exact match. The processes from everywhere I look seem to not work.
Change to new value:
Thanks for any and all help
Apologies for posting another Index/Match thread, but I think I've been through them all now and I'm still struggling. Index/Match is my Achilles Heel so apologies if this is straightforward.
I have a summary tab displaying stats on various sites (each site has its own tab). An example of...
Is there a way to count only when the data repeats a certain number of times in a row? For example, I need a formula to highlight cells only if the duplicate value occurs 30 or more times consecutively.
I have been using either "=COUNTIF(A1:A3,A2)>1" or "=OR(A2=A1,A2=A3)" in conditional...
I am attempting to create a list from the unique data of 2 row. I have tried VLOOKUP, MATCH, and PivotTables and couldn't find what I'm looking for, I am still new to Excel and its various functions.
An example of what I'm trying to accomplish is:
In A1 to A5 we have: a,b,c,d,e and in B1 to...
Does anyone know how to find case sensitive duplicate values (0001678bv5 and 0001678bV5 are NOT duplicates) in Excel? I don't want to delete these values, I only want them highlighted. I found a formula to input in the conditional formatting tool, but I must be missing something...
I am building a spreadsheet to calculate to total value of items that have been assigned a specific code. I want to be able to sum the cells in (for example) column D that have the same code in column A. I'm thinking maybe SUMIF would work but I'm a little stumped.
I am trying to highlight values that only appear twice in a data set, but not ones that appear 3 or more, is there a way to do this, and also change it to highlight ones that only appear 3 times, etc.?
I have 12 tables (specific years( 2006, 2007, 2008..)) and within each year table there are 2 columns containing Part number & VSC. I am trying to gather every part number and its corresponding VSC from each of the tables without any duplicates. Not sure if query or script will work best. Any ideas?