Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
Note that in the second ﬁ gure the episodes are sorted by how early in the
description the pivot table is mentioned. If I wanted them to be sorted in episode
sequence, I could have used =NOT(ISERROR(FIND("pivot",LOWER(D2)))).
Also note that instead of hard-coding "pivot" in the function, I refer to cell $G$1
instead. This way, I can enter subtotal in G1 and re-sort by column E to ﬁ nd
items that contain the word subtotal.
Note that people frequently ask me why I go to all this trouble when I could use
a custom AutoFilter of *pivot* as shown here. Well…I guess it is because old
habits are hard to break. Based on the ﬁ rst paragraph, I really should be using
SEARCH instead of FIND.
FINDB(ﬁ nd_text,within_text,start_num) [Category: Text]
FINDB ﬁ nds one text string (ﬁ nd_text) within another text string (within_text), and
returns the number of the starting position of ﬁ nd_text, based on the number of