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
Show actual values added instead of cell references? (=A1+A4 showsas =10+2 in cell) by Naji[_2_]
Is this even possible? I have the following: A1 =A2 (Shows result of 10) A2 10 A3 A4 =A5 (Shows Result of 2) A5 2
December 30th, 2009 12:39 AM
by Dave Peterson Go to last post
6 142
Complex 2 table formula by JD
Here are my two tables: Table 1 Column 1 Col 2 Col 3 Col 4 Col 5 Col 6 Col 7 Row 1 Slope Bands...
December 30th, 2009 12:35 AM
by JD Go to last post
5 111
Countif Formula by JKVA
I imagine this is a simple question, but I would like to do something like the formula below, but I would like to do it for a range within 15 minutes (+15 or...
December 29th, 2009 10:52 PM
by T. Valko Go to last post
3 105
Forms--Vista--2007 Excel by Lost in Excel
Hello, I am working on an Excel Worksheet, using it as a survey, and need to accomplish 3 tasks. 1.) I want the user to check, or place an "X" only one of...
December 29th, 2009 09:58 PM
by Lost in Excel Go to last post
2 118
Need Help by Cindy
I have a workbook containing the following tabs (sheets) Control upload audit lookup I am trying to figure out a formula that will do the following In the...
December 29th, 2009 09:54 PM
by Cindy Go to last post
4 94
How to insert the tab name in a cell by Kate Bj
Could anyone please tell how I add the tab name to a specifik cell in the excel shet.
December 29th, 2009 09:44 PM
by Terry Hamal Go to last post
3 124
Separating data by GeorgeHutch
I am currently sorting through endless data wich i only need a small part of it. the data looks like this below but 100 time as long and in a text file. ...
December 29th, 2009 09:06 PM
by Stefi Go to last post
6 83
change column to rows with a match by bill gras
I need a worksheet formula that can do this : data in columns: result: A B U V W X Y ...
December 29th, 2009 08:38 PM
by Max Go to last post
3 102
Auto calculating not working by Marcia
For the first time in 20 years of using Excel, I am finding that auto calculation is not taking place whenever I add new entries to a range of cells included...
December 29th, 2009 08:25 PM
by Fred Smith[_4_] Go to last post
4 94
Autosum returns zero balance - why? by MarcyC
Excel 2003 I've been adding both contiguous and non-contiguous numbers using the autosum function OR =c2+c5+c9 OR =SUM(c2,c5,c9) OR =SUM(a1:a50). In a few...
December 29th, 2009 06:44 PM
by MarcyC Go to last post
0 90
once only pop up by Phil
Hi there, I've created a message that comes up upon opening a worksheet template i've created that reminds the user to resave this workbook first before...
December 29th, 2009 06:12 PM
by Gord Dibben Go to last post
3 126
SUMIF with criteria being a specific cell by CSB
I want the criteria to be a designated cell, is that possible?
December 29th, 2009 05:17 PM
by Pete_UK Go to last post
2 96
Countifs in 2003 = _xlfn. ?? by Steve
I created some countifs in 2007, saved it down to 2003. When opened in 2003, in front of the countifs is: =_xlfn.COUNTIFS It showed correctly in 2003,...
(Multi-page thread 1 2)
December 29th, 2009 04:47 PM
by T. Valko Go to last post
12 170
Product Formula by Alan
Hi, I have a column of quarterly returns which I wish to calculate longer term returns from. My problem is that the list will continue to expand over time...
December 29th, 2009 03:48 PM
by ryguy7272 Go to last post
1 133
formula for excel sheet. by BVG
Hi, I want to use a formula in excel as below described. i want a formula value in Cell A2.b In Cell A1 is value say if it is $ 500 or above then the A2...
December 29th, 2009 03:04 PM
by David Biddulph Go to last post
5 89
-/+ forumla by gma
ok....i have a need for a forumla that will increase and decrease as the value in another cell goes up or down. i.e. A1 set number of 95 B1 number is 96 C1...
December 29th, 2009 02:54 PM
by gma Go to last post
4 81
Error with Copy function by diepvic
Hi, I'm trying to copy data from workbook A to workbook B. However, whenever I select workbook B, the Paste function is blur, which means I can not paste...
December 29th, 2009 12:12 PM
by diepvic Go to last post
0 84
In Excel can sheet tabs be placed along a side margin? by SuzieQ
Instead of having tables along the bottom of a sheet, I want to put them down the right hand margin. Is this possible in Excel?
December 29th, 2009 11:00 AM
by Mike H Go to last post
1 199
S- Curve Calculation and chart by vmohan1978
Dear All, I have to prepare S-curve for the Project with following informarion Project Duration : 30 Months Project Cost : 90,000,000 Note : I tried Total Cost...
December 29th, 2009 08:43 AM
by vmohan1978 Go to last post
3 100
Variable Pay-rate after 5pm by SchMattX
After 5pm employees get paid a different rate per hour. Currently 4 entries for time "in" and "out" before and after lunch. Need to have Excel determine...
December 29th, 2009 08:30 AM
by Bill Kuunders Go to last post
1 103
Post New Thread


Display Options
Showing threads 4301 to 4320 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 06:33 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.