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 : New Users Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
View Duplicate entries by Ruan
Frank, That formula work great, but when you are tagging duplicates where the range has formulas in them, then the formula ends up getting tagged as a...
April 27th, 2004 07:56 PM
by Frank Kabel Go to last post
3 638
Finding Minimum value by Ruan
Hello, I know the formula for finding the minimum value in a range is =MIN(G7:G31) But how do you find the minimum value and ignore all the 0...
April 27th, 2004 08:50 PM
by Ruan Go to last post
4 512
Please help, I know nothing by amme
I am a very new at this and it is driving me crazy. For example, I want to add all of column A + column B and I want the answer to go in C. I want this action...
April 27th, 2004 08:59 PM
by David McRitchie Go to last post
4 444
April 28th, 2004 11:00 AM
by Marin Kostov Go to last post
2 331
auto updating a worksheet by erika
i am trying to update info in a worksheet and i simply don't know how. okay say for instance i have a grocery list that displays the product,price,how many and...
April 28th, 2004 01:59 PM
by Lady Layla Go to last post
2 517
cannot print certain row of sentence. by dave ong
hi, I am using Windows 98 SE, and also MS Excel 2000. I have a problem when some of the row cannot print out, while the sentence before and after the row can...
April 28th, 2004 02:19 PM
by BrianB Go to last post
1 388
excel '97 freezing up on xp by Ivan
Is Excel '97 supposed to work with Windows XP. Ever since I've had my new computer with XP, my excel '97 is very buggy. Almost every time I make up even the...
April 28th, 2004 02:24 PM
by BrianB Go to last post
2 477
auto numbering 1,2,3,... by Richard
I tried ctrl drag and got nothing. I could have typed them in by now but I would learn nothing THX!
April 28th, 2004 05:00 PM
by Gord Dibben Go to last post
3 348
"tip" sheet by Pete
Does anyone know if Microsoft offers (for purchase) a laminated "Tip" sheet showing commonly used functions, formatting, etc? I know they offer one for...
April 28th, 2004 06:05 PM
by Debra Dalgleish Go to last post
3 743
As I type in the Formula Bar it blinks by daniel
I work with Excell 2002 and as I type in the Formula Bar it blinks and trembles. The problem gets worse as the text becomes longer. That makes it impossible to...
April 28th, 2004 07:58 PM
by Anne Troy Go to last post
1 492
April 28th, 2004 09:20 PM
by David McRitchie Go to last post
2 742
Changing the default value for an empty cell by Jimbo
I'm reposting my oroginal post as I made a mistake and indicated a empty cell has a value of a one when it it is actually a zero. Since the number inputted in...
April 28th, 2004 09:31 PM
by Jiombo Go to last post
2 554
Designing a question paper by Ken
Could anyone please help. I am relatively new to Excel and am trying to design a question paper where the student has to fill in the answer box. What I would...
April 28th, 2004 10:13 PM
by Ken Go to last post
2 1,037
copy a formula by Mark Kennedy
I want to copy formulas without changing the cell references and not relative without the $ signs. Example: In C1 I have =A1+B1 (actually mine is complex). I...
April 29th, 2004 05:03 AM
by R.VENKATARAMAN Go to last post
4 352
counting rows by ed
I suspect this is relatively easy but I'm not sure how to accomplish this. Is there a way to count the "non blank rows" in a specific column. We need to know...
April 29th, 2004 08:56 AM
by JudithJubilee Go to last post
1 437
Function problem by Nigel Heald
Hi I am trying in vain to find a function within Excel 2003 that will enable us to calculate the monthly investment required to achieve a given amount after X...
April 29th, 2004 09:08 AM
by JE McGimpsey Go to last post
1 425
Toggling between multiple notebook windows by Jim
I have been a user of QuattroPro for ten years, and I am just now trying to convert everything over to Excel. In QPW, when I have multiple notebooks (files)...
April 29th, 2004 08:07 PM
by SidBord Go to last post
5 464
A challenge for you? Querying one sheet against another by Ian Usher
First thing I should point out is: I don't have access to Access therefore Excel is my only route towards what I'm looking for, which is... I need to compare...
April 29th, 2004 09:00 PM
by Dick Kusleika Go to last post
2 384
finding double payments by Monique
Imagine an excel file with two collumns, the first one contains the vendor number, the second one the payment amount. The excel file contains all payments made...
April 29th, 2004 10:43 PM
by Dave R. Go to last post
1 438
formula to caculate an age by Gayle
I am needing a formula that would figure out the age in years and months of a specfic person. For example Date of Birth is 7/27/1999 and the date is 10/23/2004...
April 30th, 2004 12:30 AM
by Gord Dibben Go to last post
1 389
Post New Thread


Display Options
Showing threads 21 to 40 of 13737
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 01:53 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.