b-e

  1. G

    How do I compare data for duplicated and missing entries

    Hi I have a workbook that has data in columns A-E. Depending on what data it is in column "A" is has the word "ABC" or "TAB" and then columns B-E all the specific data. What im trying to do is if poss via a macro look all the way down the workbook for entries in "ABC" and "TAB". The...
  2. G

    Can I run 2 formulas on same workbook?

    Hi I have a workbook thats got this formula in column F. =IF([@Source]="","",IF(ISNA(MATCH([@ID]&"|"&[@Field2]&"|"&[@Date]&"|"&[@Value],INDEX($J$2:$J$7000&"|"&$K$2:$K$7000&"|"&$L$2:$L$7000&"|"&$M$2:$M$7000,0),0)),"Missing","")) Im trying to repeat the formula in column "O" so it looks in...
  3. G

    How do I highlight duplicated data

    Hi I have a sheet that im trying to highlight duplicated entries. What I need to do is look down the whole sheet and if in columns B-E have duplicated entries across the row I need one of them deleting and the other remaining in the sheet. What I mean by duplicated entries across the row...
  4. G

    Need help on how to highlight duplicated entries and missing data.

    Hi I have a workbook that that has data in rows B-E and I-L . What im trying to do is to highlight duplicated entries and missing data. What I need to do is for it to look down columns B-E and then look down columns I-L and if any data missing I need the row in columns B-E highlighted...
  5. G

    Restrict editing of some cells on a document

    I have a spreadsheet I need customers to amend. I need them to be able to: Insert rows Not amend any cells contents in Column A Be able to edit the cell contents of Columns B-E I've tried playing around with protecting the sheet, and marking certain ranges as Locked, but I can't get it to...

Watch MrExcel Video

This Week's Hot Topics

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
Top