Need formula to do the following...

[Jane Doe]

I have student First and Last Name (column A,B) and Grade (K-12) in (column
c) on sheet one with parents and contact information. On sheet 2 I want to
pull First and Last Name of student and Grades (9-12).

Can you please help? I'm rusty on functions.

 

[TXDalessandros]

You can use this formula if you would like to combine all 3 in 1 column. The
" " indicate a space between the values.

=A1&" "&B1&" "&C1

If you would like just the first and last names to be combined just use the
following formula
=A1&" "&B1
You can always just =C1 in a different column if you would like

Hope this helps

 

[Jane Doe]

Thanks, but what I was trying to do is pull data from Tab/Sheet 1 into
Tab/Sheet 2. Sheet 2 would give me name (first and Last) and (grade) of
anyone in 9th grade or above. Sorry should have been more specific.

Sheet/Tab 1..... has columns A=Parents First Name, B=Parents Last Name,
C=Contact Info, D=Child First Name, E=Child Last Name and F=Grade child is in

Resulting in
Sheet/Tab 2....pull to column A=Child First Name, B=Last Name and C=Grade
9th or above.

 

[Dave]

Hi JD,
If this is just a one-time need:
Select all data on Sheet 1
From the menu bar: <Data> <Sort>
In the Sort dialog box, in the first Sort By drop-down, choose the Grade
column.
<OK>
Students are now sorted by grade. Select and copy all students 9-12
Copy to sheet 2.
You can resort your students by any column you wish.

However, if you want something more dynamic that allows you to enter
students into sheet 1 and have them automatically appear on sheet 2 if they
are 9-12, then that would take a lot of thinking from me, and a little from
one of the MVP's
Regards - Dave.

 

[TXDalessandros]

Did you try importing this into access it is much more user friendly for
something like this. If you need to import the data I would be more than
happy to help walk you thru exactly what need to use this each year, if you
are not that familiar with Access.

(e-mail address removed)