Annabel No problems at all, good app. Way cheaper than other music options out there. You can either choose to have a free account or pay under Â£10 a month to be able to download unlimited songs unlike other apps where you would have to pay a certain price (close to a pound) for each song you want.
Excel 2007 and later. 1  Click on cell A1 and then choose Filter on the Data tab of Excel's ribbon. 2  Click the Filter arrow in cell C1, choose Number Filters, and then Greater Than. 3  Enter 1, and then click OK to filter the list to for duplicate values.
Fill the formula down from B1 through B5. This will return the values 2, 3, 1, 4, 5 to cells B1:B5. Examine the formulas in cells B2 and B4, the cells that are adjacent to the duplicated value 22. In B2, the RANK returns 3 (as it should), and the COUNTIF function is COUNTIF($A$1:A2,A2) which returns 1.