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
Counting number of characters in cell by saturnin02
Hi, I need a formula to return in cell A2 cell A1 if cell A1 has more than just one letter: "Bob" for example but if cell A1 only has letter "B" or is blank, I...
August 3rd, 2004 04:09 AM
by saturnin02 Go to last post
4 494
Excel Number Format Codes by MBB
I can't figure out how to format numbers so that when you type 3220 it will look like 32.20 kinda like how you can enter numbers on an adding machine. I would...
August 3rd, 2004 04:19 AM
by Myrna Larson Go to last post
3 415
A Turing Machine in Excel by George W. Cherry
I'm just learning my way around Excel. I'd like to see how to program a Turing Machine in Excel. I Googled: microsoft excel "turing machine" and got over 700...
August 3rd, 2004 04:38 AM
by George W. Cherry Go to last post
2 175
Worksheet alignment is out on pc by teddybis
I tried opening different workbooks on my PC and the alignment all seemed to 'overflow' from the A4 size setting. I had opened the same workbooks on a few...
August 3rd, 2004 06:30 AM
by Frank Kabel Go to last post
1 149
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
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
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
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
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
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
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
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
#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
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
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
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
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
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
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
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
Post New Thread


Display Options
Showing threads 2161 to 2180 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 12:14 AM.


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