I have a table of 5 departments with the 12 monthly values in that department, What I would like to do is to list the department, maximum value (across all departments) and month that the value appeared
I have a workbook with 1 sheet containing names in col.1 nd scores in another col.
A 2nd sheet in the same workbook has the same names in a different order and I want to add the correct score adjacent to the name on the 2nd sheet
I am a part-time Excel user@@
I have a table with a header (row 1) containing names and each column contains data generated elsewhere in the work book.
What I would like to do is create, using formulae, a new version of the table where the order of the header is different and the data under each name is in the same order
A...
I have effectively a 4 column spreadsheet
Col A D A E B C
Col C A B C D E which is fixed
Col D 4 3 0 1 5
I want to populate col B with the matching value from col D
i.e. col B should read 1 4 5 3 0
I have tried a combination of INDEX MATCH & OFFSET but got into a...
I have a column of decimal numbers and firstly want the product of the integer & decimal values. e.g. 2.3 produces 6 as does 3.2. I then want the maximum value of the product to identify which rows it occurs in.
The problem that I have is that a formula such as
=IF(A1=MAX(A1:A12),B1,"") where...
I have a table with 18 columns, number of rows is variable. Each cell contains a number from 0 to 5. I would like to know the length of the longest string of the same non zero number. Where the longest strings are identical I would like to see the string for the higher number. Ideally I would...
I run Excel for Mac 2011. Not sure how I have done it but I have a workbook which when opened says macros present Enable/disable macros. When I go to Tools/Macro/Macros there is nothing to display. How can I remove the enable/disable window?
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
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
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...