-
I use Excel in real estate and personal goal setting and run into questions that aren't evident to me.. like 'how to get around circular formula errors .. pair prior ttl today run ttl pair prior ttl total run ttl A/U 100 10 110 E/U 10 7 17 G/U 50 2 52 N/U 10 8 18 E/G 200 3 203 U/C 10 9 19 E/C...
-
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...