Re: Sorting the data

Ernest Fine <efine@...>

Ada, and others who are interested in solving this type of problem, the
easiest and quickest way to do this is to add another column to the
spreadsheet; this new column will contain either the surname of the
husband, or the surname of the bride. It then becomes one of the sort keys.

To create the contents of this column, an "IF" statement is used.

Let's say the spreadsheet looks something like:

column A = husband surname
column B = bride surname
column C = Type code
column D = new column for surname

In column D, in whatever row the data starts in, place the following
statement. For the sake of example, I am using row "5."

=IF(C5="M",A5,B5)

This will result in cell D5 being filled with the contents of cell A5 if
the type code is "M", and D5 being filled with the contents of cell B5 if
A5 is NOT "M." (If using a lower-case "m" - type that value instead of "M"
- it has to match exactly.)

Then, you will do a "fill down" on the formula, to place the formula in all
rows. To do this, click on the first formula cell (the one you just typed
the "IF" statement into, C5 in our example here), and drag, with the mouse,
down that one column so all rows are highlighted. Then perform the "fill"
operation - press the "Ctrl+D" keys.

(Alternatively, since this is a large spreadsheet, click on the first
formula cell, then scroll down to the last formula cell; hold down the
Shift key, and click that last cell. This will highlight all rows
inbetween. Then press the Ctrl+D keys for the fill operation.)

NOTE: the directions above are for Excel 97. Process is similar for other
spreadsheets but exact statements may vary.

Ernie Fine
Vienna, VA, USA

At 10:06 PM 9/2/99 PDT, you wrote:
Dear JRIERS,

I am the Plockoordinator:-), and sent more than 14000 records during
the past year, while many more still to be posted in the future, mainly
from the Russian years of the Mormons microfilms >from the town of Plock.
I have all the data sent to JRI database. It is in Excel. I want to sort
the data according the surnames and than the type and than the year.
I need to sort of differently when it is M - marriages.
When type is M, the sort key should be the surname of husband, but
the Surname of the bride should be under it.

How do I do that?

Thanks in advance for the tip, shalom,

[snip]

Re: seeking information

MILTGOLD@...

In a message dated 9/2/99 11:19:42 AM, Lffriedman@... wrote:

<<the surname was Chilko
and she was >from Milesczyce. >>

Any other researchers of this surname listed at Jewishgen.org on the JGFF?
Have you looked for that surname at avotaynu.com, their database of surnames
appearing in various genealogical sources? You also could check the town
name "Milesczyce" in the Jewishgen.org/shetlseeker but use the phonetic
spelling (Daitch-Motokoff coding) and not specify any country to find out
where the town was located, and print off the map, to see where it's located
and major towns near it. You could enter the surname in the Social Security
Death Index at ancestry.com/ssdi/advanced.html, to track down others with the
name, and send for their social security applications, at \$7 each to learn
their addresses and parentage. And perhaps you'd be lucky to find possible
relatives in the USA by entering the surname in switchboard.com, the Internet
computerized telephone directory.

Best of luck!

Milt Goldsamt
miltgold@...

JRI Poland #Poland RE: Sorting the data

Ernest Fine <efine@...>

Ada, and others who are interested in solving this type of problem, the
easiest and quickest way to do this is to add another column to the
spreadsheet; this new column will contain either the surname of the
husband, or the surname of the bride. It then becomes one of the sort keys.

To create the contents of this column, an "IF" statement is used.

Let's say the spreadsheet looks something like:

column A = husband surname
column B = bride surname
column C = Type code
column D = new column for surname

In column D, in whatever row the data starts in, place the following
statement. For the sake of example, I am using row "5."

=IF(C5="M",A5,B5)

This will result in cell D5 being filled with the contents of cell A5 if
the type code is "M", and D5 being filled with the contents of cell B5 if
A5 is NOT "M." (If using a lower-case "m" - type that value instead of "M"
- it has to match exactly.)

Then, you will do a "fill down" on the formula, to place the formula in all
rows. To do this, click on the first formula cell (the one you just typed
the "IF" statement into, C5 in our example here), and drag, with the mouse,
down that one column so all rows are highlighted. Then perform the "fill"
operation - press the "Ctrl+D" keys.

(Alternatively, since this is a large spreadsheet, click on the first
formula cell, then scroll down to the last formula cell; hold down the
Shift key, and click that last cell. This will highlight all rows
inbetween. Then press the Ctrl+D keys for the fill operation.)

NOTE: the directions above are for Excel 97. Process is similar for other
spreadsheets but exact statements may vary.

Ernie Fine
Vienna, VA, USA

