ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   FIND ALL (https://www.excelbanter.com/excel-discussion-misc-queries/359443-find-all.html)

gwc

FIND ALL
 
All of the cells in my spreadsheet in col A contain a dash ('-').

After I use DATA/SUBTOTALs, columns and click the outline level 2
symbol (at the left of the spreadsheet), only the totals and the grand
total are displayed.

If I click FIND, enter a dash (-) in the FIND WHAT box and click FIND
ALL, will the number of cells found be just the visible cells
containing a dash (-) or all cells containing a dash (-)?


All times are GMT +1. The time now is 03:39 PM.

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