duplicates values

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...

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.

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...

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...

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...

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...

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)...

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...

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...

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...