123 reputation
6
bio website github.com/andrewhubbs
location San Francisco, CA
age 26
visits member for 3 years, 1 month
seen May 1 at 19:02

Co-founder of Parklet. I express myself with JavaScript and Ruby. I eat, sleep, breath HR and Operational challenges.


Dec
11
awarded  Popular Question
Jan
30
comment MATCH Function does not work
Ah, you are right about the FILTER mistake. Unfortunately, that was only an error in the question not my actual use. The MAX portion is working correctly and returning the -$5,374.81 value. What I am unclear about is why the MATCH call is failing to match that value (especially since it is pulled directly from the range I am matching against). I understand how the 3rd parameter is supposed to work, but it does not appear to actually work (with any of the possible values).
Jan
30
awarded  Editor
Jan
30
awarded  Scholar
Jan
30
revised MATCH Function does not work
mistake in formula
Jan
30
comment MATCH Function does not work
Thanks for the reminder Jacob.
Jan
30
accepted Split, reorder, concat inline in Google Spreadsheets
Jan
29
asked MATCH Function does not work
Sep
9
awarded  Student
Sep
9
asked Split, reorder, concat inline in Google Spreadsheets
Nov
21
awarded  Autobiographer
Nov
17
awarded  Supporter