duplicated

  1. X

    =count(if(frequency

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

    duplicated rows formula

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

    highlight duplicated rows

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

    duplicated cells in a column

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

    Populating a cell with a BLANK value with another Non-BLANK value.

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

    Export to excel show unique values

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

    Find duplicated row values and show a message in order to take action.

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

    Remove duplicated rows from different sheets

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

    conditional formatting duplicate values two conditions

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

    Duplicate Pivot Table Columns

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

    Extra objects in the VBA project explorer.

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

    Copy/paste results in duplicates

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

    Copying a specific area in Excel when adding a new line above that area

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

    Lookup repeated data and display associated cells

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

    Sum duplicated values and quantity

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

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