At 10:06 PM 9/2/99 PDT, you wrote:
Dear JRIERS,

I am the Plockoordinator:-), and sent more than 14000 records during
the past year, while many more still to be posted in the future, mainly
from the Russian years of the Mormons microfilms >from the town of Plock.
I have all the data sent to JRI database. It is in Excel. I want to sort
the data according the surnames and than the type and than the year.
I need to sort of differently when it is M - marriages.
When type is M, the sort key should be the surname of husband, but
the Surname of the bride should be under it.

How do I do that?

Thanks in advance for the tip, shalom,

[snip]

JRI Poland #Poland Re: seeking information

MILTGOLD@...

In a message dated 9/2/99 11:19:42 AM, Lffriedman@... wrote:

<<the surname was Chilko
and she was >from Milesczyce. >>

Any other researchers of this surname listed at Jewishgen.org on the JGFF?
Have you looked for that surname at avotaynu.com, their database of surnames
appearing in various genealogical sources? You also could check the town
name "Milesczyce" in the Jewishgen.org/shetlseeker but use the phonetic
spelling (Daitch-Motokoff coding) and not specify any country to find out
where the town was located, and print off the map, to see where it's located
and major towns near it. You could enter the surname in the Social Security
Death Index at ancestry.com/ssdi/advanced.html, to track down others with the
name, and send for their social security applications, at \$7 each to learn
their addresses and parentage. And perhaps you'd be lucky to find possible
relatives in the USA by entering the surname in switchboard.com, the Internet
computerized telephone directory.

Best of luck!

Milt Goldsamt
miltgold@...

Re: Need a couple of records printed

garymaher@...

For a small fee, you can order copies of specific pages >from films and
books possessed by the LDS directly >from Salt Lake City. Last time I did
this, about 6 years ago, it cost 25 cents per copy when the page number
was provided, and \$2 per copy without a specific page number. There was
a \$2 minimum order. The fees may have increased since.

I know this method works for census records, US census indexes, books and
general microfilms and microfiche. You can also request copies >from an
index. (I have successfully located information on American families by
requesting, for example, the "C" portion of the index >from a book, then
ordering the pages on which the surname appeared). I do not know if they
can (or will) locate a record in Polish or Russian based on the year,
event and record number (without a specific page number). I've been
meaning to test this but haven't gotten around to it.

You need to get the LDS form called "Request for Photocopies - Census
Records, Books, Microfilm or Microfiche". (There is a different form to
request photocopies of sources for IGI entries, which BTW is now useless
to most people receiving this digest.) You should be able to get one at
your local FHL, otherwise sent to SLC for a copy. (Try the Family
History Department, 35 North West Temple Street, Salt Lake City, Utah
84150.) Send the completed form and a check to that address I just
mentioned, and they send the photocopies right to you.

If anyone has had or does have success using this method to obtain Polish
records or other non-English records, please post to the list!

Gary

On Thu, 02 Sep 1999 00:00:57 -0500 "JRI-Poland digest"
<jri-pl@...> writes:
Subject: Need a couple of records printed
From: Marcos Frid <mfrid@...>
I have recently discovered that I didn't print all the records which
I should have printed >from a film which has been sent back >from my
local FHC to Utah. If some kind soul (who has access to an FHC with
the following film in permanent loan) be so kind as to print the
two records I need, I'll be very grateful and of course I will refund
all your expenses. I'm just trying to avoid ordering the film again
just to print a couple of pages.

The film number is: 753121
This is Wielun Jewish B-M-D records for 1826-1853
I need the following two records:
1.- 1835, Deaths, akt #10: Rachel Lachmanowicz
2.- 1835, Deaths, akt #(I didn't write it): Sura Lachmanowicz
___________________________________________________________________
Get the Internet just the way you want it.
Free software, free e-mail, and free Internet access for a month!
Try Juno Web: http://dl.www.juno.com/dynoget/tagj.

Re: Sorting the data

Jim & Sara Feldman <feldmans@...>

The answer I am about to give assumes that the records are
intermixed. That is, that M records are mixed with B and D records
and that there are separate columns for GROOM and BRIDE name. That
being the case, consider (and this is not the only solution):

First sort the list on the column containing M/B/D. Do it in
reverse order so that M comes out on top. (You could now simply copy
it to another spreadsheet to simplify your life but I am doing it one
sheet.) Now highlight the entire section containing M records and the
headings as well. Excel allows you to sort in order by three
different parameters (columns) so: Sort now FIRST on GROOM and SECOND
on BRIDE. You have what you asked for.

Jim

Dear JRIERS,

