Search results

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

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

OK as far as it goes but Sajan's formulae return the number of consecutive numbers for values 1 thro 5

Hi Thanks, it does what I want. When I finally thought to expand the formula box I could see all of the formula! By taking the MAX value of the 5 results cells, which also takes care of 2 or more numbers (1 to 5) having equal number of sequences and by using ROUNDDOWN I can display the longest...

Hi Thanks for the prompt response. What the formula is doing for me is returning the highest number of occurrences of the highest number. What I am looking for is length of the longest string of identical numbers and if the length of strings are equal then show that for the highest number e.g...

Showing my ignorance, what is the significance of the { brackets and how do I define "row_of_numbers"? Hopefully I will learn from the experts!

Consecutive in rows

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

Thanks, saving as *.xlsx worked as the VBA editor did not show any modules to delete

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?

That's where I started! It does not explain where/how to use years-data or how to edit series, which I cannot find in Excel for Mac 2011.