Search results

Don't take this incorrectly please... If I come to your site looking for web services and I see: 1. You are using a canned site 2. No PHP 3. No CSS 4. No MySQL I am going to question the quality of your services. To me your site should be a showcase for your skills and assure me that you can...

That's just too cool! I was playing around to get the cell reference... =CELL("address",INDEX(B:B,MATCH(9.99999999999E+307,B:B),1)) and it returns the cell reference with no problem. This one has me stumped a bit. I understand the index and match, I just don't get the 9.999... part. Can you...

Sorry it took so long to get back. I'll give it a try and then do my homework as to how it works. Thank you very much!

Pretty much right. An example date1= 5/1/2007 data1= 49 date2 = 5/25/2007 data2 = 40 date3 = 6/3/2007 data3 = (nothing entered) I want to pull the data related to date2 (which would be 40). So I do understand how sumproduct works... =sumproduct((date a1:a52<=now())*(?)) ?= not sure how to just...

I have two columns: "Date" and "Appts Next Week". All the dates are filled in (the dates are the Friday of every week for the year). The data entry person finds the current date and puts in the appts as requested. I want to capture the # of appts that were last entered on a summary report. So if...

I do not understand how it works (but I will, very soon) but it works great!! Thank you very much Brian!

Thanks for the feedback. I don't think that will work too well as I am using a webquery and the data gets refreshed (including the formulas if they are in the range). So I am using a column outside the range to pick this up.

In column "A" I have text "North Bay" then there will be empty cells for maybe six or seven rows down and then it will have "South Bay". Basically I would like to fill the empty cells with the cell value above until a new cell value is found so it will look like: North Bay North Bay North Bay...

Anyone else got one? Am very happy with it but that was my toy budget for the year I'm afraid.

A while back (3 months or so) someone here posted a very cool CSS only menu system. I thouth I had saved it, but can't seem to find it anywhere. Does anyone know what I'm talking about?

It sounds like a job for something besides HTML. Many options...ASP, PHP... This request is a request to make your website "dynamic" and that is what ASP, PHP... do. Not that hard to learn, but you have to learn. There are programs like Dreamweaver and Front page to insulate you from learning...

On toolbar... Data>form

Maybe I'm not getting the whole problem here, but why not "link" excel & access table or link and update/append into an access table?

Seemed to do the trick. Thank you very much. I'm going to explore the ABS function a bit more, I know of it but not in much detail. Thanks again!

Sounds weird huh? I have a salesman that has a negative "Net Flow" goal (sales goal). Others have positive goals. His YTD Net Flows (Sales) is say...$1062 (million) and his goal is "-266 million" Of course he is doing quite well, when I use the following code to get a % to goal I get "0"...

Or another way to do it is have a list of all the possible directorates and then you can put this to the right of it... =sumproduct(--(a1:a10=f1)) (f1 being the first directorate of the directorates list you made). I just learned about this and it is very powerfull because you can do things...

ditto.. couldn't agree more.

You're not a real detail kind of guy based on your post, I would say don't update at all. but if I am reading it incorrectly here is a place to start... You will first need to add a column to your spreadsheet to differentiat a date/time of the updates. You will then need to make an...

I've run IIS on XP. You will find IIS on your XP installation disc. However it has been a while since I have done this and I seem to remember something about problems updateing to newer versions of IIS after that or something like that, I don't remember the specifics. HTH

Thanks for the help. Here's another one I found that seems to work very well... =IF(ISNUMBER(MATCH("*" & "comm" & "*",C6,0)),"Match","") It's not as simple as Accesss, but I'm not using Access.