Useful Google Sheets Queries

Queries for pulling in associated data in different sheets:

Returns “TRUE” or “FALSE” in a new cell if cell being queried is unique for the column it is in. In the example, “F10” is the output column and “F” is the column to query:
=COUNTIF($F:$F,F10)>1

Unify values:
=CONCATENATE(F12,” “,G12)

Extract just domain name:
=regexextract(D:D, “://w*\.*([^/]+)”)

Add values:
=SUM(I13:BE13)

Check if values in a certain cell contains a value. In this case, “.asp” but also good for checking and sorting lists by certain characteristics:
=IF(RegExMatch(D12,”\.asp”),2,0)

Calling a cell or cells in another Spreadsheet:

Calling a cell or sells in same Spreadsheet using a named range or worksheet name:

To add:

  • Query cell ranges where value == 1
  • Import range
  • Query cell values where cell value on origin sheet equals value in new sheet, like domain