+ Reply to Thread
Results 1 to 2 of 2

I've bitten off more than I can chew - HELP please

  1. #1
    Registered User
    Join Date
    02-04-2018
    Location
    Brisbane, Australia
    MS-Off Ver
    2016
    Posts
    1

    I've bitten off more than I can chew - HELP please

    Afternoon all,

    After creating an excel document for myself that tracks different student data and sharing it with other teachers around the school, I've been asked to create another workbook that shows student attendance for students who are away all day instead of a list of students who might have missed 1 or 2 classes.
    I need help with a formula that Looks Up the students name that has missed period RM (rollmark),1,2,3,4 of the same date.

    So in tab "imported Data" our program spits out this sheet. I need the student name (which is in column B) if they have 5 of the same date.

    For example I'd like the student "my man" to be shown on "Front page" as he has missed all of day 29/01/18. I don't mind if it shows up twice as he missed two days.


    AS I CAN'T ATTACH FILES FROM WORK I HAVE COPIED THE TABLE BELOW - THIS IS TAB 'IMPORTED DATA'

    YearLevel StudentName StudentCode FormGroup TextBox7 StartTime Period ActivityCode ActivityName Teacher code TextBox8 ArrivalTime
    Year 7 A cat 43861762E 7F Eagles 29/01/2018 08:55AM RM class a Roll Class 09:05AM
    Year 11 a dog 32502632G 11A Eagles 29/01/2018 10:15AM 2 class c Information Technolo 11:25AM
    Year 12 king blogs 38594312V 12C Eagles 29/01/2018 09:05AM 1 class a Visual Art 10:15AM
    Year 11 my man 41283695C 11F Eagles 29/01/2018 08:55AM RM Roll Class 09:05AM
    Year 11 my man 41283695C 11F Eagles 29/01/2018 09:05AM 1 Certificate II in Sk 10:15AM
    Year 11 my man 41283695C 11F Eagles 29/01/2018 12:10PM 3 Furnishing Skills 01:20PM
    Year 11 my man 41283695C 11F Eagles 29/01/2018 01:50PM 4 Mathematics A 03:00PM
    Year 11 my man 41283695C 11F Eagles 30/01/2018 08:55AM RM Roll Class 09:05AM
    Year 11 my man 41283695C 11F Eagles 30/01/2018 09:05AM 1 Access 10:15AM
    Year 11 my man 41283695C 11F Eagles 30/01/2018 10:15AM 2 Certificate I In Con 11:25AM
    Year 11 my man 41283695C 11F Eagles 30/01/2018 12:10PM 3 English Communicatio 01:20PM
    Year 11 my man 41283695C 11F Eagles 30/01/2018 01:50PM 4 Certificate II in Sk 03:00PM
    Year 12 v goodz 87016611X 12A Eagles 02/02/2018 10:15AM 2 Physical Education 11:25AM
    Year 11 student why 88458305U 11F Eagles 31/01/2018 12:10PM 3 Early Childhood 01:20PM
    Year 8 what are 32554714R 8A Eagles 29/01/2018 08:55AM RM Roll Class 09:05AM
    Year 8 what are 32554714R 8A Eagles 29/01/2018 09:05AM 1 EALD Maths 10:15AM
    Year 8 what are 32554714R 8A Eagles 29/01/2018 10:15AM 2 Health and Physical 11:25AM
    Year 8 what are 32554714R 8A Eagles 29/01/2018 12:10PM 3 EALD English 01:20PM
    Year 8 what are 32554714R 8A Eagles 29/01/2018 01:50PM 4 EALD Humanities 03:00PM


    IF any can help I'd much appreciate it.

    Regards,
    Terry S

    PS. Needless to say since I work in a school I have changed all names and id codes. House names and subjects are the same since that cannot identify a student.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: I've bitten off more than I can chew - HELP please

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)


    (How to) Upload a Workbook directly to the Forum
    (please do not post pictures or links to worksheets)
    • Click Advanced next to Quick Post button at the bottom right of the editor box.
    • Scroll down until you see "Manage Attachments",
    • Click the "Choose" button at the upper left (upload from your computer).
    • Select your file, click "open", click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Close the Attachment Manager window.
    • Click "Submit Reply"
    Note: Please do not attach password protected workbooks/worksheets
    Ensure to disable any Workbook Open/Autorun macros before attaching!
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need help with my countif formula, bit off more than i can chew
    By ahalliwell in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-09-2017, 05:47 AM

Tags for this Thread

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