Forum Discussion
Printing in Excel
Can someone please tell me how to print only the numbers to the right of the checkbox below?
5 Replies
Which numbers do you wish to return?
The ranges could be returned using
= TRIM(MID(Book, FIND(" ", Book, 4), 10)) = FILTER(TRIM(MID(Book, FIND(" ", Book, 4), 10)), link)The second version filters the returned ranges to return only chapters that have the corresponding check box set. FILTER is specific to Excel 365.
I am not familiar with Excel protocols. Can you walk me through this? Sorry for the late response.
- I am not sure where you are going with this, so I offered a couple of formulas that could be useful. I concentrated on a single column of your table (A3 and down some rows) and applied a defined Name 'book' (the data appears to be books of the Christian Old Testament) to reference the data. The first formula should return the number ranges to the right of each book name.
The second formula assumes the check boxes have linked cells, which I gave the name 'link', and I used that to filter the result according to the setting of the corresponding check box.
From the picture I can't see whether the checkboxes are activex controls or not.
A file (without sensitive data) would be more suitable here to detect the error.
But maybe it works with simple means 🙂
Select a range and press Right Align
Select area and change column width.
Maybe it helps, wish you a happy xmas
