New answers tagged


I don't know if you can create a named range, but you might be able to treat the data like a named range using filter and regexmatch functions together. So given your data A B 1 ABC 536936062976506 2 XYZ 891048446616931 3 ABC 250538612742584 4 XYZ 730573819217927 Something like this =slope(filter(B1:B4,REGEXMATCH(A1:A4,"...

Top 50 recent answers are included