Hello,
I have a working array in sheet 1 that pulls from a list and filters it and sums a value in another column. When a certain value is reached the name pops up in the array column, let me know who reached the goal.
Now what I'd like to do is continue this on sheet 2, by reading the data from sheet 1 and combine them to sheet 2 with the new totals there.
The next thing I'd like to do is to be able to reset that value, so that they start over from that moment they reached the target and got there reward. (Can be based on date).
Is/are this possible?
Here's the formulas I'm have in sheet 1: =IFERROR(INDEX($C$8:$C$28,MATCH(0,COUNTIF($S$9:S9,$C$8:$C$28)+(IF(SUMIF($C$8:$C$28,$C$8:$C$28,$E$8:$E$28)<12,0.5)),0)),"")
btw all columns and rows are the same in both sheets.
Thank you
I have a working array in sheet 1 that pulls from a list and filters it and sums a value in another column. When a certain value is reached the name pops up in the array column, let me know who reached the goal.
Now what I'd like to do is continue this on sheet 2, by reading the data from sheet 1 and combine them to sheet 2 with the new totals there.
The next thing I'd like to do is to be able to reset that value, so that they start over from that moment they reached the target and got there reward. (Can be based on date).
Is/are this possible?
Here's the formulas I'm have in sheet 1: =IFERROR(INDEX($C$8:$C$28,MATCH(0,COUNTIF($S$9:S9,$C$8:$C$28)+(IF(SUMIF($C$8:$C$28,$C$8:$C$28,$E$8:$E$28)<12,0.5)),0)),"")
btw all columns and rows are the same in both sheets.
Thank you