Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
real time sorting
Hi, I have a table with real time statistics on. I would like to be able to sort them in real time. How can I do that? Please help. Thank you. -- owl527 ------------------------------------------------------------------------ owl527's Profile: http://www.excelforum.com/member.php...o&userid=20916 View this thread: http://www.excelforum.com/showthread...hreadid=546423 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
real time sorting
Three ways
1. manually re-sort the data when it changes 2. re-sort when a worksheet change (or calculate) event occurs 3. effectively re-sort: suppose cells A1 thru A10 are being dynamically updated. Then in B1 thru B10 enter: =SMALL($A$1:$A$10,ROW()) -- Gary's Student "owl527" wrote: Hi, I have a table with real time statistics on. I would like to be able to sort them in real time. How can I do that? Please help. Thank you. -- owl527 ------------------------------------------------------------------------ owl527's Profile: http://www.excelforum.com/member.php...o&userid=20916 View this thread: http://www.excelforum.com/showthread...hreadid=546423 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
real time sorting
Hi, It doesn't seem like it is working. I am getting "#NUM!" in column B. I typed exactly the same thing in all column B. Please advise what I am doing wrong. Thanks. -- owl527 ------------------------------------------------------------------------ owl527's Profile: http://www.excelforum.com/member.php...o&userid=20916 View this thread: http://www.excelforum.com/showthread...hreadid=546423 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
real time sorting
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Local Apparent Time (LAT) - real / actual solar time ? | Excel Worksheet Functions | |||
Real-time sorting | Excel Discussion (Misc queries) | |||
Real Time Charting | Charts and Charting in Excel | |||
Real Time Inventory at the end of day | Excel Discussion (Misc queries) | |||
DDE real time and time dispay conflict | Excel Programming |