I am the Plockoordinator:-), and sent more than 14000 records during
the past year, while many more still to be posted in the future, mainly
from the Russian years of the Mormons microfilms >from the town of Plock.
I have all the data sent to JRI database. It is in Excel. I want to sort
the data according the surnames and than the type and than the year.
I need to sort of differently when it is M - marriages.
When type is M, the sort key should be the surname of husband, but
the Surname of the bride should be under it.

How do I do that?

Thanks in advance for the tip, shalom,

-------------------------------------
Date: 09/02/99
Time: 22:06:08
Web site:http://www.geocities.com/Paris/Rue/4017/
-------------------------------------

This list (jri-pl@...) is hosted by
JewishGen: The Home of Jewish Genealogy
Visit JRI-PL at http://www.jewishgen.org/jri-pl/
---
You are currently subscribed to jri-pl as: feldmans@...
To unsubscribe send email to \$subst('Email.Unsub')
Jim Feldman
14 Linda Lane
Newton, MA 02461

617-527-0509

Re: family roots - Mszczonow Shtetl CO-OP

Stanley Diamond

I just spoke to Alan Knecht and mentioned that I would be making a
follow-up post to his message (repeated below). He asked me to
clarify something in his post. The first sentence should read:

"I recently photocopied all the *index pages" to the records >from
Mszczonow >from LDS film numbers 1199887 & 1199888 for
the years 1855 to 1876..."

As Alan also mentioned, now that we have these index pages,
Jewish Records Indexing - Poland needs a volunteer to head up
a Shtetl CO-OP to data enter the Mszczonow indices.

In addition to the index pages >from the above two films, there are
two more LDS films for this town (for the years 1826 to 1845).
The JGS Toronto Copy Service of the JRI-Poland project is
available to order these two LDS films >from Salt Lake City and
to make the photocopies for the Mszczonwo Shtetl CO-OP.

For more information on the JGS Toronto Copy service, go to the
JRI-Poland web site and click on the Shtetl CO-OP link at the top.
The Copy Service information is linked >from the Shtetl CO-OP page.

Stanley Diamond
Project Coordinator, Jewish Records Indexing - Poland

In a message dated 9/2/99 3:18:14 PM EDT, alan@... writes:

I recently photocopied all the records >from Mszczonow - 1199887 &
1199888 for JRI-Poland. During this period, I had the films >from the
LDS. They were returned about 2 weeks ago.

You may want to contact JRI-Poland as they are looking for someone to
head up the indexing for Mszczonow.

Alan K'necht
alan@...

shely wrote:

> Dear Sir
>
> I am looking for the LDS Polish-Jewish vital records.
>
> I need the following microfilms.
> Mszczonow - 1199887 & 1199888
> Skierniewice - 1191774 & 1191775
>
> I appreciate your assistance to tell me how to receive these microfilms.
>
> Sincerely - Aron Meron-Michowski, ISRAEL
> Fax:+972-9-7925198

JRI Poland #Poland Re: Need a couple of records printed

garymaher@...

For a small fee, you can order copies of specific pages >from films and
books possessed by the LDS directly >from Salt Lake City. Last time I did
this, about 6 years ago, it cost 25 cents per copy when the page number
was provided, and \$2 per copy without a specific page number. There was
a \$2 minimum order. The fees may have increased since.

I know this method works for census records, US census indexes, books and
general microfilms and microfiche. You can also request copies >from an
index. (I have successfully located information on American families by
requesting, for example, the "C" portion of the index >from a book, then
ordering the pages on which the surname appeared). I do not know if they
can (or will) locate a record in Polish or Russian based on the year,
event and record number (without a specific page number). I've been
meaning to test this but haven't gotten around to it.

You need to get the LDS form called "Request for Photocopies - Census
Records, Books, Microfilm or Microfiche". (There is a different form to
request photocopies of sources for IGI entries, which BTW is now useless
to most people receiving this digest.) You should be able to get one at
your local FHL, otherwise sent to SLC for a copy. (Try the Family
History Department, 35 North West Temple Street, Salt Lake City, Utah
84150.) Send the completed form and a check to that address I just
mentioned, and they send the photocopies right to you.

If anyone has had or does have success using this method to obtain Polish
records or other non-English records, please post to the list!

Gary

On Thu, 02 Sep 1999 00:00:57 -0500 "JRI-Poland digest"
<jri-pl@...> writes:
Subject: Need a couple of records printed
From: Marcos Frid <mfrid@...>
I have recently discovered that I didn't print all the records which
I should have printed >from a film which has been sent back >from my
local FHC to Utah. If some kind soul (who has access to an FHC with
the following film in permanent loan) be so kind as to print the
two records I need, I'll be very grateful and of course I will refund
all your expenses. I'm just trying to avoid ordering the film again
just to print a couple of pages.

