Difference between revisions of "Talk:Accelerator Seed List (Data)"
Jump to navigation
Jump to search
| Line 12: | Line 12: | ||
\n\1\2\n\1 | \n\1\2\n\1 | ||
| + | |||
| + | =if(isnumber(search("blah",B2))=TRUE,1,0) | ||
| + | where blah is the substring (what you're searching for), B2 is the string (what your searching in) and 1 represents that it's present and 0 means it isn't. | ||
| + | |||
| + | =sum(A1:C1) | ||
| + | This just sums the cells from A1 to C1 | ||
Revision as of 15:44, 17 April 2017
Rank on VC
- Getting a VC percentage for each Accelerator
Also categorize
- Age
- Nonprofit or not
- Location
RegEx Code for repeating data down for the round data from SDC:
\n([^\t]+\t[^\t]*\t[^\t]*\t[^\t]*\t[^\t]*\t[^\t]*\t[^\t]*\t[^\t]*\t[^\t]*\t[^\t]*\t)(.*)\n\t\t\t\t\t\t\t\t\t\t
\n\1\2\n\1
=if(isnumber(search("blah",B2))=TRUE,1,0) where blah is the substring (what you're searching for), B2 is the string (what your searching in) and 1 represents that it's present and 0 means it isn't.
=sum(A1:C1) This just sums the cells from A1 to C1
