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
Can I reduce (101.25) to only what's *right* of decimal? (25) by jay45940
Can I reduce (101.25) to only what's *right* of decimal? (25) Is there a function or a series of steps to accomplish this within an excel spreadsheet?
September 18th, 2008 08:10 PM
by Harlan Grove[_2_] Go to last post
2 95
SumProduct with Date Range and One Condition that is Text by Iona
Hello to all of you Excel Experts, HELP, pretty please. I have 2 formulas I am trying to combine. I had to break them out, to try and troubleshoot my...
September 18th, 2008 07:37 PM
by T. Valko Go to last post
4 139
Excel Worksheet functions by IOW
how do I modify an excel worksheet designed by someone else
September 18th, 2008 07:21 PM
by Spiky Go to last post
5 99
sum a range based on criteria in rowdata and column name by L Davis
Suppose I have some data that looks something like: A B C D E F G H 1 Category Site ...
September 18th, 2008 07:14 PM
by L Davis Go to last post
5 134
Frequency of Serial Number by Andri
Dear All, Please help. I have the database as the following: PartNumber SerialNumber 2117180-2 17-1162 2117180-2 ...
September 18th, 2008 07:10 PM
by Spiky Go to last post
1 110
Number of days in a quarter between two date ranges by Mike
I am trying to develop a table that will split a cost over quarters. The data that I have is: A B C D ...
September 18th, 2008 06:48 PM
by Bernd P Go to last post
3 121
Decimals on a date calculation by DianeG
I'm calculating dates using the formula b6-c6/365.25 and get an answer like 3.31 what does the .31 refer to? Is it nearly a third of a year i.e 4 months? ...
September 18th, 2008 06:43 PM
by DianeG Go to last post
5 84
Hyperlink not staying Active by Susan
Hello, I just upgraded to 2007 and can no longer hyperlink to sheets in the same book more than once. My first sheet is a key/index to all the other sheets...
September 18th, 2008 06:07 PM
by Susan Go to last post
0 382
Use horizontal lookup with pivot table by Gerardo
hello, I set up a graph that contains one series from a given range and two series from a pivot table. The data is filtered by the pivot table by month (1...
September 18th, 2008 06:00 PM
by Gerardo Go to last post
0 69
SUMPRODUCT, SUMIF, COUNTIF for multiple sheets for multiple criter by Greg in CO[_2_]
Hi All! This is a follow-up with more information to an earlier posting, where I got asome great help from the folks here. I have a workbook with many...
September 18th, 2008 05:51 PM
by Greg in CO[_2_] Go to last post
0 78
linking rows by Claire
i need to link numerous pairs of rows in my spreadsheet so they stay connected when i sort. when i try to do this by "group"ing, if i have 2 sets of 2 that...
September 18th, 2008 05:38 PM
by Pete_UK Go to last post
1 89
I am getting formula displayed in some cells rather than the resul by GG
For random individual cells within one worksheet. I can't find where you tell at the individual cell level to display formula or result. V....
September 18th, 2008 05:32 PM
by Niek Otten Go to last post
2 91
Import a "custom list" from another user by Chet
Does anyone know a way to import a "custom sort list" from another person's computer without manually doing it? Possibly some type of export then import...
September 18th, 2008 05:29 PM
by Chet Go to last post
0 80
Attempting to Copy a IF Function by Andrew Holzman
I need to know how to cascade a IF formula down that will only change the first value of the Logical Test and will leave the true and false statements...
September 18th, 2008 05:10 PM
by T. Valko Go to last post
3 84
Initiate a trigger for clearing a list of check boxes? by JGarland
I have a spreadsheet with a column of check boxes and I want to establish a trigger to either check or uncheck all boxes at one time.
September 18th, 2008 04:36 PM
by Joel Go to last post
1 99
export from 07 excel to outlook contacts by Bluedee
I have an 07 excel spreadsheet with staff names, telephone numbers and e-mail addresses that I have to upload to another program. Can I exp[ort this...
September 18th, 2008 04:36 PM
by Bluedee Go to last post
0 125
text as a number by Wiktor
I would like to count number in column between B4 and B15 for example. But i want count only cells B witch they has adjoining cells C with wroten text...
September 18th, 2008 04:04 PM
by David Biddulph Go to last post
5 134
Pivot table updation by Velu
How to refresh the pivot table automatically once i update the data?
September 18th, 2008 04:00 PM
by JP[_5_] Go to last post
1 66
Changing a Formula by Mark
I am using the following formula to add up a series of cells by a specific month. The formula is: =SUMPRODUCT((MONTH(RBS!A$2:A$1038)=5)*(RBS!N$2:O$1038)) I...
September 18th, 2008 03:54 PM
by Pete_UK Go to last post
2 77
Add values based on multiple criteria by myersl
Hi I am trying to add values dependant on two seperate criteria I have tried a formula which I found using excel help but it is adding the total of the...
September 18th, 2008 03:07 PM
by Mike H Go to last post
4 96
Post New Thread


Display Options
Showing threads 20221 to 20240 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 02:59 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.