Advanced Search

Search Terms

Content Type

Page Chapter
Book Shelf

Exact Matches

Tag Searches

Date Options

Updated after

Updated before

Created after

Created before

Search Results

2 total results found

Find Data in Cell

Code and Data Manipulation

This document is in development SEARCH finds "text value" in cell A1. IF result of SEARCH is that the data is found, result returns TRUE. Else, FALSE. =IF(SEARCH("text value",A1,1),TRUE,FALSE)

Count Unique Values in Spreadsheet

Code and Data Manipulation

This document is in development UNIQUE finds the unique values in a spreadsheet row or column. COUNTA counts the results of UNIQUE, result returns a numeric value. =COUNTA(UNIQUE(A1:B100))