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
Combining all tabs into 1 master w/o copy&paste by Webs
I am trying to combine all tabs(12) into one master sheet with out copy and pasting as it is a pain. Probably a simple thing, but not sure how to start.
March 6th, 2009 12:29 AM
by Ashish Mathur[_2_] Go to last post
1 154
SUMIF ERROR by webone
I'm getting an error on a SUMIF function. Any idea on how to correct this error? =SUMIF(D192,"25",E176*.0875) I'm trying to calculate a result in cell...
December 2nd, 2009 03:26 PM
by Teethless mama Go to last post
3 123
Line of Characters by [email protected]
I have cell A1 with a number, let's say 21 I need to find a way to automatically show 21 C's or B's or any character in cell A2 If A1 changes to 24 then A2...
June 17th, 2009 10:20 PM
by [email protected] Go to last post
2 209
Remove dashes between letters and between letters and digits by [email protected]
Can anyone help me with a script which can remove dashes between 2 letters and between a letter and a digit. But at the same time keeps the dash beween two...
March 5th, 2008 06:08 PM
by Bernie Deitrick Go to last post
7 78
IF Function by WebLord
I just need a refresher on how the IF function works with 3 variables. This is for calculating bonuses based on how many years of seniority an employee has. ...
March 23rd, 2006 02:09 AM
by WebLord Go to last post
5 77
Simple Question, Calculating Discounts by WebLord
Hello, I just have what I think is a simple question regarding calculating discounts with percentages. Sorry to bother you all with something so basic, but I...
March 17th, 2006 07:40 PM
by [email protected] Go to last post
3 63
$ vs time formula by Webitect
Hello, I am trying to track my time (I'm using a formula that takes the difference between start time and end time). Then I have a colum for $ earned. ...
March 1st, 2006 08:31 PM
by SteveG Go to last post
2 78
dollar amount versus Time by Webitect
Hello, Could anyone help me out with this? I have two columns, one calculates the amount of time spent from a "time in" column and a "time out" column. ...
March 4th, 2006 07:44 PM
by Peo Sjoblom Go to last post
2 110
How do you change a drop-down list in Excel? by Webgirl
I have an excel spreadsheet with drop lists for pick and choose what criteria I want entered in this column. I need to CHANGE the list (criteria) - how do I...
May 23rd, 2005 01:07 PM
by Webgirl Go to last post
2 83
how do you turn an email address list into an Excel csv or txt file? by Weber1
Hi, all--I'm a novice, so forgive me if this is a ridiculously simple question: I have an email list in Word that consists of email addresses, in which each...
May 8th, 2006 04:10 PM
by Weber1 Go to last post
5 76
Formula is entered but will not display result by webee33
This is elementary, I think, and I know it's happened to me before but I can't remember what the problem was. I have a simple formula: ='Different...
October 18th, 2005 12:16 AM
by paul Go to last post
2 82
Sumproduct if column begins with text by webee33
Hi. I've searched for half an hour to see if this question has already been answered, and I'm not having any luck. I have a detail sheet with multiple fields....
October 25th, 2005 09:26 PM
by Bob Phillips Go to last post
2 112
Excel 2000 worksheet is off centered for viewing by webdiva
I must have accidentally hit something, as all of a suddon, the worksheet shifted to the left and above the viewing area. I cannot see the row numbers or...
February 22nd, 2006 01:11 PM
by webdiva Go to last post
2 112
soduko by webby62
Is there a way of checking the whole nine boxes individually so that there are no two numbers the same in each box? i have done the rows and columns with...
(Multi-page thread 1 2)
July 7th, 2005 10:55 AM
by olasa Go to last post
10 283
Produce a financial sensitivity analysis graph in Excel 2007 by WebberD
Can anyone advise the steps involved to produce a sensitivity analysis graph in Excel 2007. The produced graph has lines that disect each other. I have...
June 1st, 2008 07:13 PM
by Mike Middleton Go to last post
1 98
how do I duplicate the Lotus 123 @rate function in Excel? by WEBB
Excel wants to give me the XIRR function, but that requires a specific data layout, which is not always appropriate. I want to calculate a Compounded Annual...
June 7th, 2009 01:41 PM
by Fred Smith[_4_] Go to last post
4 122
Adding one cell in Sheet 1 to another cell in Sheet 2 by Web Office Support
How can I add cells across multiple sheets? I need to add A3 (Sheet 1) to A6 (Sheet 2) and have the total appear in A31 (Sheet 1). Thanks!
June 5th, 2008 09:04 PM
by Web Office Support Go to last post
2 74
i want to display the month from a date into another cell by weazal5
i have to know how to display the month in "mmmm" form from another date in a new cell. So if the date is "23/4/05", i have to display "April"
April 26th, 2005 08:51 AM
by Niek Otten Go to last post
1 80
calculation order by Weaver Dean
Row x row, or col x col? Are all iterations performed on a cell before going to the next one? Excel 2003
March 7th, 2007 02:03 PM
by Niek Otten Go to last post
2 61
Min Function Excluding Zero Values & More by WeatherGuy
Disclaimer: My experience with and knowledge of Excel is very limited. I'm not sure if what I'd like to do can be done with a simple function or if I can...
January 1st, 2006 04:44 AM
by WeatherGuy Go to last post
8 266
Post New Thread


Display Options
Showing threads 2021 to 2040 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:35 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.