#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vampiress
 
Posts: n/a
Default Combine and sort

Hello all. I'm hoping for a really simple answer. Ok, here goes.

I've column A with dates in and column B with amounts beside the dates.
I've the same in columns D and E.

I'd like columns G and H to show the complete list of dates and amounts in
date order. All lists will be added to and amended.

Is this possible to do using functions, as I'm not competent in Macros. I'm
great with functions.

Thanks in advance.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I combine multiple Excel sheets? Tom Excel Discussion (Misc queries) 1 April 15th 06 11:39 AM
How do I combine a list of dates & a value into 1 week intervals Nathan Woodson Excel Discussion (Misc queries) 0 January 20th 06 01:39 AM
Sort a large file then sum like values... jgray Excel Discussion (Misc queries) 2 August 1st 05 09:22 PM
How can I sort SSNs in Terminal Digit Order using Excel? postitnote Excel Worksheet Functions 19 June 10th 05 09:25 PM
Sort Macro Sprinks Excel Discussion (Misc queries) 1 April 19th 05 04:58 PM


All times are GMT +1. The time now is 08:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"