google sheets - Query with multiple data types - Stack Overflow

admin2025-04-18  2

I need to find a query that filters through a table with multiple data types.
Problem is that i cant find a way for the query to ignore anything that isnt a number.
I also cant limit what data gets input into the table.

The table in question looks like this:

Name (COL B) Data (COL F)
Max Mustermann 15
Jon Smith A
James Brown 1
Robert Miller 5
Linda Williams
转载请注明原文地址:http://anycun.com/QandA/1744959952a90055.html

CopyRight © 2025 All Rights Reserved
Processed: 0.037, SQL: 9