Is there any way to exclude cells with highlighted text from formulas.
e.g.
I have a column with the following values
First 1
Second 2
Third 3
Fourth 4
Fifth 5
Total 15
Is there any way to put a formula in the total cell so that cells with bold text are not included,
e.g. to give the...
Hi,
I have something like the following series of data.
A Apples 5
b. Oranges 10
c. Pears 5
d. Oranges 5
e. Pears 10
f. Oranges 5
However, I want to create a chart so that it groups the data and represents it as follows.
Apples 5
Oranges 20
Pears 15
Is this possible with Excel...
Hi,
I have a bit of a problem with an Access query. I don't think the solution will be very complicated but I can't quiet figure it out. The easiest way to explain it is to give an example:
I have three tables July Usage, August Usage and September Usage,
There is only 2 fields in each table...
Hi,
I was just wondering if someone would be able to explain the difference between a dsn and dsnless connection using ADO and which one is better to use,
thanks,
Carol
Hi
I was hoping someone might be able to help me. I'm just getting started with all this and things are getting a bit confusing!!
What's the difference between a web server and a web application server and how do they interact with each other as well as with as with a database to produce a web...
Hi
I was hoping someone might be able to help me. I'm just getting started with all this and things are getting a bit confusing!!
What's the difference between a web server and a web application server and how do they interact with each other as well as with as with a database to produce a web...
Hi,
Just wondering if its possible to get td cells to wrap if they contain a link. I have been trying to get it to work but it seems to be counting the link as one word even though it is multiple words. is there any way around this without creating a separate link,
thanks,
Hi,
I have created a column with datatype NUMBER(3,8) but when I am inserting values I get an error saying:
"value larger than specified precision allows for this column"
The values I am inserting are not more than 3 figures to the left or 8 figures to the right of the decimal places...
Hi,
I have to pass a username and password as part of my querystring as follows:
http://server/report.rpt?user0=user&password0=password.
I know that there is some way that you can use the # symbol to hide the querystring but I can't figure out how.
If someone can help I would really...
Hi,
I want users to be able to download a .pqa file from my website so that when they click on a link they get the option to either open the file or save it to disk.
The only problem is I have no idea how to do it, so if someone could offer some advice I would really appreciate it!
thanks,
cm80
Hi,
I am getting the following error and I haven't got a clue why!
Microsoft VBScript runtime error '800a01a8'
Object required: 'True'
/bsci98/cmurphy/ResearchProject/weathertest.asp, line 41
line 41 is highlighted in red below.
If anyone can help I would really appreciate...
Hi,
I am getting the following error and I haven't got a clue why!
Microsoft VBScript runtime error '800a01a8'
Object required: 'True'
/bsci98/cmurphy/ResearchProject/weathertest.asp, line 41
line 41 is highlighted in red below.
If anyone can help I would really appreciate...
Hi,
I am new to XML and I was wondering if someone could give me a helping hand parsing an XML document with ASP.
I have the XML page loading into the ASP page fine, I just need a hand with referencing and formatting particular elements.
For example with the XML document below, what I want to...
Hi,
I am new to XML and I was wondering if someone could give me a helping hand parsing an XML document with ASP.
I have the XML page loading into the ASP page fine, I just need a hand with referencing and formatting particular elements.
For example with the XML document below, what I want to...
Hi,
I am using ASP to retrieve data from an Oracle database and printing the results in a textbox. However when the data I am retrieving is longer than 1 word only the first word is printed.
an example might explain a bit better!
<td>Address:</td>
<td><input type="text"...
Hi,
I want to parse an XML file using ASP and I have no idea where to start.
Does anyone have any pointers or know of any tutorials that would get me started,
thanks, any help would be appreciated,
Hi
I am developing an Oracle database and I am trying to grant another user on one of my tables but keep getting an error.
The syntax I am using is as follows:
GRANT SELECT ON tablename TO username [IDENTIFIED BY 'password']
I tried it without the square brackets and single quotes but that...
Hi
I am developing an Oracle database and I am trying to grant another user on one of my tables but keep getting an error.
The syntax I am using is as follows:
GRANT SELECT ON tablename TO username [IDENTIFIED BY 'password']
I tried it without the square brackets and single quotes but that...
Hi
I would apppreciate it if someone could show me the code to find the differrence between numbers adn then convert tht answer to a positive integer. Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.