edinburgh

  1. D

    Reverse combinations in different columns

    Hi, I appreciate there is probably a simple answer to this but i am stuck. We have a 4 column spreadsheet which has over 20K records in it. Column A & B are text fields and C & D are numeric fields. What we need to do is to ensure the combination in the text fields is reversed and also in the...
  2. S

    remove duplicate rows from 2 tables on the same tab

    Hi All I have an excel document with multiple tabs, the first tab pulls 2 tables from a URL. what I need to do is remove the duplicates from the second table where they appear in the top 24 rows of the first table. the first table is at B18:J78 -(the data changes so the below is an example)...
  3. W

    Consolidating data into one cell without a module as it runs to slow

    my base data with assigned duplicate id <colgroup><col><col><col><col><col></colgroup><tbody> ID AREA CUSTOMER ADDRESS NUMBER 1 Delivery Area: 01 - Glasgow / Edinburgh 1139 - apple zzzz 893582 1 Delivery Area: 01 - Glasgow / Edinburgh 1139 - apple zzzz 895980 1 Delivery Area: 01 -...

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