duplicated

Hello, I'm using this formula below so I don't count duplicates, however, I would like to add to this if possible.... if a number is showing in column B and Column C and a date is showing in column D then count how many times. Is there a way around this? I do need to count the duplicated in...

Hi I want to highlight duplicated rows. Thanks for your help, I know the formula now but I have had hard time to interpret it. Conditional Formatting --> Formula =countif($A$2,$A$200,A2)>1 what exactly this formula is doing? thank you so much

Hi Is there anyway to highlight duplicated row? I can highlight duplicated cells using Conditional formatting but that is not what I want. I want excel to highlight duplicated row only (rows which has identical values/cells). Thank you.

Hi Can I just delete duplicated cells in a column BUT without shifting other cells to the top? I used Data-->remove duplicate but that would remove duplicated cells and move everything up. Thanks

I used the following formula to capture the sums for duplicate PO's where multiple items and various qtys were placed. However, the formula will only place a value on the last instance of the duplicate value. =IF(B3,.B2, SUM($T$2:T2)_SUM($U$1:U1),"") I need to have the full po value display...

Hello, I have this list exported from SP and contains duplicated values. This list will always contain duplicated data every time is refreshed. I need to find a solution to have the list with unique values even if it is refreshed. The remove duplicates and data validation functions is not...

Hi guys. This time need your help to find a way to search for duplicated rows within a certain range, but not just delete them with the "remove duplicates " menu option , but let the operator decide what to do, with an error message, could be a text "THERE IS DUPLICATED VALUES!" in a cell, or...

Hello, I would like a macro that compares 2 sheets and remove duplicated rows from one of them. example: Sheet 1 has 20 rows, sheet 2 has 30 rows and in sheet 2 there are duplicates from sheet 1. I like to delete those rows from sheet 2 that are present in sheet 1. (leaving them only in...

Hi Dears need your help here please i have 3 columns in column A i enter ( In or Out ) in column B and C i enter numbers what i want to do to highlight duplicated value only if thecell A value = IN two conditions ( duplicated and cell A = IN ) attached sheet will help you to understand...

Hi all I am trying to create a Pivot from Source Data that in many cases has the same column labels. When I create the Pivot, a number is added to the duplicated column labels (Boston1, Boston2 etc.) Is there a way to tell the Pivot to group these unique column labels that are duplicated many...

Hello, I recently had stability problems with some code and it crashed Excel mamy times. Now when working in the VB edditor the VBA project tree has duplicated the sheet and workbook objects (although the new objects have no code). I have sheet1, sheet11,sheet111, sheet1111(logooutput) etc...

Hi, I have an Access table with data, the data comes from an Excel sheet, currently I'm simply copying from excel and pasting in Access, however I have noticed a strange behavior, sometimes the pasted data gets duplicated, I can't seem to pin point if there is anything in particular that...

Hi guys I am wondering if there is a possibility to automatically duplicate a specific area within an Excel sheet. In this case when I add a new line above the specific area. This line will contain infos which should be added/used in the duplicated area/layout. The area contains constance and...

Hi, Firstly, the combined knowledge on this website is hugely impressive, hope someone can help with this problem... <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have 3 columns of data. 1 column contains only two variants, I want to search for 1...

Hi everybody I am trying through whole weekend to create autocalculation for following spreadsheet. I want to count all duplicates in spreadsheet. <TABLE style="WIDTH: 330pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=439 border=0><COLGROUP><COL style="WIDTH: 48pt"...