I am trying to scan in orders from a set of data called, client_inventory. I am scanning in the orders using a separate spreadsheet.
I am trying to create a slice that I can use in the Valid IF statement so it will eliminate the items already scanned.
Is there a way to create a SELECT statement that can look if the value exists in another table?
Hello @Dan_Oliphant , yes, you can use list expressions for that purpose:
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |