The specialty retail chain Annaâs Linens filed for bankrupty protection last month and is set to close all their stores, according to the Ariz. â¦. The specialty retail chain Annaâs Linens filed for bankrupty protection last month and is set to close all their stores, according to the Arizona Republic. . The Costa Mesa, Calif.-based company, founded in 1987, is closing its more than 200 stores in the United States and Puerto Rico.
Let us say you have a list of values in range A1:A5 and you want to reverse the list. In an empty cell write =INDEX($A$1:$A$5,6-ROWS($A$1:A1)) and copy down. Boom, you get the reversed list. In the reversed list, first item is last item in the original list (ie 5th item in our case).
1 Reverse your filter (filter for everything you want to delete). 2  Set every value in the 'TEMP ORDER' column to 1 on the filtered results. 3  Clear your filter. 4  Sort your data by the 'TEMP ORDER' column, smallest to largest. Highlight the 10 rows that you want to keep and change their background color. 2  Clear all filters. 3  Apply a new filter on one of the columns, select Filter by Color. 4  Instead of picking the color that you used, pick no fill.