33 reputation
17
bio website
location
age
visits member for 1 year, 5 months
seen Jul 24 '13 at 17:21

Nov
5
awarded  Notable Question
Jul
22
awarded  Popular Question
Mar
26
awarded  Tumbleweed
Mar
19
asked Copy one Google Spreadsheet to another
Mar
2
awarded  Scholar
Mar
2
comment Google Spreadsheets Filter() - referencing source array in criteria
Thanks, you've done a lot of work, i will have to look into everything that you've done to understand it
Mar
2
accepted Google Spreadsheets Filter() - referencing source array in criteria
Mar
1
comment Google Spreadsheets Filter() - referencing source array in criteria
BTW, i have 21 hours to award the bounty on an answer (and there is no answer yet). If you will post your script solution as answer, i could award the bounty on it. Not sure what happens after 21 hours... i guess i will just lose the rep, so i'd rather give it to you for the effort
Mar
1
comment Google Spreadsheets Filter() - referencing source array in criteria
Col J uses value of G, for example "CPU". It then applies modifications to this, based on table M3:S19. In that table, there are entries for "CPU" and "% CPU". Both need to be applied to value of G (and they are slightly different). The search for %-sign is in the M3:S19 table, not in G column
Feb
26
awarded  Analytical
Feb
26
awarded  Student
Feb
25
comment Google Spreadsheets Filter() - referencing source array in criteria
No, this is a copy of the original that i placed elsewhere randomly (yes... i know... ). Please ignore the Weapons sheet. It is not required for the formula in cell L18. As for Google Apps Script, i am really not familiar with that, but if you can use that to answer my OP, i will take it.
Feb
25
revised Google Spreadsheets Filter() - referencing source array in criteria
added 35 characters in body
Feb
25
comment Google Spreadsheets Filter() - referencing source array in criteria
Sorry, i only saw the comments from some people looking into this right now. I've reverted the spreadsheet and saved it under a different link (read OP). Thank you
Feb
25
revised Google Spreadsheets Filter() - referencing source array in criteria
added 631 characters in body
Feb
22
awarded  Promoter
Feb
18
awarded  Editor
Feb
18
comment Google Spreadsheets Filter() - referencing source array in criteria
Added link to OP
Feb
18
revised Google Spreadsheets Filter() - referencing source array in criteria
added 220 characters in body
Feb
17
asked Google Spreadsheets Filter() - referencing source array in criteria