duplicates values

  1. most

    Color code duplicates with a twist

    I know color code duplicates is a very common issue here on the internet, but I can't find any solution which is similar to my needs. Based on the value in column A("My data") I want to color code the whole row where the value is the same. I.e. row 1 and 2 has the same value and should be...
  2. Leebc

    Find a list rows with duplicate ID

    Hi, I'm new to Power BI and DAX. I'm trying to find and list all rows in the table which have the same ID (Field/column). What would be the easiest or least complex way to search through the data in a filed and to extract or list all the rows with the same or duplicate ID Cheers.
  3. D

    How to sum set of contiguous appearance values among set of multiple valued duplicates in excel?

    Dear All! I thought it will be easy to sum up multiple distinct values among duplicates but when I started to do that I stucked finally. My need is far beyond that is why I need your assistance, please. The scenario: If a text value is duplicated in a specific range of column A (e.g.), I need to...
  4. J

    Sum IF Duplicate Value in New Column Without Consolidation

    I am struggling with a datasheet that has the results of every email campaign I have run. It Contains columns: <tbody> EMAIL NAME COMPANY OPENS TITLE LIST Email List </tbody> Email addresses appear on the sheet based on their presence on the email results, so many email addresses appear...
  5. G

    Ranking without Duplicates

    I have found within this website/forum the formula of RANK and COUNTIF... for some reason, it keeps returning problems. See below - any help greatly appreciated: (starts at E26) <colgroup><col><col><col></colgroup><tbody> RANKINGS - COL E F G Team 1 14.00 6.00 Team 2 14.80...
  6. W

    VBA With / End With problem for Highlighting Duplicates

    Dear all, I have manipulated a code provided by another form user to highlight duplicate values in multiple sheets in a workbook. I have a Master sheet that contains all emails in column A, and I want to check 5 separate worksheets against this Master for duplicates. All the data for...
  7. C

    purchased vs invoiced days duplicates values

    Dear All, I need you help me in order to find a correct formula who can return date between “Scan Date” and “Invoice date” from the attached file ? Issue – I want to know how many days has past from Scan Date till invoice date (you can see that I have a lot of duplicates p/n in the file)...
  8. D

    Determing latest revision in a list, with certain criteria

    Hi there, i am trying to use formulae to achieve the results below. Anyone have any suggestions as to how I would go about achieving the Output from the Input data? I have tried using If statements and it works... except for the duplicates and the fact that there are about 40000 lines items...
  9. E

    Maybe if I use the frequency function?

    I have a data table that registers daily sales and there are several sales per day. I need to create an array function that groups sales into single days. </SPAN></SPAN> E.g.</SPAN></SPAN> Date Product Sales</SPAN></SPAN> 1/1/13 X...
  10. M

    How to extract duplicate records from 4 spreadsheets into a separate spreedsheet?

    Hi Fellows, I have 3-4 excel spreadsheets with same sort of data. Each spreadsheet has 1000+ records, and each record has data ranging from column A to Z. Some records are duplicate within these 4 spreadsheets. Now, I want to extract the duplicates into new spreadsheet like; every record has...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top