Deleting cells with same data as other cell
Closed
Blakey
-
Mar 4, 2010 at 05:49 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 4, 2010 at 07:38 AM
rizvisa1 Posts 4478 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
- Tmobile data check - Guide
- Conditional formatting if cell contains text - Excel Forum
- Count if cell contains number - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- Based on the values in cells b77 ✓ - Excel Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
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