-
Sort sequence to match with existing table in excel
Hi experts,
I wonder if it is possible to insert two columns beside an existing table and sort it to match with existing sequence
i.e.
B C D E F G H* I*
23 22.62 0 0 20367 0 20369 51.48
44 22.87 0 0 20368 20367 20368 51.33
87 5.1 0 0 20369 20368 20374 51.59
546 11.42 50.02 0 20374 20369 20377 51.43
234 90.85 50 50.06 20376 20374 20376 51.6
342 67.95 0 50.02 20377 20376 20378 51.55
112 32.9 0 50.72 20378 18570 20367 51.54
Here, columns B to G already exist, and H, I would be inserted
The challenge is values in column H need to be arranged in same sequence as of Column F, secondly the values in column I should be taken along. e.g.
when 20369 from column H would go down at 3rd row, 51.48 would also move to 3rd row.
regards,
Hope it is possible
Similar Threads
-
By rrjii2000 in forum .NET
Replies: 10
Last Post: 03-26-2010, 01:34 PM
-
By 6rtury in forum VB Classic
Replies: 10
Last Post: 04-30-2008, 01:00 AM
-
Replies: 4
Last Post: 07-10-2007, 09:03 AM
-
By Dave in forum VB Classic
Replies: 5
Last Post: 04-17-2002, 06:30 PM
-
By loupgarou24 in forum Web
Replies: 0
Last Post: 03-31-2001, 09:08 AM
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|