Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Accending order
Hi, Formula =IF(COUNTIF(O$7:O8,O8)=1,MAX(N$7:N7)+1,"") is counting the row index. This formula is making a list of unique items which I am further using in a data validation list. =IF(MAX(NCOUNT)<ROW(1:1),"",VLOOKUP(ROW(1:1),NLIST ,2)) The list is like 550 551 552 553 554 C-09 C-10 555 556 557 C-11 I want to have this validation list in accending order like C-09 C-10 C-11 550 551 552 553 554 555 556 557 Thx. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How stop Excel file UK date order changing to US order in m.merge | Excel Discussion (Misc queries) | |||
Series order conflicts with line order | Charts and Charting in Excel | |||
purchase order counter in excel purchase order template | Excel Worksheet Functions | |||
I want a purchase order that includes page number (if to be order. | New Users to Excel | |||
Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions |