Search results

New to charting. Data builds up over 15 weeks. 16 Names in column A1 thro A16 and data in columns B thro P. Trying to have a line chart for each of the 16 names. Going round in circles!! Any help would be appreciated Using Excel for Mac 2011

Thanks I'll get around to trying it when I have time. Really must learn how to writ macros!

I am an Excel novice and have never written/recorded a macro! I have a protected worksheet with unlocked cells for data entry. When data is entered I would like to automatically change the cell's format to locked. Is this possible?

Does the Formula Evaluation exist for this? My formula auditing only shows buttons for precedents/dependents/error checking/remove arrows. I cannot find how to add evaluation

I have a spreadsheet holding name then 2 ranges of scores (holes 1-9 & 10-18). If the player has scored a 2 in either range I want to highlight their name

Thanks for the ideas. I think that I have "resolved" the problem using SUMPRODUCT. Col A - total score, Col B - last 9 holes. If col A scores are equal then the higher score in col B determines which Total score RANKs higher, the approach means that more sub totals can be included in the...

I am new to Excel and a task I undertook was to use a spreadsheet to score a week long golf tour for 12 players. Scoring is done by points won per hole, i.e. the highest score wins as opposed to a low score being the strokes taken. Ties are resolved by points scored on the last 9 holes, still...

I run several competitions and end up with a list of name, score, rank. I use conditional formatting to highlight 1st, 2nd etc in the list and this works for ties. What I would like to do is to display on an other worksheet the highest 3 scores & names. I have used INDEX & MATCH to do this...