duplicate values

  1. M

    Find duplicate values in column VBA

    Hi all, I want to create a macro which loops through all the cells from a certain row(which will be filtered alphabetically by me before running the macro - just to ease the work) and if it finds the same values in the cells below, to write their respective values from other rows in a new...
  2. S

    Hide Duplicates but show all columns

    Hi Can anyone please help? I have the following test data (the actual data set is immense): <TABLE cellSpacing=0 bgColor=#ffffff border=1><CAPTION>Test</CAPTION><THEAD><TR><TH borderColor=#000000 bgColor=#c0c0c0>ID</TH><TH borderColor=#000000 bgColor=#c0c0c0>Date</TH><TH borderColor=#000000...
    • Spa
    • Thread
    • duplicate query duplicate values hide duplicates
    • Replies: 3
    • Forum: Microsoft Access
  3. M

    MAcro to add new data and check for duplicates

    Hi all, I am trying to find a macro that will enable data to be enetered to a list. The list will then be sorted smallest to biggest and only unique entries will be allowed to be added. For example: <table style="border-collapse: collapse;" width="274" border="0" cellpadding="0"...

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