Try this formula:
There are several reasons why your formula was not successful:
- "special" characters vs "normal" characters: often when formula are copied from the web, they can include characters that are not conventional keyboard characters; they might look okay, but the software can't interpret them.
" is the conventional board character for double quotation marks; whereas
” is a special character: Right Double Quotation Mark.
' is a conventional keyboard character for a Single Quotation mark; whereas
’ is a special characters: Right Single Quotation Mark
Query Data Range
IMPORTHTML("https://fbref.com/en/share/SxTNE"”: the range ends in two quotations marks (one is a special character). The range should end in one normal Double Quotation mark.
query range should be surrounded by curly braces to create an array.
Select where Col3=’Crdy'”
CrdY is the header for Col3, so
"select * where Col3 = 'CrdY'" won't return any results (other than the headers) because there are no values in Col3 with a value of "CrdY"
This data is returned using this formula:
There are several reasons why your formula was not working.