Hi!
So I'm working on this research-project involving a large number of newspaper-articles and i'm trying to sort them by date. I put the entries as DATE - NAME OF PAPER - PAGE # - TITLE - SUMMARY
So here's my problem:
I did a control test in which I added the entries in random order, and then I tried to have Excel sort them by date. But when I did that, the dates got organized but not the rest of the entries, so now everything is mixed.
How do i avoid this problem?
NB: some of these test-entries were from clippings without dates (was gonna add those later) and so i just put an X in the date-column, maybe that added to the problem, should i just leave those blank until i find their dates?