ascending order

I'm wondering how to use the sort and filter function in Google sheets to sort in ascending order the following: 1-2 months 2-3 months 3-4 months ...up to 11-12 months Right now when I sort 1-2months comes first, followed by 11-12 months. Is there a simple way to sort these fields according...

Hi, I use this macro (see below) to sort the data in ascending order in the table. My macro is assigned to the cutom MSO button. I'd like to transfer my macro to the state which sorts the data in ascending order on the first click, sorts the data in descending order on the second click and...

I need a VBA in column F that grabs dates from every third column starting from I, L, O, and so on. Columns I, L, O, etc has dates (all last day of the month) in ascending order. For example below, column F will start with the oldest date, 2/28/17, all the way to most current date, 4/30/18...

Morning Friends I am after some help with what I think is a complex formula. I have two spreadsheets. One the first is a summary of the information contained on the second sheet and I am trying to create a formula that will lift reference data from the second sheet and put it into ascending...

Hi, I'm using version 2013 and find that the Aggregate function makes the extraction somewhat easier. One small issue I've overcome by that I set up a separate table to reference the values from the source sheet to help my formula because I have 4 ranges to reference and they're not...

I am trying to rank (with a formula, no filters) some values using the values in another column as filters while excluding zeros from the ranking. <tbody> Value Filter Formula 1.3 1 {=RANK.AVG(A2,IF($B$2:$B$8=1,$B$2:$B$8),1)} 2.1 1 2.3 0 2.0 0 3.1 0 2.5 0 0.0 1 </tbody> I...

Just a quick question. I am working a lot with the Ascend order function, and was wondering if there is a way to guaranttee that the cell references don't get mixed up. I am working on two different lists with mostly the same data, but the second list has a few entries omitted. In the process...

Hello, I'm trying to rank in ascending order the top 20 lowest margin generating items by week. I'm stumped on what sort of formula to use for this. I will have a data tab consisting of historical data from previous weeks. I would like to be able to call out the top 20 margin loss drivers by...