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
spreadsheet question by koxo12
I have conected 3 sheets but if I change something in one sheet other two will change only if I open them. Can I update other sheets without opening them?
September 16th, 2003 08:18 PM
by Richard O. Neville Go to last post
1 338
Macro to add cell value to refering cells formula by Todd
Hi, I am trying to build a macro that adds 1 months depreciation to a cell everytime it runs. = 7.85 + 7.85 + 7.85 is how the result should look. Something...
September 16th, 2003 08:14 PM
by Todd Go to last post
1 489
Formulas not automatic by Jessica
I have some formulas that I have dragged down from other cells and they do not automatically calculate. What I mean by that is the formula is based on the...
September 16th, 2003 08:11 PM
by Ken Wright Go to last post
1 289
View problems by Lynn
I have a worksheet created by another user that I am working with. My view of the file is in black and white only and none of the cell colors are displaying. ...
September 16th, 2003 07:51 PM
by Ken Wright Go to last post
2 370
date f(x) by briank
I am trying to automate an average function. At the present I am trying to average six columns. Next month there will be new data and thus the average range...
September 16th, 2003 07:51 PM
by Ken Wright Go to last post
2 298
Bullet Points by Sean
How do you add bulet points in a cell?
September 16th, 2003 07:47 PM
by Peo Sjoblom Go to last post
1 473
Worksheet updates by cherri isbell
Is it possible to have one worksheet automatically update a master worksheet?? I have 8 worksheets, and I have one master worksheet. When I make changes to...
September 16th, 2003 07:35 PM
by Sandi Go to last post
1 461
Excel text converted to Number or other by jonkaleb
when converting from text to number or general how do you mass update the column instead of double clicking then enter
September 16th, 2003 07:09 PM
by Ken Wright Go to last post
2 298
calculating with displayed values by Tobit
I have two cells, each displaying numbers to with 2 decimal points Cell A1 contains the number 15.333333333 (the figure the result of a calculation) Cell A2...
September 16th, 2003 06:57 PM
by King Go to last post
9 441
Pivot table update by aablank
I have a number of pivot tables based on the same data worksheet. Right now when I add more data, I have to go to each table and update the range manually. ...
September 16th, 2003 06:46 PM
by aablank Go to last post
3 463
Choice and effect by Gerry Kuta
From within A1 which contains the text Area 1;Area 2;Area 3; Area 4 I'd like C1 to display Area 1 if in B1 I enter 1. (Area 2 on entry of 2 in B1 etc.) From...
September 16th, 2003 06:36 PM
by J.E. McGimpsey Go to last post
1 334
Entering numbers by Jorr
I'm entering long numbers on an Excel 2000 spreadsheet in a cell set for number format. When I enter a long number, such as a credit card number (16 digits)...
September 16th, 2003 05:25 PM
by FBC Go to last post
1 423
If value is greater than, then.... by Robert
Hi, I am trying to create a formula. Column A has a number Column B is a sum of A*1,2 only if A is over 100 otherwise B=A Logic: If A1100 then B1=(A1*1,2);...
September 16th, 2003 05:00 PM
by Harald Staff Go to last post
5 283
Newbee show cell address by Microsoft Newsgroups
I am having difficulty tranfering from C to VB. How can I assign, pss, or MsgBox the string address of a particular cell. If I use Dim cellref as...
September 16th, 2003 04:57 PM
by Harald Staff Go to last post
2 385
Index & Match by Greg Malenky
excel 2000 I am having trouble finding the proper function to arrive at the following answer for this table: employee store john store1 dave ...
September 16th, 2003 04:55 PM
by Greg Malenky Go to last post
2 617
IF cell contents = ????? by HeatherM
I want to count the instances of each value in a column with various references in it(a mixture of text entries and number entries). I would normally put an IF...
September 16th, 2003 04:18 PM
by Ed Lisay Go to last post
1 622
Pop up function ??? by MsSwiss
I am creating an excel document that several people will use. I am using a pivot table in one of the sheets and I would like to have a pop up or a callout that...
September 16th, 2003 04:18 PM
by Andy B Go to last post
2 304
Lookup question by FBC
I'm trying to compile a database based on info from another databse. I would like to take only the rows that contain a certain value in a cell to make the...
September 16th, 2003 03:52 PM
by Andy Brown Go to last post
1 266
Pivot table - formatting by akk
Hi Anon, That option was ticked. Despite that, the formatting changes. -----Original Message----- "akk" wrote in...
September 16th, 2003 03:35 PM
by akk Go to last post
0 459
crore formatting by kaushik
I want to format a range of cell/ a entire column in crore format i.e 1,00,00,000.00 and also want to sum that entire column. I tried it with "fotmat cell"...
September 16th, 2003 03:07 PM
by J.E. McGimpsey Go to last post
1 286
Post New Thread


Display Options
Showing threads 87681 to 87700 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 01:04 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.