Google sheets sortation of data in case of equality
Budget: $10 – $30 USD
Sorting equal values based on their between them performance
I have this problem where I want to sort in a leader board format the strength of 8 currencies.
But when two currencies have the same strength value then they need to be sorted based on their between them performance.
The same thing like in football leader boards where if two teams have the same points then the team that goes above the other is the one that was the winner in the game between them.
I have tried mixing concatenation, arrays and what have you in order to get a result but my brain fries up.
The 10 tables I want to sort in case of equality are in this https://docs.google.com/spreadsheets/d/1_ObDXARnm8tpszCGFRWzgYQAmV3ynAgGDGTFR8T0ahU/edit?usp=sharing ,
sheet 4, range A199:T206
So their between them performance can be found above them. So for example, table of range S199:T206 looks like this
6 NZD
6 CHF
5 CAD
4 GBP
3 USD
3 JPY
1 AUD
0 EUR
T68:T95 is the range for the between them performance of the currencies
for the aforementioned table.
NZD and CHF are equal. So we need to see their between them performance which is in cell T90 NZDCHFBUY.
There is no CHFNZD format in the financial world. Only NZDCHF.
So, if we have an NZDCHFBUY then the currency on the left gets the weight over the one to the right. Since we have NZDCHFSELL then the currency to the right would get the weight over the currency to the left, placing CHF above NZD and reforming our leaderboard like this:
6 CHF
6 NZD
5 CAD
4 GBP
3 USD
3 JPY
1 AUD
0 EUR
Same for USDJPY. It's a SELL again in cell T95 so we get:
6 CHF
6 NZD
5 CAD
4 GBP
3 JPY
3 USD
1 AUD
0 EUR
I have this problem where I want to sort in a leader board format the strength of 8 currencies.
But when two currencies have the same strength value then they need to be sorted based on their between them performance.
The same thing like in football leader boards where if two teams have the same points then the team that goes above the other is the one that was the winner in the game between them.
I have tried mixing concatenation, arrays and what have you in order to get a result but my brain fries up.
The 10 tables I want to sort in case of equality are in this https://docs.google.com/spreadsheets/d/1_ObDXARnm8tpszCGFRWzgYQAmV3ynAgGDGTFR8T0ahU/edit?usp=sharing ,
sheet 4, range A199:T206
So their between them performance can be found above them. So for example, table of range S199:T206 looks like this
6 NZD
6 CHF
5 CAD
4 GBP
3 USD
3 JPY
1 AUD
0 EUR
T68:T95 is the range for the between them performance of the currencies
for the aforementioned table.
NZD and CHF are equal. So we need to see their between them performance which is in cell T90 NZDCHFBUY.
There is no CHFNZD format in the financial world. Only NZDCHF.
So, if we have an NZDCHFBUY then the currency on the left gets the weight over the one to the right. Since we have NZDCHFSELL then the currency to the right would get the weight over the currency to the left, placing CHF above NZD and reforming our leaderboard like this:
6 CHF
6 NZD
5 CAD
4 GBP
3 USD
3 JPY
1 AUD
0 EUR
Same for USDJPY. It's a SELL again in cell T95 so we get:
6 CHF
6 NZD
5 CAD
4 GBP
3 JPY
3 USD
1 AUD
0 EUR
Related categories:
Visual Basic
Data Processing
Linear Programming
Spreadsheets
Google Spreadsheets