Hi all,
I have a sheet that lists revenues by country, as such:
The data in the "Revenue" column is calculated via the following formula:
I want to sort the data in descending order by Revenue. I run the Sort function and select Sort by Revenue - Descending. This sorts the Country column, but does not sort the Revenue column, as follows:
If I eliminate the formula by copying the Revenue column and then pasting the results via Paste Special - Values Only, then the data sorts correctly. I don't want to have to do this, though.
What could be the cause of this? It is driving me crazy!
I have a sheet that lists revenues by country, as such:
| M7 GMD EMIS Reports.xls | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | Country | Revenue | ||||
| 2 | ABUDHABI | $0 | ||||
| 3 | ARGENTINA | $190,825 | ||||
| 4 | AUSTRALIA | $436,781 | ||||
| 5 | BAHAMAS | $0 | ||||
| 6 | BAHRAIN | $862 | ||||
| 7 | BANGLADESH | $4,487 | ||||
| 8 | BARBADOS | $0 | ||||
| 9 | BOSNIA-HERZEGOVINA | $0 | ||||
| 10 | BRAZIL | $1,696,189 | ||||
Country-Region (2) | ||||||
The data in the "Revenue" column is calculated via the following formula:
Code:
=SUMIF('Sold Cases'!$D:$D,'Country-Region (2)'!$A2,'Sold Cases'!$N:$N)I want to sort the data in descending order by Revenue. I run the Sort function and select Sort by Revenue - Descending. This sorts the Country column, but does not sort the Revenue column, as follows:
| M7 GMD EMIS Reports.xls | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | Country | Revenue | ||||
| 2 | BRAZIL | $0 | ||||
| 3 | AUSTRALIA | $190,825 | ||||
| 4 | ARGENTINA | $436,781 | ||||
| 5 | BANGLADESH | $0 | ||||
| 6 | BAHRAIN | $862 | ||||
| 7 | ABUDHABI | $1,696,189 | ||||
| 8 | BAHAMAS | $4,487 | ||||
| 9 | BARBADOS | $0 | ||||
| 10 | BOSNIA-HERZEGOVINA | $0 | ||||
Country-Region (2) | ||||||
If I eliminate the formula by copying the Revenue column and then pasting the results via Paste Special - Values Only, then the data sorts correctly. I don't want to have to do this, though.
What could be the cause of this? It is driving me crazy!
