Originally Posted by
mmoz
Hi
This is my first post so I don't know if I have put this in the correct loation. Please let me know if there is a better location.
Anyway my problem is as follows:-
I have a excel spreadsheet as follows:-
Date Address Sku
04/03/2008 ENFIELD UK103801
04/03/2008 SOUTHAMPTON UK103801
03/03/2008 GLOUCESTER UK103800
04/03/2008 REDHILL UK103667
04/03/2008 ROCHESTER UK103800
03/03/2008 BIRMINGHAM UK103667
03/03/2008 Luton UK103667
03/03/2008 Manchester UK103667
29/02/2008 BIRMINGHAM UK103620
29/02/2008 Bedford UK103620
29/02/2008 Lincoln UK103620
04/03/2008 BIRMINGHAM UK103620
29/02/2008 London UK103620
04/03/2008 Colchester UK103620
I am looking for way, formula or table, to create a table in another spreadsheet that will list all the rows that equal a specific cell for example I want the table to show all that equal the 04/03/08.
04/03/2008 ENFIELD UK103801
04/03/2008 SOUTHAMPTON UK103801
04/03/2008 REDHILL UK103667
04/03/2008 ROCHESTER UK103800
04/03/2008 BIRMINGHAM UK103620
04/03/2008 Colchester UK103620
I know this sound like a simple sort function, but the table I am actually using has a lot more data and I want to be able to select specific columns of information that relates to the selected date.
Does anyone know of an easy way to create this.
Thanks
Matt
Bookmarks