Filter. Google Sheets function

Interesting seeing Google Sheets doing things differently than Excel. This function will fill in cells as values once the user presses Enter. Technically a feature rather than a function.

Once you do first cell, google sheets will fill the rest down with values, not formulas.

Find items in Sheet ‘Input’ range A4:A202 where not found in Input!B4:B202

Find items in Input!B4:B202 that were not found in Input!A4:A202

Post image was created using Bing AI

Author: ANmar