Search:

So far, I haven't seen much advantage to Vista. Some things seem to work a bit better, but the unfamiliarity of it is a big drawbask. Too bad.

Wait 'til you get a load of XL07!

I have used XL 2007 for almost a year - I like the increase in rows / columns, although usually when I have that much data Excel is only a way-station in the process of loading into Access; a million...

Thanks Hans

I ended up cut/pasting the required data into a new s/sheet and it imported fine. There may have been formatting or blanks entered as " " outside the data range, but I'd have to go...

I am trying to import a simple and small excel table (three columns: date, and two numeric values, ~150 rows) into an Access database to update a table (the Excel file represents new data and should...

<hr> and instead of FireFox I HAVE to use IE - It's slowly killing me ......<hr>
Unfortunately, Mozilla isn't supporting FF2 anymore. I just downloaded FF 3, and it chased me back to IE, although...

<hr>If InStr(ws.Name, "Budget") > 0 Then<hr>

InStr(String1, String2) searches String1 to find instances of String2, and returns the starting position within String1, so

InStr("Winter", "inter")...

If the "month of record" is consistently the prior month up to the 21st, and the current month thereafter you can determine the "month of record" by formula, and use that in the PT.

I see, after looking back at the thread - my apologies for my confusion!

I also have that book, and it is excellent, but with due respect, I would suggest that if you like reference books, as well as or in preference to web citations (I use both, and I suspect that most...

I don't know if he has updated much for XL 2007, but whenver I have a charting issue, I wander over to Jon Peltier's site...

Why do you care about the order in the .mdb table? Whenever accessing that data you can specify a sort order for it, either by specifying an ORDER BY in the query that returns the recordset from...

The limit on conditional format isn't really three conditions - it is three formats. You can combine more than one logical test with a logical AND or an OR to form the condition that will trigger a...

<hr>it assumes you will never have ~#@ as part of your text!<hr>
You mean, no comic-book cursing?

You weren't including the interest that the bank would have been charging

See the attached....

You could use a pivot table, as Hans suggests, or use an array formula or DSUM function to calculate the total for rows that meet a given criteria (ie, the 'type' column = "pears," "apples,"...

I doubt that anyone is following this saga, but over at Mr Excel Jon Peltier mentioned that he had implemented a solution similar to Andy Pope's, that would allow a sloping target line, but that he...

People who went over to Mr Excel have already seen it, but if not, Jon Peltier (who is one of the real experts on charting in Excel) points out that Andy Pope had a very similar solution to the same...

Hans - right you are; while I am tempted to claim that I was merely testing to see who was paying attention, I have to admit that I just wasn't quite as clear as I should have been.

If you needed...

I was responding to a question in another forum: how can a line chart show different colours for values above and below a target value? It was much easier to deal with by attaching an example file...

There is no excel function that will do exactly what you need. I couple of years ago I needed to interpolate on some complex (actually - unknown, but not known to be simple) curves, and I wrote a...

<hr>and specify that the value must be between 1000 and 9999<hr>

Shouldn't the bounds be 0-9999, or perhaps 1-9999? Is the 7th digit of a SSN always >1, or is a zero possible in that space? I am...

Ummm....

Because until two minutes ago, I didn't know that the "ROW()" function existed...

Old dog; new trick!

Sure.

In the usual case, when you are colouring every "Nth" row, you test for <font color=blue>MOD(RowNum, N) = 0</font color=blue> - in this case, test for <font color=blue>MOD(RowNum,8) <4</font...

File | Page Setup | Sheet tab | Columns to repeat at left
(use "Rows to repeat at top" for page headers).

<hr>if you've done other things in between, deleting and recreating the legend....<hr>
I'm usually more in that boat...

Thanks, Hans.