Deleting cells with same data as other cell
Closed
Blakey
-
Mar 4, 2010 at 05:49 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 4, 2010 at 07:38 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 4, 2010 at 07:38 AM
Related:
- Deleting cells with same data as other cell
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Transfer data from one excel worksheet to another automatically - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Count if cell contains number - Excel Forum
- Highlight cell if another cell contains text ✓ - Excel Forum
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Mar 4, 2010 at 07:38 AM
Mar 4, 2010 at 07:38 AM
You can use MATCH function to find dup for situation number 1
When you say you want to delete the dups from list 1, I presume you are talking about the cell deletion and now row, so the question would be how should cells arrange, move up, move right etc
When you say you want to delete the dups from list 1, I presume you are talking about the cell deletion and now row, so the question would be how should cells arrange, move up, move right etc