![]() ![]() if the particular cell is text then calculate non empty cell otherwise nothing which is '' sign. ![]() Istext returns true or false if the cell is text. ![]() An array is just a list or range of values, but an Array Formula is a special type of formula that must be entered by pressing Ctrl+ Shift+ Enter. So first cell stays abslute and others relative and when you drag down the range will enlarge automatically. The result may fit in a single cell or it may be an array.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |