Results 1 to 5 of 5

Need formula to consolidate entries from several sheets

Threaded View

stan2013 Need formula to consolidate... 02-01-2013, 03:02 AM
:) Sixthsense :) Re: Need formula to... 02-01-2013, 03:33 AM
stan2013 Re: Need formula to... 02-01-2013, 08:44 AM
:) Sixthsense :) Re: Need formula to... 02-01-2013, 10:40 AM
stan2013 Re: Need formula to... 02-04-2013, 07:33 PM
  1. #1
    Registered User
    Join Date
    02-01-2013
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    3

    Need formula to consolidate entries from several sheets

    Hey guys

    I need to create a single table from several other tables in other sheets.

    i.e.

    Sheet 1 has:

    Student ID # Qualification Level
    0457 Certificate IV
    0384 Diploma
    0384 Certificate IV
    1687 Certificate II

    Note that it is possible for a Student ID to repeat but have a diferent qualification


    Sheet 2 has:

    Student ID # Qualification Level
    0722 Certificate III
    0605 Diploma
    0941 Certificate II

    I need a formula in Sheet 3 which knows how many entries are in Sheet 1 and returns them all, then in the next available line it begins to return all entries in Sheet 2. Sheet 3 should read:

    Student ID # Qualification Level
    0457 Certificate IV
    0384 Diploma
    0384 Certificate IV
    1687 Certificate II
    0722 Certificate III
    0605 Diploma
    0941 Certificate II

    The same example is attached in the spreadsheet.

    Thanks guys

    Stan
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1