Summary

It's quicker to get replies if you make an attempt or outline of what you are looking for, instead of just "make a summary".

Hi,

See attached

First move your attendance % table across to column AQ as per the other tabs and enter 'Attendance' in F3 of the scorecard.

Then put the following formula in C5 of the Scorecard and copy it across and down.

Formula:

Please Login or Register  to view this content.

More usefully perhaps have you considered using a Pivot Table. You may need to format your data layout differently but you'll make things a whole lot easier for yourself with any analysis.

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

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

(note: this change is not optional )

Sorry Ford - missed that one