“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

FOR AM37, I want to count the number of negative consecutive numbers in AH excluding cells that no value.

Solved by C. U. in 18 mins

I'm trying a Maths assignment in Excel and I want my spreadsheet to find if five numbers from 2-10 are consecutive (5 in a row). How can I do this for cells not in a row/column? Thanks

Solved by G. S. in 16 mins

I need to highlight cells where two consecutive cells in column A are the same AND two consecutive cells in column B are the same.

Solved by S. H. in 18 mins

I have a column of consecutive 1's followed by a false. I need to sum the consecutive 1's.in groups of 1-1's,2-1's ,3-1's etc,4,5, etc. For example in the column there is 1,1 false then 1,1,1 then false etc

Solved by A. A. in 28 mins

I need a formula that takes a label name e.g. lk-34 and adds consecutive numbers afterwards e.g. lk-34.01 lk-34.02 etc Any help would be much appreciated!

Solved by I. J. in 17 mins