Ok now we're getting somewhere.
Let me re-explain what I'm trying to do and I apologize for changing my mind.
So I have this huge block of numbers.
They change daily.
I want to be able to add new numbers to the block, placing the new row of numbers above the older numbers.
When I add the new row of numbers, I want the sorted list of numbers to the right side of the block of numbers to be automatically updated to match the block of numbers, except not random but sorted instead.
To the right of the sorted list of numbers is where I want the rank of how many of each number there is.
--
in short, i want all these numbers to be automatically updated when ever i enter new numbers.
is this possible? I feel like we have this started but jumbled around.
w3dgie ... wouldn't it have been good (for me, at least) to have described what you wanted at the outset?
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
I'm sorry, what to you mean by that? By the way, thank you very much for your continuous, support!
finished this project
Last edited by w3dgie; 09-25-2009 at 08:14 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks