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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
referencing by zuapfly
hi, i'm making a calculating worksheet that uses different files... because i use the same formula often in a larger formula, i put the returning formula in...
August 4th, 2004 01:06 AM
by Dave Peterson Go to last post
4 162
displaying sales order equal to user input by avilla
:HI can anyone help this beginner???? I have a worksheet that hold sales for one of our company depots for the year todate. There are over 1000 sales and i...
August 4th, 2004 01:05 AM
by Dave Peterson Go to last post
3 197
Marco with autofilter by avilla
Hi can anybody help I have used the following code to enter a specific date in an inputbox that looks at the autofilter column and displays the result...
August 4th, 2004 01:00 AM
by Dave Peterson Go to last post
4 239
borders? by jkb724
Is there any way to have a border set for every page in my workbook. Just so that the page is outlined and looks more put together? Thanks --- Message...
August 4th, 2004 12:14 AM
by Earl Kiosterud Go to last post
1 135
funcres.xla by Fritzj
When openning excel, I now get a message that funcres.xla is not in right place or gone. What do I do? It did not use to do this.
August 4th, 2004 12:09 AM
by Norman Harker Go to last post
3 208
Happy Face Graph ... Is it possible? by Ken
Excel 2000 ... Is it possible to create a "HAPPY FACE" Graph where the Face would incrementally turn from a "SAD" Face to a "HAPPY" Face as Customer...
August 3rd, 2004 11:51 PM
by Debra Dalgleish Go to last post
5 271
if color then formula in cell by Jonsson
Hi, Can anyone help me to write a code that says: IF text in cell B4=red, choose formula in cell C4 IF text in cell B4=black, choose formula in cell D4 IF...
August 3rd, 2004 11:10 PM
by Bob Phillips Go to last post
4 339
Always negitive by HessInAMess
is there a way to tell excel to always make any numbers in a cell negitive? even when the number wasn't entered with a - sign? I've been trying to use the...
August 3rd, 2004 09:40 PM
by HessInAMess Go to last post
2 157
Print Rows at Top only on some pages by S.J. Ring
I have a spreadsheet which contains two types of data, a total of 12 pages. The first 10 pages are formatted identically and when setting the print ranges I...
August 3rd, 2004 09:04 PM
by S J Ring Go to last post
2 472
Too many different cell formats by André Martins
I have one worksheet with this problem but in despite of=20 doing a lot of modifications, some time after the problem=20 is still happens. Someone know how can...
August 3rd, 2004 07:47 PM
by Frank Kabel Go to last post
1 193
Results of a formula to be Number instead of formula by dlanden
Can someone tell me if it is possible to have the results of a formula to be a number instead of the actual formula? I am trying to take the results of...
August 3rd, 2004 05:04 PM
by Frank Kabel Go to last post
1 284
#NUM! error by Richard
Whats wrong. {=SUM((Sheet1!A:A="*")*(Sheet1!B:B="\\\\\\CC\\\\\\") *Sheet1!E:E)} thanks in advance
(Multi-page thread 1 2)
August 3rd, 2004 04:50 PM
by RagDyeR Go to last post
12 318
Auto fill cells with dates, exclude weekends? by Sam Weber
What I'm doing is filling in multiple cells with dates (by dragging and filling) automatically. I was wondering if there was anyway for it to skip the weekends...
August 3rd, 2004 04:31 PM
by JE McGimpsey Go to last post
3 433
Can't open files on a network share by double-clicking by centrevilleanne
I can't open Excel files located on a network share by double-clicking on them. I can, however open them by browsing to them (File, Open, browse). I think it...
August 3rd, 2004 04:29 PM
by centrevilleanne Go to last post
2 354
alternative to INDIRECT reference by Nornny
Hi everyone, I have a really big Excel workbook with hundreds of INDIRECT references to other sheets within the workbook. That is the ONLY type of INDIRECT...
August 3rd, 2004 03:40 PM
by Nornny Go to last post
3 239
converting dates by rexmann
Hi All I have a couple of excel problems to do with dates (Excel XP/2002). I have a formula that displays one date minus another and displays the answer as...
August 3rd, 2004 03:34 PM
by Norman Harker Go to last post
4 358
Text format by Me
Hy, I have an text how looks like this: "AA-BB CC-dd". I want to select the text until the "-dd", so the result would be "AA-BB CC". So the text until "-"...
(Multi-page thread 1 2)
August 3rd, 2004 11:21 AM
by Leo Heuser Go to last post
10 212
using countif() to parse string by tivarney
I am trying to use countif() to parse a cell which contains a string. For example, the string could be "This is the example string." Can I use the countif()...
August 3rd, 2004 08:13 AM
by JulieD Go to last post
3 171
COUNT: Counting the number of times "X" comes up after the occurrence of "Y" by DrSues02
I am having trouble with the count function and setting it up to work in my spreadsheet. Basically, I want to count the number of times that X comes up in...
August 3rd, 2004 06:35 AM
by Frank Kabel Go to last post
5 483
Use defined names in VBA? by JRocket02
Hi all Any way to have Excel generate links or dimension variables so that VBA can use the defined names on the spreadsheet (menu: insert name define)? ...
August 3rd, 2004 06:31 AM
by Frank Kabel Go to last post
1 163
Post New Thread


Display Options
Showing threads 137581 to 137600 of 139764
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 03:09 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.