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
Sumif cell has a boarder by
Hi, I have a spreadsheet with a column that has cells with totals and cells with just numerical data. Each cell that I want to total has a boarder around it....
October 20th, 2003 03:08 PM
by Don Guillett Go to last post
2 115
MORE XIRR vs. IRR help by
I had posted this yesterday and did not recieve a response - I included prior questions for reference... What I'm trying to do is use the most accurate...
June 8th, 2004 06:48 PM
by Go to last post
2 552
please help with formula by
I tried the following formula and I should be receiving a result of 0 because I7 has "(001234)" in it, not "(00140)". For the record, K21 is greater than...
June 9th, 2004 04:20 PM
by Michael Malinsky Go to last post
1 51
Returning a Value by
I had two spreadsheets. The first contains two columns of data, and on the second I wish to set up an equation (no macros or sorts) so that when I type in a...
June 12th, 2004 02:00 PM
by JulieD Go to last post
6 60
multiple sheets by
is it possible to copy a section (example A5:M9)of sheet 1 that each cell has a different formula and paste the cell values to a spreadsheet on sheet 2?
July 13th, 2004 01:50 AM
by Nimit Mehta Go to last post
4 82
List by
Hello, I am trying to create a list in a cell that references a name range on another sheet. The only way I know how to create a list currently is to...
July 13th, 2004 07:21 PM
by Go to last post
2 69
Index headache by
I'm using the folowing formula to locate a specific cell and return the value in that cell based on matching 2 different values to values in cells to the side...
July 16th, 2004 01:07 PM
by Arun Jhalani Go to last post
2 71
calculate Score by function by
what should I have to do if i want to give score 5 at 1000 and with every increase or decrease of 25 in 1000 .25 should be added in 5 or subtracted...
July 19th, 2004 12:35 PM
by Frank Kabel Go to last post
1 60
Custom Function & Personal.XLS by
Excel 2000 SR1, Win2kPro Using a custom function works fine if the module is in my current workbook, but when I move the function to the module in my...
July 30th, 2004 07:04 AM
by Frank Kabel Go to last post
1 104
What function to use - Counting numbers that meet a criteria?? by
Use the SUMIF function. This allows you to look in one colmn for a specified entry and sum a second column corresponding to the specified...
May 17th, 2004 03:58 PM
by Go to last post
0 64
column comparision counting. by
I have a spreadsheet that i need to compare columns. in column a is the lookup value. in column b,c and d is data to compare to column a i want to compare...
April 19th, 2004 10:27 PM
by Frank Kabel Go to last post
7 215
delete alternate columns... by
Need a macro/function that'll delete every other column. THX Scottie
November 17th, 2003 02:39 AM
by Scottie Go to last post
5 77
Problem with indirect from cell on external worksheet by
I am having a problem indirectly addressing a cell on a second worksheet (that is open). I found this article and when I tried the example it did now work...
November 17th, 2003 09:09 PM
by Harlan Grove Go to last post
4 75
editing chart source data by
NO more new fonts may be applied to this workbook
November 18th, 2003 05:00 PM
by Jim Go to last post
1 79
workdays by
i searched the archives but and I know its there but couldent find it. I need to only include only workdays in my formula (m-f)
December 16th, 2003 08:28 PM
by Go to last post
1 58
How to Build an External Link Using Data from Cells by
I want to import data in a cell from an external spreadsheet located at 'C:\Data\MySheet!$H$5. I want to build it using cells from the current worksheet such...
January 20th, 2004 12:25 AM
by Harlan Grove Go to last post
2 265
my arrow keys!!!! by
my arrow keys are shifting my entire workbook columns/rows instead of just moving from cell to cell! how do i fix this?
January 20th, 2004 02:19 AM
by RagDyer Go to last post
2 143
Need Help WIth a Function by
I am Trying to create a Weekly Time schedule for my business. I have to deduct a half hour from each shift if more than five hours are worked. i want the...
February 2nd, 2004 10:31 AM
by Frank Kabel Go to last post
3 73
AUTO ADDITION by
I AM LOOKING FOR A WAY TO HAVE EXCEL AUTOMATICALLY DO SOME MATH FOR ME. FOR EXAMPLE, IF I TYPE 25 IN CELL B4, I WANT IT TO AUTOMATICALLY ADD 25 TO IT. ANY...
March 11th, 2004 06:07 PM
by Bernie Deitrick Go to last post
4 88
Change printer Macro by
I tried the below formula and it doesn't work properly. It's a macro. What I would like to do is print certain worksheets within a workbook on...
August 3rd, 2004 03:05 AM
by Dave Peterson Go to last post
1 101
Post New Thread


Display Options
Showing threads 181 to 200 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 05:34 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.