The film number is: 753121
This is Wielun Jewish B-M-D records for 1826-1853
I need the following two records:
1.- 1835, Deaths, akt #10: Rachel Lachmanowicz
2.- 1835, Deaths, akt #(I didn't write it): Sura Lachmanowicz
___________________________________________________________________
Get the Internet just the way you want it.
Free software, free e-mail, and free Internet access for a month!
Try Juno Web: http://dl.www.juno.com/dynoget/tagj.

JRI Poland #Poland RE: Sorting the data

Jim & Sara Feldman <feldmans@...>

The answer I am about to give assumes that the records are
intermixed. That is, that M records are mixed with B and D records
and that there are separate columns for GROOM and BRIDE name. That
being the case, consider (and this is not the only solution):

First sort the list on the column containing M/B/D. Do it in
reverse order so that M comes out on top. (You could now simply copy
it to another spreadsheet to simplify your life but I am doing it one
sheet.) Now highlight the entire section containing M records and the
headings as well. Excel allows you to sort in order by three
different parameters (columns) so: Sort now FIRST on GROOM and SECOND
on BRIDE. You have what you asked for.

Jim

Dear JRIERS,

I am the Plockoordinator:-), and sent more than 14000 records during
the past year, while many more still to be posted in the future, mainly
from the Russian years of the Mormons microfilms >from the town of Plock.
I have all the data sent to JRI database. It is in Excel. I want to sort
the data according the surnames and than the type and than the year.
I need to sort of differently when it is M - marriages.
When type is M, the sort key should be the surname of husband, but
the Surname of the bride should be under it.

How do I do that?

Thanks in advance for the tip, shalom,

-------------------------------------
Date: 09/02/99
Time: 22:06:08
Web site:http://www.geocities.com/Paris/Rue/4017/
-------------------------------------

This list (jri-pl@...) is hosted by
JewishGen: The Home of Jewish Genealogy
Visit JRI-PL at http://www.jewishgen.org/jri-pl/
---
You are currently subscribed to jri-pl as: feldmans@...
To unsubscribe send email to \$subst('Email.Unsub')
Jim Feldman
14 Linda Lane
Newton, MA 02461

617-527-0509

JRI Poland #Poland Re: family roots - Mszczonow Shtetl CO-OP

Stanley Diamond

I just spoke to Alan Knecht and mentioned that I would be making a
follow-up post to his message (repeated below). He asked me to
clarify something in his post. The first sentence should read:

"I recently photocopied all the *index pages" to the records >from
Mszczonow >from LDS film numbers 1199887 & 1199888 for
the years 1855 to 1876..."

As Alan also mentioned, now that we have these index pages,
Jewish Records Indexing - Poland needs a volunteer to head up
a Shtetl CO-OP to data enter the Mszczonow indices.

In addition to the index pages >from the above two films, there are
two more LDS films for this town (for the years 1826 to 1845).
The JGS Toronto Copy Service of the JRI-Poland project is
available to order these two LDS films >from Salt Lake City and
to make the photocopies for the Mszczonwo Shtetl CO-OP.

For more information on the JGS Toronto Copy service, go to the
JRI-Poland web site and click on the Shtetl CO-OP link at the top.
The Copy Service information is linked >from the Shtetl CO-OP page.

Stanley Diamond
Project Coordinator, Jewish Records Indexing - Poland

In a message dated 9/2/99 3:18:14 PM EDT, alan@... writes:

I recently photocopied all the records >from Mszczonow - 1199887 &
1199888 for JRI-Poland. During this period, I had the films >from the
LDS. They were returned about 2 weeks ago.

You may want to contact JRI-Poland as they are looking for someone to
head up the indexing for Mszczonow.

Alan K'necht
alan@...

shely wrote:

> Dear Sir
>
> I am looking for the LDS Polish-Jewish vital records.
>
> I need the following microfilms.
> Mszczonow - 1199887 & 1199888
> Skierniewice - 1191774 & 1191775
>
> I appreciate your assistance to tell me how to receive these microfilms.
>
> Sincerely - Aron Meron-Michowski, ISRAEL
> Fax:+972-9-7925198

GOLUB Family

NR153155 <nr153155@...>

My great grandmother Fruma SCHWARTZ had a sister who married a man named
GOLUB. Some or all of the expanding Golub family lived on Manhattan's upper
west side in the 1910's-20's (maybe until later). I believe there were a
number of children. I would love information. Thanks in advance.

Norman Ringle
NR153155@...

