| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 3 months |
| seen | Apr 7 at 16:37 | |
| stats | profile views | 12 |
|
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 |