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
Deleting Name from Name Box by Workbook
Is it possible to delete a name(s) from the name box once you have given a cell or group of cells a specific name? and if so could you tell me how I can do...
October 22nd, 2008 08:11 AM
by Joerg Mochikun Go to last post
5 60
Greatest Number by Workbook
In Cell B30, I would like to create an IF Statement that will give me the greatest number from the Cell Range B2:B29.
(Multi-page thread 1 2)
February 9th, 2009 04:34 AM
by Fred Smith[_4_] Go to last post
11 95
IF Statement Modifications by Workbook
Thank you TValko for this statement =IF(Sheet1!B7="H","JER",""). I am wondering can it be modified to include the 4 following variations so that if H, K, M,...
February 19th, 2009 02:55 PM
by Glenn[_6_] Go to last post
9 131
Long Formula by Workbook
I got some help earlier with an IF Statement which was very helpful from Mike H. The idea I am going for now is if I have the following ("Wireless...
February 19th, 2009 06:18 AM
by T. Valko Go to last post
1 133
VLOOKUP by Workbook
=VLOOKUP(B7,C4:D33,2,0), how can I modify this so that it works when B7 is on Sheet 1 but C4:D33 are on Sheet 2?
February 24th, 2009 04:35 AM
by Workbook Go to last post
4 93
Average Symbol by Workbook
I've been looking for a while for the average/mean symbol which is an "X" with a line over. To find it I went Insert/Symbols/ various Subsets such as...
March 18th, 2009 09:18 PM
by T. Valko Go to last post
8 63
Bullet Chart – Value Y Axis by Workbook
I got this link http://www.exceluser.com/explore/bullet.htm From Smartin. It’s a great link about how to create bullet charts. The question I have is...
March 24th, 2009 03:41 AM
by Workbook Go to last post
0 76
The One Formula by Workbook
I am using this formula =SUM(C4:C46) however I want to change it so that it counts any number in its range such as the number 2, 3, 4, 5, etc as a 1,...
March 28th, 2009 07:46 PM
by Workbook Go to last post
8 62
Horizontal bullet graph by Workbook
Can anyone tell me where I can find instructions for how to create a horizontal bullet graph that does not involve a paste picture link? I pasted some great...
March 29th, 2009 08:00 PM
by Workbook Go to last post
4 169
Making Blank Cells by Workbook
Cell K5 is linked to Cell H5, so that whatever gets entered in Cell H5 it will appear in Cell K5. However, sometimes H5 does not have any data in it and...
February 4th, 2009 02:25 PM
by Pete_UK Go to last post
4 87
Making a Cell Go Blank by Workbook
I want to modify this formula =IF(Sheet1!N2=241,1,""), so that if N2 is blank the cell containing this formula will become blank. I have tried variations...
February 8th, 2009 06:26 PM
by Workbook Go to last post
6 66
Schedule Worksheet by Workbook
In cell B2 I want to display a time. In cell D2 I want to display a time that is always 30 minutes later than the time displayed in cell B2. I want cell E2...
December 11th, 2008 02:37 AM
by Pete_UK Go to last post
7 120
Value Axis Adjustment by Workbook
I created a Gnatt Chart with 8 activities. The times on the values axis are listed as 3:50 AM, 4:19 AM, 5:16 AM, 6:14 AM, 6:43 AM, 7:12 AM, 7:40 AM, 8:09...
December 13th, 2008 12:32 PM
by Jarek Kujawa[_2_] Go to last post
1 88
Value Axis Adjustment by Workbook
Thank you Jarek. I followed your advice and I made the major unit on the Value (Y) axis scale 0.00347222222222222 to represent 5 min and it worked. I still...
December 14th, 2008 05:54 PM
by Workbook Go to last post
2 53
Subtracting Dates to Find the Difference in Hours by Workbook
I am trying to create a formula that will find the difference in hours between 1/9/2009 (I2) and 1/12/2009 (J2) in hours without including weekends. Bob...
January 31st, 2009 01:16 AM
by Workbook Go to last post
6 56
Drop Down Menu by Workbook
In cell A2 I want to put a drop down menu/box. In other words I want to be able to click on a downward arrow in cell A2 and then have the ability to select...
(Multi-page thread 1 2)
February 4th, 2009 05:00 AM
by T. Valko Go to last post
11 106
Greater Than 24 But Less Than 48 - If Statement by Workbook
I want a “1” to appear in cell N2 if in cell M2 I have greater than 24 but less than 48. This is the IF statement that I have so far in cell N2. ...
February 4th, 2009 03:05 AM
by Workbook Go to last post
4 86
Linked Cells – If Statement by Workbook
I am trying to set up an If Statement so that if Cell A2 has an 11 inside of it, whatever contents are in cell H2 will also appear in cell K2. This is the...
February 4th, 2009 02:52 AM
by Workbook Go to last post
2 43
Multiplying Empty Cells by Workbook
In cell N15, I am using this formula M15*24. However sometimes M15 is blank and when it is I get a message in cell N15 that says #VALUE!. Which throws off...
February 5th, 2009 12:29 AM
by T. Valko Go to last post
6 79
Column Width and Row Height by Workbook
What size should I make the column width if I want it to be equal to a row with a row height of 30? How did you figure that out?
March 30th, 2009 06:46 AM
by Jacob Skaria Go to last post
4 84
Post New Thread


Display Options
Showing threads 1161 to 1180 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:48 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.