u/madbomb122

https://preview.redd.it/ian3c8agprjh1.png?width=328&format=png&auto=webp&s=fd80bb8a1334f059be74532eb68caebf9bca4984

https://preview.redd.it/3a3sqoylnrjh1.png?width=321&format=png&auto=webp&s=47e4a9644c500fc8d394ae0650d5d7d41cb97440

Compare the 2 tables in Image 1 and return data so its like Image 2

What I looking to do is for it to compare A+B to C+D

First remove all Names that match

Second compares all IDs that match (excluding ones without IDs)

Finally do the same with C+D

Im currently using "Sort(FILTER(A2:B,ISNA(MATCH(B2:B,D2:D,0))))" for A+B to remove the names in both, just Cant seem to figure out how to do the same with the IDs and have it ignore the blanks

im Fine with having to do this over multiple columns to do this if needed

link to sheet, it's the (Filter Data) Sheet

https://docs.google.com/spreadsheets/d/1_OWO7HrK9vwbfp8QRY_s8R59ABKdlYr_hCH2Q-PNLQo/edit?usp=sharing

I'm trying to automate extracting url from hyperlink to get just the ID (the number at the end)

I found this script (below) and it was the only thing that worked for me for extracting the url from the hyperlink..
however what i would like for it is to convert the url like

https://test.pro/players/313342
to
313342

i would like the https://test.pro/players/ to be removed so it has just the numbers at the end.
the length of the numbers isnt the same but the stuff preceding it is always the same

Thanks

>function GETLINKS(rangeA1) {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  const range = sheet.getRange(rangeA1);
  const values = range.getRichTextValues();
  const output = [];
  for (let row of values) {
for (let cell of row) {
output.push([cell.getLinkUrl()]);
}
  }
  return output;
}

Update: Link to sheet
https://docs.google.com/spreadsheets/d/1_OWO7HrK9vwbfp8QRY_s8R59ABKdlYr_hCH2Q-PNLQo/edit?usp=sharing

I have a query that searches multiple sheets for matches based on your input. The problem is i keep adding more sheets which means i have to update the query when i add one

Would it be possible to use a column on a sheet that lists all the sheets for the Query to look at?

My query formula
=Unique(Query({'2/13/26'!A2:A;'1/26/26'!A2:A;'12/30/25'!A2:A;'12/17/25'!A2:A;'10/27/25'!A2:A;'9/29/25'!A2:A},"Select Col1 where LOWER(Col1) CONTAINS '"&LOWER(A2)&"' Order By Col1"))
I have a Column with all those Dates in a Sheet called "Dates" where "Dates!A2:A" is the list of the Sheets to be searched

Note: If needed ill create an example sheet