ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Cells with the same contents (https://www.excelbanter.com/excel-programming/444182-cells-same-contents.html)

gcotterl[_2_]

Cells with the same contents
 
My spreadsheet has":

"Section 1": AN1.18513
"Section 2": O1.AC4841

If the contents of the cells in Col O match the contents of the cells
in Col A, I need to keep all of the cells in the "Section 1" and all
of the cells in the "Section 2".

The result would be:

One "section" containing the cells from COL A thru N and
One "section" containing the cells from COL O thru AC.

How can I that?


All times are GMT +1. The time now is 09:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com