Search for content in message boards

Formatting charts, and exporting reports to Excel

Replies: 10

Re: Formatting charts, and exporting reports to Excel

Posted: 20 Nov 2012 3:44PM GMT
Classification: Query
Edited: 20 Nov 2012 3:49PM GMT
That's strange. I can only think that you are not following my instructions or I have left something out of my instructions?? Can anyone see a flaw in my instructions?

This is a small example of what I get. Due to the limitations of pasting a real row and column presentation into these message boards, the column are mashed together; but I think you can still see the idea.

Name Birth Date Birth Place

Arlie May Hallock 12 Jul 1886 Niles, Berrien, Michigan
Esther (____) 1835 Indiana
Hattie B Hallock 21 Mar 1883 Niles, Berrien, Michigan
Hazel E Hallock 05 Sep 1888 Buchanan, Berrien, Michigan, USA
Mary Main 1870 Michigan
Milly J. Main 1865 Indiana
Orin Main 1821 Ohio
Selfade Auchmoody Feb 1844 New York
Viola Caroline Main Mar 1861 Indiana
Wellington L Hallock 1854 Manchester, Ontario, New York, USA
______________

You will have to use Excel's text to columns command to split the name field into first, middle last columns and the place field into its components. That is why the report below is sorted by first name. I haven't split the name into first and last columns. BTW, that procedure has problems because a person with no middle name will have the last name in the 2nd column; if one middle name, it will split into the last name being third column, etc.
SubjectAuthorDate Posted
Mavis_OConnor 20 Nov 2012 4:56PM GMT 
silverfox3280 20 Nov 2012 5:57PM GMT 
Mavis_OConnor 20 Nov 2012 7:07PM GMT 
silverfox3280 20 Nov 2012 10:44PM GMT 
Mavis_OConnor 20 Nov 2012 11:00PM GMT 
silverfox3280 21 Nov 2012 2:26AM GMT 
Mavis_OConnor 21 Nov 2012 4:58AM GMT 
Mavis_OConnor 21 Nov 2012 5:15AM GMT 
silverfox3280 21 Nov 2012 2:39PM GMT 
Mavis_OConnor 21 Nov 2012 8:15PM GMT 
per page

Find a board about a specific topic

  • Visit our other sites:

© 1997-2014 Ancestry.com | Corporate Information | New Privacy | New Terms and Conditions