Recent content by clumpa

Great, just what I wanted & nice and straightforward, thanks

Whoops, got he specification wrong!! the MAX value can appear more than once in each department

test file attached

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

Yes it does, thanks

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@@

Thanks Luke, just what I needed!

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...

Thanks, just what I wanted/needed!!

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 use an English version of Excel so a decimal point! Can anyone tell me what value is in cell C3 in the attached spreadsheet?

The first formula I used to calculate the product was =INT(A1)*((A1-INT(A1))*10) which displays the "correct" value but does not work. I am using a Mac & Microsoft Office and pressing F2/F9 either separately or together does not seem to do anything Sajan's formula to calculate the product does...

NO

Thanks Sajan, your formula to calculate the product solves my problem whereas INT(A1)*((A1-INT(A1))*10) PRODUCES THE"CORRECT" VALUE WHICH DOES NOT WORK