-
Our shop is in transition from excel 2003 to 2007. When we copy long numeric values from Excel 2007 into 2003 the data displays fine at first but when we format the data to text it displays as scientific. How can I convert the data in 2003 to text and have it not display the scientific format?
-
Hi Everyone, I am an average Excel user using 2007. I am trying to type text in a text box such that I place text in the the 1st line, skip a few lines by hitting the <ENTER> key, then add my next line of text. The problem is when I hit the <ENTER> key, nothing happens. Also, if I hit the...
-
Hi, I would like to find common or duplicate records between 8 data sets (each one has different number of records). I have found this formula =IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),"",A1) which works great between two data sets. How can I modify it to include all 8 sets? Or do I need a different...
-
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...