-
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...
-
There have been a few postings in different newsgroups regarding the number of keystokes involed when invoking a filter selection in Excel 2007. This reminded me of a conversation I has at a conference some while ago with Dr Peter Grebenik of Brookes University, Oxford, who uses Excel for storing all...
-
One topic I have not seen much discussion on is how to transform business logic into an automated user-maintainable workbook. I've had to deal with similar situations in various settings, so I am sure it is a common problem, so I'm curious to see what other approaches exist. Two examples: A data...
-
I am in need of some help in converting latitude and longitude position data within an excel spreadsheet. The latitude and longitude data is gathered from a SQL database and it shows up in my excel spreadsheet in the following formats: Longitude is DDDMM.mm where DDD is degrees of longitude, MM is minutes...
-
I realise that this is a forum dedicated to Excel, but I hope you don't mind me letting you know about an alternative that has just been released. It uses the same 'familiar' interface as traditional spreadsheet programs like Excel and Open Office, but is based on a very different model....