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.
More Excel array formula examples. And here are a few more examples of Excel array formulas that might be helpful. 1  Look up with multiple criteria-a powerful INDEX / MATCH function that can look up by values in 2 different columns. 2  Get all duplicate values in the lookup range-how to get all instances of the lookup value.