JewishGen Discussion Group #JewishGen GOLUB Family

NR153155 <nr153155@...>

My great grandmother Fruma SCHWARTZ had a sister who married a man named
GOLUB. Some or all of the expanding Golub family lived on Manhattan's upper
west side in the 1910's-20's (maybe until later). I believe there were a
number of children. I would love information. Thanks in advance.

Norman Ringle
NR153155@...

Re: Disembarkment work days ??

Hilary Henkin <propper@...>

I learned at the NY Conference, >from Rafi Gruber, that the ships
actually docked on the Upper West Side. First and Second class
passengers disembarked there. The steerage passengers were then
taken by ferry to Ellis Island.

Hilary Henkin
Atlanta, Georgia USA

JewishGen Discussion Group #JewishGen Re: Disembarkment work days ??

Hilary Henkin <propper@...>

I learned at the NY Conference, >from Rafi Gruber, that the ships
actually docked on the Upper West Side. First and Second class
passengers disembarked there. The steerage passengers were then
taken by ferry to Ellis Island.

Hilary Henkin
Atlanta, Georgia USA

Hannah ISRAEL

Mrs M Sprott

Could it be possible for someone to help me work out why my Jewish
Granmother gave her 6 daughters the surname ISRAEL, when the 12 boys took
the surname of their father.

Granma also listed her mother's name as "unknown" on her marriage
certificate, but listed her father as Morris ISRAEl and put (Moshe) in
brackets. She listed her father's occupation as a Tailor, which is what her
birth certificate in England says. Could Hanna ISRAEL's mother have died
and she was bought up by another member of her family, so she did not know
who here real mother's name was?

Monica Sprott
Queensland
Australia
msprott@...

Serarching people with the surname ISRAEL, GOODMAN and GOLDMAN >from England
and what used to be Prussia, Germany.

JewishGen Discussion Group #JewishGen Hannah ISRAEL

Mrs M Sprott

Could it be possible for someone to help me work out why my Jewish
Granmother gave her 6 daughters the surname ISRAEL, when the 12 boys took
the surname of their father.

Granma also listed her mother's name as "unknown" on her marriage
certificate, but listed her father as Morris ISRAEl and put (Moshe) in
brackets. She listed her father's occupation as a Tailor, which is what her
birth certificate in England says. Could Hanna ISRAEL's mother have died
and she was bought up by another member of her family, so she did not know
who here real mother's name was?

Monica Sprott
Queensland
Australia
msprott@...

Serarching people with the surname ISRAEL, GOODMAN and GOLDMAN >from England
and what used to be Prussia, Germany.

KIRSHENBLAT Family-Warsaw

NR153155 <nr153155@...>

I hope that someone, somewhere knew any of the KIRSHENBLAT's. In pre-war(WWII)
there were 8 or 9 siblings. I survived the war, married and went to Isreal then
NYC. The problem is he never spoke of any of the others. They were a family of
merchants in Warsaw. I assume that they either stayed in the ghetto or went to
Auschwitz. I am looking to help the grandchildren. They were probably teens,

Norm Ringle
NR153155@...

JewishGen Discussion Group #JewishGen KIRSHENBLAT Family-Warsaw

NR153155 <nr153155@...>

I hope that someone, somewhere knew any of the KIRSHENBLAT's. In pre-war(WWII)
there were 8 or 9 siblings. I survived the war, married and went to Isreal then
NYC. The problem is he never spoke of any of the others. They were a family of
merchants in Warsaw. I assume that they either stayed in the ghetto or went to
Auschwitz. I am looking to help the grandchildren. They were probably teens,

Norm Ringle
NR153155@...

From Sambor to Atlanta, 1909

NR153155 <nr153155@...>

My grandfather Osias RINGLE came >from Sambor, Galicia in 1909. He came to
NYC.There he joined my eldest Aunt Rose, who had preceded him by a year.
However before settling in on the lower East Side he made a six month trip
to visit a landsman in Atlanta, Georgia. This was recent news to me. Is
there anyone in Atlanta who knows of their Sambor roots? Thanks.

Norm Ringle
NR153155@...

JewishGen Discussion Group #JewishGen From Sambor to Atlanta, 1909

NR153155 <nr153155@...>

My grandfather Osias RINGLE came >from Sambor, Galicia in 1909. He came to
NYC.There he joined my eldest Aunt Rose, who had preceded him by a year.
However before settling in on the lower East Side he made a six month trip
to visit a landsman in Atlanta, Georgia. This was recent news to me. Is
there anyone in Atlanta who knows of their Sambor roots? Thanks.

Norm Ringle
NR153155@...