duplicate cell

  1. B

    Duplicate entries

    I have two spreadsheets both with multiple columns. In both of the spreadsheets there is a column that contains a unique URL. I need to run a formula that will only leave ALL the data for the rows that contain the same URL in the URL column of both spreadsheets. Hope that makes sense. For more...
  2. L

    Formula to identify unique values from two columns

    Hello everyone, I am struggling to come up with a formula to find every unique value between two different columns. I would want it to identify a unique number only if it is unique between the two columns i.e if "5417" is in once on column A and once on Column B I am fine with that. That...
  3. N

    Array Help!!

    Need to filter a list of ID's (with multiple entries per ID) which includes end dates for events and a "day count." Ultimately, I need to get the number of ID's (not which IDs, just a count of them) that have exceeded a "day count" (say 220 in a year or 400 in a two year window). Each row is an...
  4. P

    Need to assign value to one transaction per day value condition on multiple text field

    Hello Experts, I am having trouble in calculating a the 'final value' column in the below table. Imagine you have a text column 'sample_card' which has multiple transactions over a month. Now, a particular card is eligible for one txn per day only. Maximum discount VALUE PER TXN is set at 75...
  5. C

    Excel vba find Duplicates and corresponding column value is minimum in family

    I want to write a code which will change the corresponding value to minimum of the duplicates set. Sample Data <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> Name Number Ana 1 Rachel 4 Jack 7 Rachel 5 Ana 2 Jack 8...
  6. A

    Check repetition of text in a single cell in excel & delete them to avoid repetition

    I have thousands of rows like that - These are the keywords <tbody> A1 NEW NIVIA TOP GRIP BASKETBALL SIZE 7 OFFICIAL STREET A++ QUALITY BASKETBALL <tbody> A2 New IXO Collated Screw Gun (Cordless) home use screw gun cordless for everyone <tbody> A3 Set of 3 stainless steel soup pasta salad bowl...
  7. D

    Find duplicate and Change cell & text color WITHOUT Conditional Formatting

    <tbody> 12 19 21 25 29 31 32 33 34 36 37 39 44 50 53 55 66 74 75 77 08 13 16 18 22 23 31 39 45 47 52 59 64 70 71 72 73 74 77 79 . . . . . . . . . . . . . 03 09 10 11 13 18 19 27 35 37 44 50 57...
  8. Manolocs

    Same text basic setup

    Hello I am trying to build a "formula" to show duplicated text between two rows: The list is sorted alphabetically. The column "A" is the only column that matters. Some of the cells have a space in excess so the formula is false, any idea how make the formula dismiss the difference in spaces...
  9. A

    Mimic another cell

    Good day, all In column AI I am doing a vlookup to another sheet. The info that is returned from the vlookup I want to appear in column N but I don't want any formulas in column N (because people may want to past the info in columns B-T down to other rows on the spreadsheet). Is there a way...

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