I am using excel 2007 and I have 4 columns; acct no, bill amt, enter date, eff date. I want to flag the records somehow if the "eff date" is with 90 days of...

When I attempt to expand a column the drag handle is clear, I only get a 4-way arrow and a drawing box. How can I get the black drag handle and eliminate the...

My version of Excel informs me that condtional formatting across worksheets is not allowed. Is that the case for the latest versions of Excel as well? If...

Hello, I have a problem. I need to create a dat-file from a excel-file. Do anyone know howe to do this I'll be wery grateful! -- Best regards Mia

Hi, i need a macro to run if A1 contains "John" and C1 contains "Mari", and if D1 is blank. If this criteria is not mached, then the macro to display a...

I have two worksheets. I would like to have a formula that counts data according to the following conditions. Worksheet 1 A B ...

"whatzzup" wrote: Good day, i would like a solution to this problem. i have a set of data in a spreadsheet, these could be repeated, what i would like to...

Hi, Try this =MID(A1,FIND(CHAR(7),SUBSTITUTE(A1,":",CHAR(7),2))+1,7) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that...

I have data that I must produce in a chart. Normally from a pivot table. The certain parts of the data are colour specific from an index. Is there anyway...

Hi I am using excel 2003 and everything was goin g fine until I tried to open a file (which was working ok) but now won t open and just comes up with the...

I assume that your Title starts from C1 cell and AK starts from D1 cell. Copy and paste the below formula in A1...

Hi, Try this. Note I used XLSX as the file extension because I'm using e2007 so change to the apppropriate one for you Sub...

I have the following macro it should run when the workbook is opened. I keep getting an error message. Any ideas. Isthere something that is missing Option...

Thanks for your help! "mlman" wrote: I have high speed monitoring equipment that imports thousands of date time readings as follows: 05/24/2010...

What makes a macro button or its text get bigger when clicked?

http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b213360 -- HTH... Jim Thomlinson "Rajeshwar" wrote: convert nos into words

this will do age Put your birthday in cell A1 and test =DATEDIF(A1,TODAY(),"Y") & " Years old " this will do years months and days =DATEDIF(A1,TODAY(),"Y") &...

Good evening, I completed my Microsoft Office 2003 MOUS exams. Unfortunately due to circumstances I no longer have the certificates. Is there any way of an...

Excel2003 ... If I wish to create a Line Graph where the Line is Vertical & Horz only between datapoints (no diagonal direction) for say 30 datapoints .......

I export spreadsheets from another programme to excel. The imported font size is 8 point. When I increase the font size to 10 for better printing the rows...