Hello,
I'm trying to figure out how to search all cells for the word abc (case sensitive) and add the number that precedes it.
I'm completely new to excel (coming from bash/perl) and have figured out left right word extraction, however i can't figure out how to do an if-then and sum
Here's what i'm using for left/right extraction:
=RIGHT(E2,FIND(" ",E2))
=LEFT(E2,FIND(" ",E2)-1)
Attached is a sample sample.xlsx
Thanks!
Bookmarks