Search results for query: *

Hi Tony, I found out how it works and that I can just enter the bookmark name. Now my new problem is that there seems to be a function in my company's word template that positions to the start of the document. Is this a changeable feature in a Word template? So what happens now is that the...

I am writing a process description in Word and drafting an associated process chart in Visio. I would like to link from the Visio shapes representing activities to the related activity description in the Word document. In Visio I can set up a link to the Word dokument and there is a "sub...

Hi, I looked in the SUMPRODUCT threads but couldn't see the solution. To be more specific about my problem: My data (which is customer error reports) looks basically like this: C1 C2 C3 C4 id submit date solution date time2solution I want to calculate the...

Hi! I have a big excel sheet with a lot of data that use to present various statistics. Each record is a row and the are sorted after creation date which is one of several columns. Now I wanted to do the following: search one of the columns for specific contents (for example date (not creation...

Hi! I am retreiving data from a MS SQL 2000 DB to my EXCEL spreadsheet and this goes well using a SQL query from inside EXCEL. However, I have discovered that the returned data for timestamps is in UTC format while my time zone is CET. I scanned the web for info and found that there is an...

I am retreiving data from a MS SQL 2000 DB to my EXCEL spreadsheet and this goes well using a SQL query from inside EXCEL. However, I have discovered that the returned data for timestamps is in UTC format while my time zone is CET. I scanned the web for info and found that there is an expression...

Ok, I understand the concept of using a name and that the suggestion creates a reference to the complete data matrix. Unfortunately in my case it is more complex. A typical source data for my charts look like this: =sheet1!$A$1:$U$1;sheet1!$A$3:$U$3;sheet1!$A$6:$U$6;sheet1!$A$10:$U$10 ...and...

OK, the hide columns approach works, thanks for that! However, another problem is when I add the data for another month at the right of the matrix. How can I modify all my charts (maybe 50 of them) to show also the new months data, without editing the selection of source data for each and every...

My problem is the following: I have a big matix of data with the folowing structure: Jan Feb Mar ... data1 ... ... ... ... data2 ... ... ... ... data3 ... ... ... ... .... From this matrix I have generated a big number of charts with different data vs. the months, i.e...

I have generated a lot of charts, which resides inside a MS EXCEL file. These charts are updated regularly and I need to present the results. Questions: 1. Can I import these charts into my PPT file in a more automatic fashion that what I use now, i.e. select the chart in EXCEL, Copy and paste...

Sorry for my phrasing. Indeed your suggested syntax did work!! Thanks very much! I have been iterating my SQL statement using MS Query, which is the tool at hand. The resulting statement is like this: SELECT T1.id, T1.submit_date, T1.severity, T1.verification, MAX(case when...

Hi again, Back again in the forum after attending to some other stuff. I did try the construction suggested by swampBoggie (having a case statement within a max function in the select statement), but it does not seem to work on my system. swampBoggie wrote "You never stated which DBMS you...

Hi! Wow very fast replies! Sorry I was not specific, but I am a SQL rookie. Let me try to be more specific: What I can easily get with a standard query is a result like this: PROBLEMID State time_stamp #1 start 2003-04-01 #1 finish 2003-05-23 #1 close...

Hi! I am trying to extract data from a Problem DB in SQL. The Problems in the database pass through different states as they are treated. The states are named and there is an associated time stamp for each state. In my query I want to SELECT the Problem id and then the time stamp for 3 different...