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
SumProduct Between Dates by StonyfieldRob
Having a tough time with this one. Sheet 1 Column A = Start Date, Column B = End Date, Column C = Quantity. Sheet 2 Row A = Start Date, Row B = End Date. I...
May 28th, 2010 03:03 PM
by Steve Dunn Go to last post
1 348
frustrated excel newbie by TJ
I am trying to make a monthly worksheet. I did get a drop down box set up, typed 6/1/2010 through 6/31/2010 in an empty column, used the validation tab,...
May 28th, 2010 02:53 PM
by Steve Dunn Go to last post
2 228
Excel stops responding; then starts again by little bits
I have Windows 7 Home Premium, Microsoft Office 2007. When working on excel spreadsheets, and I copy, then paste, it takes at least 40 seconds (which seems...
May 28th, 2010 02:50 PM
by little bits Go to last post
0 218
Concatenate with a specific number of spaces by Derek M[_2_]
Hi all I would like to do this in excel and wonder if its possible In cell a1 i have 1234 in b2 i have an address in c3 i have 600.00 and in d4 i have 1 I...
May 28th, 2010 02:44 PM
by Steve Dunn Go to last post
3 202
Create new records from existing ones based on 'rule'? by msnyc07
I am trying to pull apart records I uploaded that are set up something like this; MainField | Other Fields | AssociatedFIeld1 | AssociatedFieldN There can...
May 28th, 2010 02:38 PM
by Steve Dunn Go to last post
1 263
Calculate % by Amin
i have downloaded a file and it says 45% complete whiles the file is 650MB how do i determine the MB downloaded so far. finding the real mb of the 45% is my...
May 28th, 2010 02:19 PM
by [email protected] Go to last post
3 164
GETPIVOTDATA from OLAP cube - grouped field by bquackenbush
I am trying to build relative references to an SSAS OLAP cube using the GETPIVOTDATA function (excel 2007). There is a field in the pivot table named "Item"....
May 28th, 2010 02:13 PM
by bquackenbush Go to last post
0 255
Averaging without #DIV0! by Malcolm
I’m using a worksheet that has a cell (C27) that totals rooms and a cell (J28) that totals rates and a cell (J29) that is the average daily rate total,...
(Multi-page thread 1 2)
May 28th, 2010 01:38 PM
by Malcolm Go to last post
11 284
MONTH TO DATE ACROSS MULTIPLE COLUMNS & ROWS by Carrach
Please could someone help with the spreadsheet.(example below) in excel 2003 I have removed links so the formulaes have dissapeared but the info is the...
May 28th, 2010 12:08 PM
by Steve Dunn Go to last post
6 260
Return values that sum to a known value by lmattern
I have a list of data and would like to know if there is a formula that would return any items from that list that sum to a known value.
May 28th, 2010 11:59 AM
by Tom-S[_2_] Go to last post
1 251
Student loan formula by Scoober
Hi all, I am trying to get this formula to complete a student loan...
May 28th, 2010 11:49 AM
by Tom-S[_2_] Go to last post
8 219
Reposition comment boxes in 2000 by IanC
With Excel 2000, is it possible to reposition comment boxes? I know I can drag them whilsediting, but that only affects where they appear during editing. Can...
May 28th, 2010 10:59 AM
by IanC Go to last post
0 219
split the content of cell by cosmic
how do we split the content of one cell into two cells example : 6'X3' = 6 and 3
May 28th, 2010 10:16 AM
by Jacob Skaria Go to last post
2 126
If calculation by Sandy[_9_]
I am trying to do the following inputting in the same cell, 0 to 72=0 73 - 102 = whatever is input in the cell minus 72 over 102 = 30 ie 62 73 82 93 102...
May 28th, 2010 09:35 AM
by Steve Dunn Go to last post
5 140
Roundup and rounddown function - how to combine by Stefi
=ROUND(A1,0) follows the standard rounding rules: =1.5 up to 2 1.5 down to...
May 28th, 2010 09:11 AM
by Stefi Go to last post
0 196
Roundup and rounddown function - how to combine by RonaldoOneNil
Assuming the numbers are never more than 2 decimal places =INT(A1+.49) "Piotr (Peter)" wrote: Dear All, I have a spreadsheet with numbers containing...
May 28th, 2010 08:57 AM
by RonaldoOneNil Go to last post
0 174
Help with a formmula change in a "flag" parameter! by Danny Boy
The formula I have below in Column R works just fine. It creates a flag for me (in Column R) that lets me know one of two things: “Client Failed to Enroll...
(Multi-page thread 1 2)
May 28th, 2010 08:16 AM
by Steve Dunn Go to last post
19 449
How do I calculate a weighted average and exclude the empthy cells by aganoe
I am looking to complete my formula for calculated weighted averages. Here is what I have: A B C ...
May 28th, 2010 04:34 AM
by Pieter Vandenberg Go to last post
2 183
Get Google adsense account approval in 4 hours by Harika
Get Google adsense account approval in 4 hours I will Get you legitimate genuine google adsense with your name and address in just 4 hrs. Charges: Google...
May 28th, 2010 04:07 AM
by Harika Go to last post
0 173
Countif by jay
I have two worksheets. I would like to have a formula that counts data according to the following conditions. Worksheet 1 A B ...
May 28th, 2010 03:21 AM
by jay Go to last post
3 159
Post New Thread


Display Options
Showing threads 221 to 240 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 04:54 PM.


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