-
Hi All I have a protected worksheet where all but a dozen cells are locked. The unlocked cells are in A1:A12. Occasionally, instead of entering data into A1:A12, the user will drag one of those cells onto another one unintentionally. Often they have no idea that they have moved a cell. Formulas in columns...
-
Hi, I have put this in the general section as I don't know if I need VBA or if I can do this with a look up. Basically I have two sets of data; Set 1 eg. Promo Code Detail Creative Offer Expense Date Live XF2 PPC Promotion Jan 09 N/A 10% Off $2000 1/1/09 GGH Geographic Magazine Jun 09 Red 15% Off...
-
I am not an expert at Excel (casual use for a few years making simple reports) but I've taken on a task of creating a spreadsheet showing the game schedule for teams in our club. This spreadsheet is a tab in a workbook that keeps track of scores and stats. I'll describe the best I can. We have...
-
I have a spreadsheet that has begun behaving badly. The behavior: Certain cells are supposed to hold formulas, but upon recalculation, the formula is often replaced with the value of the formula. The affected cells are ones that at one time contained custom functions. Other than that, the behavior seems...
-
I am trying to get the correct formula to extract the last word in a string. Data Correct Answer John Doe Doe John A. Downer Downer John A. and Jane Smithhaven Smithhaven If anyone can give me the correct fomula for extracting this data I would greatly appreciate it.
-
Thanks to you both for your help. The suggestion works perfectly and the methodology is beginning to gel (I hope!).
-
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...