award

Hello, I have a reception Im going to be keeping track of those people who arrive and I need 2 formulas to keep track of how many group of people have arrived, and of those how many of them are getting an award. I'm not sure how to attach my spreadsheet anymore since I've gone to Excel 2016 so...

Hi Maybe someone can point me in the right direction. I have a tab that I am using as a key (Award Abbrev) that I want to use to populate cells in another tab in the same workbook (Staff Details) I have created specific text in I2:I60 in "Award Abbrev" that on the corresponding row has values in...

Thank you in advance. I have a spreadsheet with participants winning multiple awards. I want the awards in separate columns tiled Awards 1 Award 2 Award 3.... I have this... <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> Name Award Jane Gold...

I have a list of names in Column B which has the possibility of changing order if the list gets a new name based on meeting a criteria. These list of names are used to determine who has achieved an award. I need a way of keeping track of when an award was given to this individual. Because the...

I am using 'small' / 'large' to give a rank order of students, such that students are ranked according to their test score, which works well. However, we can only award a limited number of grades to each class, therefore, once I have ranked ordered the class, (it does this dynamically), I need...

I am relatively new to access forms and have a question. I have a bound subform which I would like to have data edits and bring the focus back to the incorrect field.. As an example, if I leave the award field as '0', the error message displays "Must enter award amount". When I click "OK", I...