A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
conditional formating limits? by Todd
Can I put more than one if statement in a conditional format? I want it to turn a cells background yellow if one cell has data and either of the other two are...
November 13th, 2003 08:01 PM
by Mark Graesser Go to last post
2 341
sql.request help by Shutter
Hi there, I am trying to look up data from a local (win) mysql database from directly in a cell. The help files came up with the sql.request function. ...
November 13th, 2003 08:16 PM
by Chris Leonard Go to last post
3 92
Count # Workdays b/t two dates? by [email protected]
I can easily do this with the "NETWORKDAYS" function in the analysis toolpak, however not everyone on my distribution has this add-in. How can I count the...
November 13th, 2003 08:26 PM
by [email protected] Go to last post
0 170
unselect option button for printing by option button
Hi, please tell me how to unselect "Option Button" for printing (Office XP, Excel). thanks
November 13th, 2003 08:26 PM
by option button Go to last post
0 422
Formula text showing instead of result... by Yann St-Germain
Hi, I'm using Excel 2000 (9.0.6926 SP-3) and I have the following problem: I have the following formula in the cell B2: =SUBSTITUTE(A2, "blabla",...
November 13th, 2003 08:49 PM
by Gord Dibben Go to last post
7 366
Lookup for worksheet name by Anders S
Tom, One way: =3DINDIRECT("'"&A1&"'!B23") HTH Anders Silv=E9n "Snay" skrev i meddelandet =
November 13th, 2003 09:18 PM
by Gord Dibben Go to last post
2 146
hours x rate calculation by martin
I have a spreadsheet with two columns detailing hours worked, (i.e. from and to) and I have then two columns that convert the hours into a number format, and...
November 13th, 2003 09:28 PM
by martin Go to last post
0 525
Conditional Formating based on other cell values?? by Dan B
Is there a way to apply formatting to one cell based on the conditions of another cell? For example, if A1 is equal to 10 then format C1 to red text. Is...
November 13th, 2003 09:53 PM
by Dan B Go to last post
2 236
Adding months to a date by Christine Abbey
I know that you can type in = A2(being a date field)+ 45, and it will add 45 as the number of days and show the new date. Is there any way to add months?
November 13th, 2003 09:55 PM
by Dave R. Go to last post
1 384
Devide value by 0 or "" by Syd
How can I get a formula to show me the valid value in one cell if the other cell contains a zero. Example: Cell A1 = 26, cell A2 = 0 or "". Now to devide cell...
November 13th, 2003 10:09 PM
by Aladin Akyurek Go to last post
5 149
Count # Workdays b/t two dates? by Jason Morin
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(C1&":"&D1)),3)5)) where C1 holds start date and D1 holds end date. HTH Jason Atlanta, GA -----Original Message----- I...
November 13th, 2003 10:14 PM
by Jason Morin Go to last post
2 178
Referencing different workbooks by jimmy
I have two seperate workbooks that both contain information. One workbook contains a user key followed with other relevent information. The other...
November 13th, 2003 10:30 PM
by cmoore Go to last post
2 230
Open to a particular cell in a particular worksheet by Larry
I have a spreadsheet that had 10 worksheets. How would I tell it to open to the 10th worksheet in a particular cell. If I save it with my pointer in that...
November 13th, 2003 10:53 PM
by Ron de Bruin Go to last post
1 253
insufficient memory by John Nelson
When opening excel spreadsheets the system randomly will display the following message: "Microsoft excel cannot open or save any more documents because there...
November 13th, 2003 11:33 PM
by Jase Go to last post
2 275
Copy formula problem by AWilliams722
Hello, I have used Excel long enough to know that when you copy a formula and paste it into another, it should calculate the formula. It seems that I have to...
November 13th, 2003 11:37 PM
by AWilliams722 Go to last post
0 649
EXCEL by KEVIN
DOES ANYONE KNOW HOW TO GET A DATE FORMATTED TO MM/DD/YYYY WHEN IT COMES TO YOU AS AN UNFORMATTED FIELD AS FOLLOWS 20031202 (YYYYMMDD) THANKS KEVIN
November 13th, 2003 11:40 PM
by Harlan Grove Go to last post
3 110
My brain hurts... by John Croson
I have two worksheets, one is zipcode: A B C data zip state wi53202 =RIGHT(A2,5) =LEFT(A2,2) giving me: A ...
November 13th, 2003 11:50 PM
by John Croson Go to last post
3 231
Function to figure vacation accrual by Liz
Help!!! I currently have a vacation spreadsheet in which I need to create a column to show vacation accrual per month. Based on their length of service with...
November 14th, 2003 12:31 AM
by cmoore Go to last post
3 277
HELP - formatting issue when upgrading from XL97 TO XL2002 by BLUEC
we have page overflow and date format issues with excel macro. this macro generates about 20 pages of charts... 18 of 20 are printing on two pages when we run...
November 14th, 2003 01:42 AM
by BLUEC Go to last post
0 190
Moving to next row by Brian.
I know there's probably an easy answer to this, but in my Excel, if I enter data in several consecutive cells in a row, the enter key will then take me back to...
November 14th, 2003 01:59 AM
by Jason Morin Go to last post
3 88
Post New Thread


Display Options
Showing threads 2061 to 2080 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:01 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.