-
Hi Mike, Thank you very much for your reply - which does work in the sernerio I have given. Where the resulting address from =ADDRESS(ROW(Latest2)+MATCH($W$77,Latest2,0),COLUMN(Latest2),4,1) is in c57 - address = k7 and the result of =ADDRESS(ROW(Latest2)+MATCH($W$77,Latest2,0)-1,COLUMN(Latest2),4,1...
-
I have been working on this during the night and have so far come up with this. Being a relative beginner it probably isn't the bestsolution but here goes:- To find the first No in the 52 cell range named Latest2 (K6:K57)I have written this:- =ADDRESS(ROW(Latest2)+MATCH(K77,Latest2,0)-1,COLUMN(Latest2...
-
Although I am a beginner I have been producing basic Excel worksheets for serveral years using some of the most common functions. Since I've always wanted to improve my Excels Skills - I though what better than to create a more complicated worksheet now I have time due to illness. Apart from my recent...
-
I am 57 years old and have just started using Excel 2003 (and hopefully soon to have excel 2007) to keep myself occupied. I have set my self a task and have been creating a worksheet to predict the UK Lottery numbers each week. I realise that the odds of winning are massive and it is very unlikely for...
-
Can please someone send me the workings in a excel sheet which shows how to create a bell shaped graph. I have 500 data points and i'm struggling to show standard deviation in the form of a bell graph. You help will be appriciated. My email address is : vanse@hotmail.co.uk Thanks