Help needed.

Post Reply
User avatar
Travis
Newbie
Posts: 61
Joined: 24 Jan 2012, 07:17

Help needed.

Post by Travis »

Hi, I have a database that I have been building for years on Excel. My trouble is that over the years it has gone badly out of flunter alphabetically and I have no idea how to reorganise it into the correct order with my very limited skills.. The file has around 800 entries and is list of men and details who fell in WW1 from my hometown.

Is there anyone with the required skill who would like to have a go at this? I'll pay for your time or donate to charity or whatever.

Andy Fitton.
User avatar
Tripps
VIP Member
Posts: 8714
Joined: 23 Jan 2012, 14:56

Re: Help needed.

Post by Tripps »

First of all of course - make a copy of your data in case anything goes wrong.

I just did something similar with a list of all my books. Not sure which version of Excel you have, but I found that if you put the arrow into the first box of the column you want to sort - then go to the icons above the top of the screen, and find Editing - A/Z sort and filter - Sort A to Z. That will sort the data in the column alphabetically. It also seems to leave the all the 'across' fields still associated with the correct field in the first column. I hope that makes sense - and applies to all versions.

It worked for me. As long as you have a backup copy you can experiment, and come to no harm. :smile:
Born to be mild
Sapere Aude
Ego Lego
Preferred pronouns - Thou, Thee, Thy, Thine
My non-working days are Monday - Sunday
User avatar
plaques
Donor
Posts: 8094
Joined: 23 May 2013, 22:09

Re: Help needed.

Post by plaques »

Travis, its a lot easier than you think. Just try this on a trial database and then move on to a COPY of you real database.

1 Make a sample of your entries roughly the same number of columns and say 5 rows.
2 Block them out by holding the left click down and covering the full data.
3 From the top header select 'DATA'
4 Select sort.
5 Choose the primary column you want it sorting by. Tick the button for ascending or descending
6 Repeat for any secondary sorting columns
7 Hit the OK button.

This sorting will remove any empty break lines you have in the database so it may look shorter. (less rows)

Try this until you get the hang of it then move to you big data base but make a copy of it and sort the copy.

Hope this helps.
User avatar
Whyperion
Senior Member
Posts: 3068
Joined: 23 Jan 2012, 22:13
Location: Stockport, after some time in Burnley , After leaving Barnoldswick , except when I am in London

Re: Help needed.

Post by Whyperion »

As long as you dont save the spreadsheet, excel does have good Undo Functions.

I normally insert a colum to the left and auto-fill 1-800 or however many rows (I have some 1200 in a family BMD file for example) Including that colum in sort ranges means I can revert to original order if anything goes a bit wrong on sorting.

Data Filter function is also handy if one just wants to view a sub-set of data.

If you open a second worksheet tab you can then use that for data dumps of Extract according to values (extracts MUST be written to truly otherwise blank spreadsheet areas otherwise one can loose data and sometimes the undo function doesn't work(guess how I found that out, and had autosave on), or write little HLookup functions, its a little complex but once you get the hang of things it can be useful.
User avatar
Travis
Newbie
Posts: 61
Joined: 24 Jan 2012, 07:17

Re: Help needed.

Post by Travis »

Thank you guys for the help, I managed to get it all into alphabetical order...It wasn't as hard as I thought. All I have to do now is to put the corresponding photos to match the new numbers. :geek:
Post Reply

Return to “Technology & Communication”