Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sorting data in order
Hi, I have the following formula to sort my data in acsending order. =INDEX($A$1:$A$6,MATCH(SMALL(IF($A$1:$A$6="","",CO UNTIF($A$1:$A$6,"<"&$A$1:$ A$6)),ROW(A1)),IF($A$1:$A$6="","",COUNTIF($A$1:$A$ 6,"<"&$A$1:$A$6)),0)) I am after two variations of this. One to sort in descending order and another to sort in acsending order if the cell next to it (column b) contains "Yes" Please can you help, Help always appreciated, -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=384805 |
#2
|
|||
|
|||
"ceemo" ha scritto nel messaggio ... Hi, I have the following formula to sort my data in acsending order. =INDEX($A$1:$A$6,MATCH(SMALL(IF($A$1:$A$6="","",CO UNTIF($A$1:$A$6,"<"&$A$1:$ A$6)),ROW(A1)),IF($A$1:$A$6="","",COUNTIF($A$1:$A$ 6,"<"&$A$1:$A$6)),0)) I am after two variations of this. One to sort in descending order and another to sort in acsending order if the cell next to it (column b) contains "Yes" hy, try to substitute COUNTIF($A$1:$A$6,"<"&$... to: COUNTIF($A$1:$A$6,"IF(B1="yes","<","")&$... ivano |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data from one sheet to several in sequential order! | New Users to Excel | |||
sorting data by date | Excel Worksheet Functions | |||
sorting number in ascending order | Excel Discussion (Misc queries) | |||
how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) | |||
pivot table in data source order | Excel Discussion (Misc queries) |