Excel: Difference between revisions
From Federal Burro of Information
Jump to navigationJump to search
No edit summary |
No edit summary |
||
Line 22: | Line 22: | ||
Sum all the entries from B where the entries in A match A2. | Sum all the entries from B where the entries in A match A2. | ||
== regexp == | |||
=REGEXEXTRACT(D11,"^[0-9]+") |
Revision as of 00:51, 1 July 2020
if match substr
my cells have unit in them... some MB , some KB, I want the mall to be a single unit so I can remove the uni and do math on it.
=IF(ISNUMBER(SEARCH("* MB",A1)),"dog","")
resources:
- http://www.techrepublic.com/article/using-excels-find-and-mid-to-extract-a-substring-when-you-dont-know-the-start-point/1033368
- http://www.techrepublic.com/article/save-time-by-using-excels-left-right-and-mid-string-functions/1033367
=LEFT(J3,LEN(J3)-(LEN(J3)-FIND(" ",J3)))
These are great ( google sheets )
=INDEX(D3:D8,MATCH("Product 4",A3:A8,1),1)
Find the index of the A coloumn that matches "Product 4", Give that to "INDEX" , get the cell inthe range "D3:D8", at index pos of the previous match.
=SUMIF('RAW DATA'!A2:A, "A2:A = A2", 'RAW DATA'!B2:B)
Sum all the entries from B where the entries in A match A2.
regexp
=REGEXEXTRACT(D11,"^[0-9]+")