03-10-2019 12:17 PM
03-10-2019 01:13 PM
Here are 3 methods how to do that https://trumpexcel.com/filter-bold-font-formatting-in-excel/. Samples are for the bold text, but you case is identical. If Get.Cell first parameter will be 23 instead of 20 https://www.mrexcel.com/forum/excel-questions/20611-info-only-get-cell-arguments.html
11-17-2019 08:21 AM
@C V Horie 1. Select any cell in the spreadsheet, then click the "Home" tab. Click the "Find and Select" button and choose "Find" from the menu that appears.
2. Click "Options," then click the "Format" button.
3. Click the "Font" tab. Click the box next to "Strikethrough" to place a check in it, then click "OK."
4. Click "Find All" and a list of every cell that contains strikethrough text will appear at the bottom of the Find and Replace window.
5. Click on the name of a cell in the list to jump to that cell in the spreadsheet. Click the "Find All" button again to refresh the list if you alter the text in a cell to remove the strikethrough.
11-17-2019 12:23 PM
So GET.CELL does what it says on the tin; it gets the properties form a single cell only. I tried giving it the entire column from the table as the reference but the function only returned a single value so it was no use for the FILTER function.
A hidden helper column in the Table did the trick though.