Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with sort function and lots of data?
I have an Excel spreadsheets with various data. Lots of Names, Dates, and
information on various things. I want to edited it so that the contents dont become insensible if a sort function is applied. It is hard for me to explain, so I will show what data I have for example Date To From Description attached doc Find it 5/3/2009 Paul Row Bev Hardue cover letter CHIS 199 c://ethos 2/2/2008 Paul Row John Newman PHD paper CHIS 299 c://PHD 4/8/2009 Grant Stow McMan Son Confid. agree CACL 110 d://confi 9/8/2009 Paul Row Bev Hardue Assistant pos ASSGN9 c://ethos 9/8/2009 Sean Briss Bev Hardue cover letter CHIS 199 c://ethos Resignation CODE R e://cr/.. Acceptance form FORM29 d://forms Chapter sub REG519 s://ffspdfs As you can see there are data. and the last 3 dont have a date to or from, because someone was lazy and didnt add it. So the last 3 should have 9/8/2009 Sean Briss Bev Hardue before each of them but they dont. So I wanted to copy and paste or fill. But was wondering if it would affect the sort. And preferably I wouldnt like to. Because if I would like to sort it with date, I dont want 20 different rows with the same dates. If you understant. Is there a way to be able to sort horizontally so the data arent affected vertically so each row stays together. And also, MY MAIN QUESTION, what do I do such that if I want to sort the data, for example the one illustrated above (my data has lots of things missing, but you can easliy copy past it, but I'd rather not ). How do I do so the data can be grouped together when sorted. I tried the grouping function, but that is hopeless! Everything gets messed up. Can soemone help me please! Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I link lots of data in multiple worksheets | Excel Worksheet Functions | |||
How to handle lots of data | Charts and Charting in Excel | |||
lots of data | Excel Discussion (Misc queries) | |||
hOW TO DELETE THE - IN (23-HFV51), I HAVE LOTS OF ROWS WITH DATA. | Excel Discussion (Misc queries) | |||
Sorting lots of data | Excel Discussion (Misc queries) |