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
How can I download and install ERROR FUNCTION in Excel 2003? ERF. by Zhiming Qi
How can I download and install ERROR FUNCTION in Excel 2003? ERF() is not available in my excel. Thanks much!
April 25th, 2005 01:15 PM
by Jerry W. Lewis Go to last post
2 395
sorting and matching in excel by zhen[_2_]
Hallo I have a problem to sort a data My questions is like this: 3546 4623 53 4623 9584 33 1294 3546 12 9584 1294 11
November 4th, 2009 01:30 PM
by Bernard Liengme[_2_] Go to last post
1 103
random ordering a list in excel by zhen[_2_]
Hi, everyone I am now facing a problem of random ordering a list of sentences in excel, I will be appreciate if anyone here can help me out. The context is...
January 28th, 2009 03:34 PM
by zhen[_2_] Go to last post
3 59
apply arithmetic functions on special multiple cells by Zhekka
Hey all I've searched in the group history and haven't found the exact answer for my problem. I have an array of cells, each cell is calculated from the...
February 10th, 2006 02:04 AM
by Bob Phillips Go to last post
5 218
how do I automatically hide or suppress zero balance rows by zhehol
I want to format my spreadsheet so that when an if/then formula returns a zero balance, the entire row is hidden or suppressed. Can this be done in Excel?
June 14th, 2006 03:43 AM
by JMB Go to last post
1 136
How to insert infinity symbol in excel? by Zhead
Does anyone know an Alt key combination to enter the infinity symbol?
July 16th, 2009 06:41 PM
by Zhead Go to last post
2 122
Match by Zhead
In coloumn A some cells contain "Y" coloumn F also has cells that contain a "Y" i would like to know how to sum which same rows in A and F contain "Y"
July 16th, 2009 06:54 PM
by Zhead Go to last post
4 94
How to update multiple worksheets by Zhead
I havean Original sheet that i update. i want to create an Open worksheet and a Close worksheet. When i change the Status on the orignal to open or close i...
August 19th, 2009 01:23 PM
by Eduardo Go to last post
1 88
November 14th, 2005 06:18 AM
by Biff Go to last post
1 142
HOW DO I GET A BALANCE TO C/FORWARD TO NEXT WORKSHEET by zhandra
I know how to set up a balance sheet but would like to carry forward some information to the next worksheet but without using copy - almost like an automatic...
September 12th, 2006 11:29 AM
by Allllen Go to last post
1 60
list of values include old non valid data by zeyad alhekail
I create a pivot table by connecting to a table on SQL server DB. it works OK , say that we have a product number in the table. when we click on the list of...
October 16th, 2003 12:17 AM
by Debra Dalgleish Go to last post
1 369
add, multiply then divide by Zetman
Hi All, I am not a regular user as you will certainly tell of Excel, but am trying to come up with a worksheet for our company that computes how long it takes...
February 24th, 2006 02:40 AM
by Fred Smith Go to last post
3 144
Sum Duplicates in Groups by Zesty
I have a file that has quantity and codes. Each code has an amount, but they are different amounts and the code duplicates many times. I need a formula that...
October 16th, 2009 03:40 AM
by Ashish Mathur[_2_] Go to last post
2 99
Sum Duplicates without Sorting by Zesty
I have a file that has quantity and codes. Each code has an amount, but they are different amounts and the code duplicates many times. I need a formula that...
October 16th, 2009 12:00 AM
by Herbert Seidenberg Go to last post
3 101
Need help with this by [email protected]
Prepare a plot that shows the distribution of noise in the raw DMA data set. To do this, you will need to establish a set of bins to accumulate the number of...
September 11th, 2006 04:35 AM
by Joerg Go to last post
1 68
Text Time Conversion Calculation by ZeroWayCool
Hi Guys I am having trouble with this one and it is slightly different and trickier than the normal time arithmatic. Part 1 In Cell R2 I have a value...
April 1st, 2006 04:17 PM
by davesexcel Go to last post
4 138
Determine year over year date for comparison by zeroscou
Hello, I am trying to determine the date of the same Monday last year based on the date of the latest Monday's date. If I just subtract 364 from the current...
March 6th, 2009 10:01 PM
by Mike H Go to last post
3 47
How to use AUTOFILTER to update FREQUENCY distribution by zerocred
I have the following data and have created the FREQUENCY distribution below it. Ideally, what I want is to be able to see the frequency distribution and use...
December 12th, 2008 11:07 AM
by zerocred Go to last post
7 70
Simple formula help by zero
Hi I need a simple fórmula that takes a value from a cell (A1 would be fine) and put a value to other Cell (A2 it's ok) considering what this number is, and...
June 22nd, 2005 01:02 AM
by CLR Go to last post
2 96
Simple formula help by zero
Hi I need a simple fórmula that takes a value from a cell (A1 would be fine) and put a value to other Cell (A2 it's ok) considering what this number is, and...
June 22nd, 2005 11:07 AM
by CLR Go to last post
3 143
Post New Thread


Display Options
Showing threads 261 to 280 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 10:31 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.