Good morning,
i used to be pretty good with excel but have moved to a job where I no longer need it as much and i cant remember half what i used to know.
I want to set up an at a glance page to show student names as well as number of absences based on a minimum number (3 in this case). The name and number of absences are pulled from another sheet, if I didn't make that clear.
thanks
Scott
It will be clearer and will give context if you upload a representative Excel workbook sample.
To do this:
To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),
- be sure to desensitize the data
- click “Go Advanced” (next to Post Quick Reply – bottom right),
- scroll down until you see “Manage Attachments”, click that,
- click “Browse”.
- select your file(s)
- click “Upload”
- click “Close window”
- click “Submit Reply”
The file name will appear at the bottom of your reply.
Dave
The names have been changed to protect the innocent. if you scroll to the right on "tardy" sheet there is a total number of times they were late. The second sheet is the example of the data on the at a glance page that i want.
The data will be used for absences as well as late attendances.
Thanks,
Scott
A couple of ways come to mind.
In B7:B11 'Sheet1'orFormula:
Please Login or Register to view this content.Formula:Please Login or Register to view this content.
That first one is perfect. Thank you very much.
You are welcome. Thank you for the feedback.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks