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 Reverse Sort Order Last Post Replies Views
Global Warming and what you can do to against it by ..[_2_]
Dear All, As you know global warming is endangering the future of life on the planet. It will also affect us; rising sea levels, dwindling water supplies, mass...
May 9th, 2010 09:38 PM
by ..[_2_] Go to last post
0 96
possible to have =now() at data entry and not update after that? by .:mmac:.
How can I set a cell to contain the =NOW() date only once when data is entered in the adjacent cells and not have it update after that? Right now I copy from a...
February 5th, 2005 01:43 AM
by Peo Sjoblom Go to last post
5 119
Formulas dont uppdate automaticly? by //R \(Swe\)
I have a cell M95 wich contains this formula =K95/L95*100 I writes numbers in the cells but on some PC's it dont do the calculating. WHY? There is same...
June 24th, 2004 09:37 AM
by Andy B Go to last post
1 88
No showing of cellnumbers used in formular with colour by /Maria
Hi experts! I have a problem with creating a formular in one worksheet and letting numbers from cells in another worksheet be used in the formular. Normally I...
June 3rd, 2005 12:52 PM
by Hopest Go to last post
5 85
Any function for Crop/Cut Text by 0-0 Wai Wai ^-^
Hi. How can I do the following: - crop text from the left eg: CropText(A1, Crop3WordFromLeft) - crop text from the middle - crop text from the right - crop...
September 8th, 2005 01:29 PM
by Bernie Deitrick Go to last post
1 93
Start & End of the data series by 0-0 Wai Wai ^-^
Is it possible to do the following: When I paste this formula beside the data series, it detects: - the upper & leftmost cell as the start of the data...
June 27th, 2006 01:48 PM
by 0-0 Wai Wai ^-^ Go to last post
0 59
Conditional Formula - calculate only if net unit is zero by 0-0 Wai Wai ^-^
Here's the table for one game Date-----Buy(Unit)-----Sell(Unit)-----Net...
June 28th, 2006 11:07 AM
by Bob Phillips Go to last post
8 122
Variable Cell Reference by 0-0 Wai Wai ^-^
Hi. I have forumlas which reference to a lot of cells, eg: =...A1, ...A1, ... A1+A$2-$A3... ....B1, ...B1, ...B1+B$2-$B3... .... ... .... ... Is it possible...
June 27th, 2006 07:05 PM
by 0-0 Wai Wai ^-^ Go to last post
2 89
Variable Cell Referencing by 0-0 Wai Wai ^-^
Hi. I have forumlas which reference to a lot of cells, eg: =...A1, ...A1, ... A1+A$2-$A3... ....B1, ...B1, ...B1+B$2-$B3... .... ... .... ... Is it possible...
June 16th, 2006 09:34 AM
by [email protected] Go to last post
3 91
vlookup with variable col_index_num by 0-0 Wai Wai ^-^
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) Since my table is subject to constant change, I would like to know how to create a variable...
May 16th, 2006 06:15 PM
by Bob Phillips Go to last post
2 185
If's conditions about matching by 0-0 Wai Wai ^-^
How can I code these if's conditions: 1) If the first letter of the statement is "A" or number "2" 2) If the second word of the statement is "join" or...
May 12th, 2006 06:27 PM
by Biff Go to last post
8 93
Extract information from the list by 0-0 Wai Wai ^-^
Hi. I think it's going to be difficult to satisfy my requests. Anyway, I have a list of symbols in column A like the following: 00001 = xxx (it refers...
May 12th, 2006 11:57 AM
by 0-0 Wai Wai ^-^ Go to last post
3 115
Invalid Formula with the use of Indirect by 0-0 Wai Wai ^-^
Hi. I'm not sure why it causes the error. The formula is: =VLOOKUP(A1, INDIRECT($C$15), 2, 1) =VLOOKUP(A2, INDIRECT($C$15), 2, 1) =VLOOKUP(A3,...
April 23rd, 2006 04:14 PM
by 0-0 Wai Wai ^-^ Go to last post
5 146
If the cell contains..., do something (2) by 0-0 Wai Wai ^-^
Hi. Here's my original question: 1) How to do the following: a) If the cell starts with "senior", do something... (eg count that cell if the cell starts with...
April 2nd, 2006 05:11 AM
by 0-0 Wai Wai ^-^ Go to last post
6 95
1 Attachment(s) Advanced Lookup (lookup for 2 values) by 0-0 Wai Wai ^-^
Hi. I have a worksheet which contains Risk Level & Profit Level. Row A contains risk number. Column A contains Profit number. Different risk number & profit...
March 30th, 2006 07:09 PM
by 0-0 Wai Wai ^-^ Go to last post
2 77
If the cell contains..., do something by 0-0 Wai Wai ^-^
If the cell contains..., do something Hi. 1) How to do the following: a) If the cell starts with "senior", do something... (eg count that cell if the cell...
March 25th, 2006 10:34 PM
by 0-0 Wai Wai ^-^ Go to last post
5 75
countif - Criterion1 OR [Criterion2 AND Criterion3] by 0-0 Wai Wai ^-^
I wish to do the following: =countif(TargetCell or TargetCells, Criterion1 OR ) eg: =countif(A1, Criterion1 OR ) eg: =countif(A1:A10, Criterion1 OR ) How to...
September 8th, 2005 05:16 PM
by Harlan Grove Go to last post
3 88
Insert manual line break in formula by 0-0 Wai Wai ^-^
Hi I have a formula which combines texts from several sources. Eg: ="I am a "&A30&". You are a "&A31&". However we don't "&A32&", nor "&A33&". Except that, we...
September 8th, 2005 12:03 PM
by Roger Govier Go to last post
1 101
Extract each item in the list by 0-0 Wai Wai ^-^
Hi. The cell A1 contains: Here's the shopping list: pig, dog, hamburger, chocolate..., beef. Please purchase all of them. Thanks! I would like to extract each...
September 8th, 2005 12:50 PM
by Stefi Go to last post
2 150
Take fraction out of the figure by 0-0 Wai Wai ^-^
Hi. I would like to extract the fraction part out of a number. For example: 1.5 - 0.5 23.45 - 0.45 25 - 0 Is there any simple way to do it? Thank you. --
April 23rd, 2006 09:03 AM
by 0-0 Wai Wai ^-^ Go to last post
3 83
Post New Thread


Display Options
Showing threads 381 to 400 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 12:00 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.