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
Two Level Search by burtlake
I have simplified the example ----- I would like to search the table shown below and determine the amount Pledge by each family. However since there are...
May 28th, 2010 03:22 PM
by Steve Dunn Go to last post
1 596
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 438
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 331
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 309
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 301
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 346
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 Ron@Buy Go to last post
3 237
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 320
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 499
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 348
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 387
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 362
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 280
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 180
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 203
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 259
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 224
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 587
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 243
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 248
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 11:57 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.