Spreadsheet: 677825d1589545612-sorting-data-question_file
Sheet: Sheet1

Translator | 1st language | Paid for 1st language | 2nd language | Paid for 2nd language | 3rd language | Paid for 3rd language | 4th language | Paid for 4th language | 5th language | Paid for 5th language | 6th language | Paid for 6th language | 7th language | Paid for 7th language |  | LANGUAGES: | Polish | Russian | German | English | Italian | French | Dutch
AAA | value: header of the column where the first encountered cell value is greater than 0, example in this case: Polish | value in the first encountered cell with cell value grater than 0, example in this case: 120 | value: header of the column where the next encountered cell value is greater than 0, example in this case: English. Return empty cell if there's no more cells meeting condition | value in the next encountered cell with cell value grater than 0, example in this case: 252. Return empty cell if there's no more cells meeting condition | The same condition as for the 2nd language, but looking for the 3rd language data if present | The same condition as for the 2nd language, but looking for the 3rd language data if present | The same condition as for the 2nd language, but looking for the 3rd language data if present | The same condition as for the 2nd language, but looking for the 3rd language data if present | The same condition as for the 2nd language, but looking for the 3rd language data if present | The same condition as for the 2nd language, but looking for the 3rd language data if present | The same condition as for the 2nd language, but looking for the 3rd language data if present | The same condition as for the 2nd language, but looking for the 3rd language data if present | The same condition as for the 2nd language, but looking for the 3rd language data if present | The same condition as for the 2nd language, but looking for the 3rd language data if present |  |  | 120 |  |  | 252
BBB | Repeat the same calculations from the row above that will show results for this translator | Repeat the same calculations from the row above that will show results for this translator | Repeat the same calculations from the row above that will show results for this translator | Repeat the same calculations from the row above that will show results for this translator | Repeat the same calculations from the row above that will show results for this translator | Repeat the same calculations from the row above that will show results for this translator | Repeat the same calculations from the row above that will show results for this translator | Repeat the same calculations from the row above that will show results for this translator | Repeat the same calculations from the row above that will show results for this translator | Repeat the same calculations from the row above that will show results for this translator | Repeat the same calculations from the row above that will show results for this translator | Repeat the same calculations from the row above that will show results for this translator | Repeat the same calculations from the row above that will show results for this translator | Repeat the same calculations from the row above that will show results for this translator |  |  |  | 25
CCC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 125 | 223
DDD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 452 | 215 | 562 |  | 2548 | 20
EEE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 258
FFF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 147 |  |  | 874
GGG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 215 | 854 | 875 | 995 | 25 | 47 | 63
HHH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 628
III |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 475 |  | 412