I have a two-dimensional table (dates with time slots). I would like to collect all entries that start with a specific text and provide them as a list on another sheet. There may be multiple entries in one column.
MacBook Pro 15″, macOS 12.7
Yes,
wbleek wrote:
Do I understand correctly that I have to copy your formula into each cell to extract the following items?
Yes, in the example I entered the formula in A2, then "filled" it down the column.
Autofill cells in Numbers on Mac - Apple Support
That explanation is from the User Guide, which you can also access via Help > Numbers Help in your menu. If you are new to Numbers, or even if you aren't, having a look at the User Guide can help.
The formula in the screenshot is correct, but Badunit spotted a typo in the version included in the text of the post so you could copy-paste. It should be:
=REGEX.EXTRACT(TEXTJOIN("~",1,Table 1::$B:$G),"(TODO[^~]+)",ROW()−1,1)
SG
Yes,
wbleek wrote:
Do I understand correctly that I have to copy your formula into each cell to extract the following items?
Yes, in the example I entered the formula in A2, then "filled" it down the column.
Autofill cells in Numbers on Mac - Apple Support
That explanation is from the User Guide, which you can also access via Help > Numbers Help in your menu. If you are new to Numbers, or even if you aren't, having a look at the User Guide can help.
The formula in the screenshot is correct, but Badunit spotted a typo in the version included in the text of the post so you could copy-paste. It should be:
=REGEX.EXTRACT(TEXTJOIN("~",1,Table 1::$B:$G),"(TODO[^~]+)",ROW()−1,1)
SG
This will generate a simple list in a different order from your example:
:
=REGEX.EXTRACT(TEXTJOIN("~",1,Table 1::$B:$G),"(TODO[^~]+)",ROW(−1,1)
Use ; instead of , in the formula if your region uses , as the decimal separator.
Looking up the date and time for each item may be possible, but complicated. In general what you are trying to do can be complicated with a spreadsheet. You might consider structuring your table differently.
SG
Can you give a screenshot with specifics of table and list you want as output?
shfit-command-4, drag cross-hairs to select area, release, start new post here and use the mountains-and-moon 'Image insertion' icon to attach the screenshot image from the Desktop.
SG
The text (copy/past-able) version of the formula is missing a ) before the -1.
Sure, here is a picture of the table in question:
an the output should be something like this:
or even better like this:
Thanks very much!
Hi SG,
thanks a lot for your solution. That looks great.
Do I understand correctly that I have to copy your formula into each cell to extract the following items?
Cheers
Wgb
collect items in a table to make a list
