extract exact data

20 views

Skip to first unread message

unread,

Oct 13, 2025, 2:39:10 PM10/13/25

to Google Sheets Community

Trying to extract just the ones entitled Romans.
There are 63 listed all together in this sheet.

ROMANS.png

unread,

Apr 16, 2026, 12:22:34 AM (11 days ago) Apr 16

to Google Sheets Community

=FILTER(A:B, REGEXMATCH(B:B, "Romans"))

=QUERY(A:B, "SELECT A, B WHERE B CONTAINS 'Romans'", 0)

=ROWS(FILTER(A:B, REGEXMATCH(B:B, "Romans")))

Swarup

unread,

Apr 16, 2026, 2:32:25 AM (11 days ago) Apr 16

to Google Sheets Community

Solved

Reply all

Reply to author

Forward

0 new messages