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
I need to do a calculation based on the values in two cells by NakesGP
Hi I need help with Excel 2007 This is the sample data: A1 B1 C1 D1 100 0 1 400 1 1 500 1 0
August 23rd, 2009 10:33 PM
by Gary''s Student Go to last post
2 129
Using 2 cell CF conditions from different cells together by j5b9721
In cell A1 with CF Condition 2 is true. In cell "B1 CF Condition 1" I need to add "A1 CF Condition 2" and this to...
August 23rd, 2009 09:13 PM
by j5b9721 Go to last post
2 134
IF Function (Possibly) to Apply a Value Depending on Value by Toria
In column D, I have units. I have to apply values to the number of units. If the number is between 0-50 units, I apply 0, if between 51-200, I would need to...
August 23rd, 2009 08:02 PM
by Pete_UK Go to last post
5 155
Sum of a column from nth row to end by itsAchint
I want to total a column from D3 to the end of D column (I don't know the end) and place that sum in D1. Please help !! Urgent !!
(Multi-page thread 1 2)
August 23rd, 2009 06:44 PM
by T. Valko Go to last post
17 421
Multiple criteria - count if or sumproduct? by dizzyflossy
Hi all, hoping someone out there can help with a formula question. I have a set of data similar to the following A B ...
August 23rd, 2009 06:08 PM
by dizzyflossy Go to last post
3 151
How do I create multiple workbooks within one workbook by Ken C[_3_]
I'm not a programmer so this may sound dumb, but how do I create one workbook combining about 5 workbooks or better yet take 5 workbooks and put them all...
(Multi-page thread 1 2)
August 23rd, 2009 04:29 PM
by Gord Dibben Go to last post
17 387
SCANNED DOCUMENTS INTO EXCEL by KAMBROSE
CAN AN INVENTORY ITEM LIST, SUCH AS A MARY KAY ORDER INVOICE, BE SCANNED INTO EXCEL WITH THE DETAILS ENTERED IN SEPARATE CELLS?
August 23rd, 2009 08:16 AM
by Simon Lloyd[_403_] Go to last post
1 137
Excel Sort Doesn't Work by PeterOut
I am using MS Office Excel 2003 (11.8307.8221) SP3 on MS Windows XP 5.1 (build 2600.xpsp_sp3_gdr.090206-1234: SP 3). I have the following list of...
August 23rd, 2009 04:10 AM
by Capt. Cave Man Go to last post
7 413
residual plots in multiple regression by rjh
when doing a multiple regression analysis my copy of excel only produces a residual plot for the first variable x but not for x^2 or any other variable. ...
August 23rd, 2009 01:38 AM
by Mike Middleton[_2_] Go to last post
1 175
getting #N/A when vlookup is a negative number by Rick B[_2_]
When I do a vlookup and the lookup value is a negative number and negative numbers are in the lookup table I get a #N/A instead of the negative number I am...
August 23rd, 2009 12:36 AM
by Chip Pearson Go to last post
3 154
Adjust line spacing when printing address labels in Excell ? by lizreed
I am creating labels for a mass mailing in Excell and Word Vista. The line spacing is such that I can only get three lines on each label and I need four. ...
August 22nd, 2009 11:12 PM
by Capt. Cave Man Go to last post
1 124
Conditional Format - using 3 different cells conditions together by Luke M
Select "Formula is", and then input something like: =AND(Condition1FromA1,NOT(Condition2FromB2),Condition3FromC1) Fill in the Condition that you used in the...
August 22nd, 2009 11:11 PM
by j5b9721 Go to last post
2 113
Conditional Format - using 3 different cells conditions together by David Biddulph
Just use =AND(...) or =OR(...) in your CF/ Formula Is/ condition to combine your conditions as you require. -- David Biddulph j5b9721 wrote: I need a...
August 22nd, 2009 10:48 PM
by j5b9721 Go to last post
1 111
determining running counts by phumpher
Hi, I'm having some trouble figuring out how to keep a running count of some data. The...
August 22nd, 2009 10:33 PM
by ProfessionalExcel.com Go to last post
5 102
Mirror Wildcard? by thecdnmole
I have empty cells, A1:A10, and in cells C1:C10 I have data. If A1 is selected, I would like to be able to click on any cell in colum C and that info then...
August 22nd, 2009 06:59 PM
by Per Jessen Go to last post
2 135
=counta() unless row is hidden by Susan
hi all in column A i have some text data. some of the rows have been hidden. i want to count how many are left (visible). but any COUNT functions count the...
August 22nd, 2009 02:11 PM
by JLatham Go to last post
5 116
Repeat formula for all cells in whole column by Vincent
In C1, I have a formula to calculate the result of A1 and B1. This same formula is to be repeated on all the subsequent rows ie C2 calculates result of A2...
August 22nd, 2009 01:03 PM
by Jacob Skaria Go to last post
1 129
How do I calculate future date after number of days by Vincent
How do I calculate a future date based on the start date plus 21 days which must include saturdays, sundays and holidays. The function "workday" excludes all...
August 22nd, 2009 12:28 PM
by Per Jessen Go to last post
1 128
number or working days by Gibbyky2
Jacob kindly gave me the following formula for working out number of working days between 2 dates. it is exactly what i was looking for but it seems to...
August 22nd, 2009 12:03 PM
by Bernd P Go to last post
6 119
Counting Colors on a worksheet by Loadmaster
At work the formula in a cell is: =COUNTCOLOR(B5:AF5,12,FALSE) At work it is a macro that works How come it does not work or ask me to enable macros when sent...
August 22nd, 2009 06:00 AM
by FSt1 Go to last post
1 125
Post New Thread


Display Options
Showing threads 8001 to 8020 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 12:59 PM.


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