Recent content by mhoyt

Ah Chris! Sweet! Works like a charm. Thank you!

Not on my machine. I get Path]filename.xls Adding an equals sign at the beginning, or a space between the two functions(right term?) does not help either.

Among the built-in options for Excel footers is the filename and tab description. I like to put those in each of my document so people can find the file again later. But it is not always obvious which network directory contains the file so I'd like to add the full pathname to the footer. Is...

Holy cow! That is a great link John! I love days where I learn new skills, this is a banner day!

Hey, another neat idea! Thanks. I see you are concatanating the < sign to make it work, I wasn't haven't ay luck without the concatanation, so thats another good tip. Skip, why does yours work? What does the sumproduct function do?

Bingo! Thanks very much Skip!

I have a range called SCORES, with numeric values 0 to 100. I want to see how many scores are between (inclusive) let's say 70 and 79. And basically every other range of possibilities in 10 point increments. So I thought I'd use column D for the minimum point of any given range, and column...

When I press snooze on a calander alarm I'm expecting it to pop back up in 5 minutes like I told it. Instead it pops back up anywhere from 10 seconds to 2 minutes or so. Wildly inconsistent. Any ideas? Second issue, be a hero to many. Is there any way to pick a snooze interval longer than...

You are a stud! Thanks so much!

Sorry, stacked columns is correct. Your next steps let me add the row with the Line data to the chart, but it treats it as an additional data point and justs add it to the the top of each column. I need to diaplay it as a line, preferably with a second value scale on the right hand side Y axis.

Cordury2, can you explain why that will help? I've had the same problem, the exact same formula works fine in certain cells of my spreadhseet, and stubbornly displays as text in other cells. I suspect it is a cell formatting issue but I've never stuck with it long enough to figure it out...

It's also possible the User has inadvertently grouped the column and selected a higher level view.

I have a table of data, 12 columns of months and 8 rows of data. I want a chart with months as the X axis and values on the Y axis. I further want the first seven rows to be a stacked bar for each month, and the last row to be a line superimosed across the stacked bars. A stacked bar chart is...

That's a good idea. Pretty much that is how things are organized, so I'll give that a try. Thanks!

George has the right solution for you. To get an Excel list of numbers into a SQL table is easy, use the DTS Import wizard in Enterprise Manager, then use George's code