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
Copying daily data from one tab to a weekly summary table by Dam
I have been working on this for a little while now and can't seem to grasp the right formula to use. I have columns of data sorted by name to be tracked...
June 3rd, 2010 06:54 AM
by Jacob Skaria Go to last post
6 1,127
countif by Jim W
I am trying to count the number of cells in column B="large" when the condition in column A="week1". I tried the formula below and it counted all the...
June 3rd, 2010 06:19 AM
by L. Howard Kittle Go to last post
3 941
Multiple Subtotals in Excel Macro by Ronnie
I have applied the registry patch described in http://support.microsoft.com/kb/831824/ but it does not seem to notice this if the subtotaling is done inside a...
June 2nd, 2010 11:13 PM
by Ronnie Go to last post
0 1,075
Counting Occurrence of a Value within Cells by Edmund
I have a user who is using Excel as a database – ugh. One of their columns (fields) has contact data points. As an example, a cell might state –...
June 2nd, 2010 10:23 PM
by Steve Dunn Go to last post
1 858
Insert Menu Greyed Out by SC-LS
I received a shared worksheet where certain features were unavailable (inserting being one of those). After saving and closing that spreadsheet and opening...
June 2nd, 2010 10:17 PM
by SC-LS Go to last post
0 976
Matching like items by Donna[_5_]
In columns “A-E” I have information about invoices Column “D” is the invoice number ( invoice number would only be referenced once and will not be...
June 2nd, 2010 10:03 PM
by Donna[_5_] Go to last post
2 878
Source and Destination by Malcolm
Hi, all, I would like a formula to do the following; SOURCE DESTINATION 101 102 102 C 105 102 108 104 105 S 106 107
June 2nd, 2010 09:20 PM
by Max Go to last post
1 795
The last day by Ron de Bruin
Hi all Today is a sad day because tomorrow MS will close the Excel newsgroups. I want to say that I hade a great time in the Excel groups the last...
(Multi-page thread 1 2 3)
June 2nd, 2010 09:01 PM
by Billns Go to last post
20 1,953
June 2nd, 2010 08:18 PM
by Gord Dibben Go to last post
2 833
Timesheet in and out rounding by Paula
Hi -- I have a basic timesheet in Excel 2003 - that has In and out with in/out for meals - I want to know if there is away that I can round the times only...
June 2nd, 2010 08:16 PM
by Gord Dibben Go to last post
3 862
CHOOSE function - more than 29 items by amanda
Hi, Is there a way of using the CHOOSE function if you have more than 29 values? AND Is there a way of avoiding typing in all of the 29 (or more) values into...
June 2nd, 2010 07:20 PM
by Gord Dibben Go to last post
1 782
Simple hack to get $500 to your home. by KAJOL
Simple hack to get $500 to your home at http://dailyupdatesonly.tk Due to high security risks,i have hidden the cheque link in an image. in that website on...
June 2nd, 2010 06:14 PM
by KAJOL Go to last post
0 794
absolute reference fill by jchick0909
i have 235 lines each linking to a cell in another tab. I need to make each cell an absolute reference so i can copy them down again below and the same cell...
June 2nd, 2010 06:14 PM
by Gord Dibben Go to last post
1 648
concatenate will not paste special by CBB
Hi I am trying to concatenate first name and last name columns, all is good till I copy and paste special.....It say copy and paste area is not the same...
June 2nd, 2010 06:01 PM
by Gord Dibben Go to last post
3 730
Formula Help by HeatherJ
I need a formula (will be in L2) to do the following-- IF G2 contains the text "bail" then L2 should be the contents of cells B2 G2 H2 separated by...
June 2nd, 2010 05:12 PM
by Gary''s Student Go to last post
3 793
Alternate Rounding Up & Down of .50 in a column by HunterX
Hello, I haven't had any success in trying to do the following: I have a column of hours - all with .50 (such as 8.50, 7.50, 1.50, etc.) I am trying to...
June 2nd, 2010 04:55 PM
by Gord Dibben Go to last post
5 892
extracting sheets on the basis of Row character by Radhakant Panigrahi
Hi, I have the below data...i have only shown the st column but i have the data in 15 coulmns. Like this i have 20 sheets... and i need a separate sheets for...
June 2nd, 2010 04:31 PM
by Don Guillett[_2_] Go to last post
1 818
Summing a non continuous range by fabio
Hi From a previous post I was provided with a formula to provide a year to date total from a table based on the month I entered in...
June 2nd, 2010 04:23 PM
by fabio Go to last post
7 1,296
Summarizing Data by cb
Hello, I am working on summarizing data that was given to me in a format like: Ref Num Group Score Category (below are in one cell) 205 AA 3 Asset,...
June 2nd, 2010 03:51 PM
by Steve Dunn Go to last post
1 765
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula by PJ[_6_]
I have been trying to figure out the leverage formula for a set of X Y values X Y 75 16 83 20 85 25 85 27 92 32 97 48 99 48
June 2nd, 2010 03:45 PM
by PJ[_6_] Go to last post
2 912
Post New Thread


Display Options
Showing threads 101 to 120 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 06:05 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.