| |
Data functions
Page history last edited by Anonymous 3 yrs ago
- VLOOKUP(), MATCH()
- Text functions
- Sum, Avg, Count, etc. on lower right toolbar
- Error checking, e.g. ISERROR(), ISBLANK(), ISNA()
- Measuring your data: COUNT(), COUNTA(), COUNTIF(), SUBTOTAL()
- Working with dates
- Delimited files
- Find/Replace, using wildcards
- Sorting
- Recorded macros
- Function for filling our raw data: =if(isblank(a2),b1,a2)
Data functions
|
|
Tip: To turn text into a link, highlight the text, then click on a page or file from the list above.
|
|
|
Comments (0)
You don't have permission to comment on this page.