|
|
using find and replace it's making me look in another file to upd
I have used the find and replace function several times in the spreadsheet to
update the fromulas monthly. For some reason when I use it this month it
wants me to look in another file to "update values"? There is not another
file and there is no way for me to use the find and replace.
|
6/6/2010 5:22:33 PM
|
0
|
=?Utf-8?B?amltbXluZmFu?= <jimmyn...@discussions.microsoft.com>
|
Checkbook calculations
I am trying to create an Excel worksheet to calculate my checkbook. I want to
be able to enter different transactions and have them added or subtracted
from my balance, as well as keep a running balance. Any info will be most
helpful.
Thank you
|
6/6/2010 4:06:19 PM
|
2
|
=?Utf-8?B?TURTMTI2Nw==?= <MDS1...@discussions.microsoft.com>
|
Count function seeing formulas as data
Can you change the count function seeing formulas in cells as data. This
makes the function completely useless. I have an array 1000 cells X 500
cells. I need the count function to check on the number of occurances a
particular value is exceeded. The data is read into each of these cells by a
formula.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Micr
|
6/6/2010 12:52:02 PM
|
5
|
=?Utf-8?B?cm9iaW5lc3NleA==?= <robines...@discussions.microsoft.com>
|
Count function seeing formulas as data
How can you get around the count function seeing formulas in any cell
referenced as data?
|
6/6/2010 10:54:03 AM
|
4
|
=?Utf-8?B?cm9iaW5lc3NleA==?= <robines...@discussions.microsoft.com>
|
HELP! having trouble matching info with excel, HELP!
Hi, I'm required to present some info at my work, using two excel files. This
is the task:
File 1, has ID numbers in column A, and column B is blank.
File 2, has ID numbers in column C and column D has the date the person
joined the company
File 1 es a select grop of people (about 2500), whereas File 2 is the
general database (about 30thou)
They're asking me to match the data, in order to end up with the
coresponding date they joined the company in column B on File 1 (obtained
from column D on file 2), how to do it? taking in account that File 1 is
outdated and some peo
|
6/6/2010 8:13:08 AM
|
1
|
=?Utf-8?B?Z2xvcmlhbWFy?= <gloria...@discussions.microsoft.com>
|
xdate in Windows 7
I finally entered the world of Windows 7, albeit only because my laptop died.
I am a historan who needs to calculate dates into the 18th century. Xdate
always worked just fine in Excel 2003, but when I load it into the new
computer, Windows 7 sees it as an old process and refuses to recognize it. I
need those date calculations, and I'm not thrilled with buying a later
version of Office - if it even is in the newer versions - because A) I don't
otherwise need it, and B) I've seen the recent version of Office and want no
part of it.
|
6/6/2010 12:47:50 AM
|
2
|
=?Utf-8?B?SGVscCB3aXRoIHNjaGVkdWxpbmcgaXNzdWU=?= <Helpwithschedulingis...@discussions.microsoft.com>
|
|
|
Select a worksheet
I'm using the below formula to determine the specific type of equipment from
a list named: database
=IF(VLOOKUP($J$2,Database!$A:$U,21,FALSE)=$X$2,"Desktop",IF(VLOOKUP($J$2,Database!$A:$U,21,FALSE)=$X$5,"Notebook","Error!!!!!!!"))
value of X2 = DSK and value of X5 = NBK
What I need help with is a way of using the value returned to automatically
open the relevant worksheet, ie: If "Desktop" is returned the Desktop
worksheet needs to open and if "Notebook" is returned the notebook worksheet
needs to open automatically. All worksheets are in the same workbook.
|
6/5/2010 10:22:00 PM
|
2
|
=?Utf-8?B?UGhpbA==?= <P...@discussions.microsoft.com>
|
Complex AND OR Formula
HI
I need to express something in a formula , and am having trouble with
it.
I need to say this :
IF E2 CONTAINS "1bx" OR "2bx" OR "3bx" OR "4BX" AND J2 =11 THEN PUT 1 ,
OTHERWISE PUT J2
Can someone assist with some code to make this happen , please?
Grateful for any help. Sorry for double post.
Best Wishes
|
6/5/2010 9:07:18 PM
|
9
|
Colin Hayes <Co...@chayes.demon.co.uk>
|
Remove error notification X7/M7=0 when one or both cell values are
How to remove error notification when X7/M7=0 when one or both cell values
are 0
|
6/5/2010 8:48:28 PM
|
3
|
=?Utf-8?B?Y2hpcG1hYzE=?= <chipm...@discussions.microsoft.com>
|
IS THERE A FORMULA TO CALCULATE THE DISTANCE BETWEEN DATES
Does anyone know of a formula that will calculate how many days are from one
date to another? For example from March 30 to April 8. This is for the
purpose of getting the average amount of days for processing. Your help is
highly appreciated.
I am using Exel 2003.
|
6/5/2010 8:19:15 PM
|
2
|
=?Utf-8?B?QWxvaGFsYWR5?= <Alohal...@discussions.microsoft.com>
|
Moving Column data formula
I have information in column A of a task sheet. The information goes from row
1 thru 35. Column B is where I place a "x" to say the task need to be
completed. Is there a formula that can check each row in column B to see if
the "x" exist, until it reaches the end. If the "x" exist in any of the rows,
then move the information into a blank sheet called assignment. Example
B1,B3,B4,B20 all have a "x" in the field, now I need to move the information
in A1, A3, A4, A20 to row1 thru 4 of a blank work sheet. Is this possible.
|
6/5/2010 7:49:23 PM
|
1
|
=?Utf-8?B?UHV6emxlZA==?= <Puzz...@discussions.microsoft.com>
|
Trying to get this if statment to work
I have excel 2000. I am trying to get this formula to work. It does not give
me any errors or anything It just will not return the number in the cell that
it references
Cell CJ44 has the formula
Here is an example of the cells
CJ44 formula CL44 has =IF((I44=0),0,INT((I44-10)/2)) (the value in their is 0)
CK44 has =IF((H44=0),0,INT((H44-10)/2)) (the value in their is -1) CP44 (the
value in their is Y) but I want it to fuction normally if their is nothing
(blank) in cell CP44
So this is what I have written, but the value does not return to what I want
it to be.
=IF(H44=0,CL4
|
6/5/2010 6:29:43 PM
|
2
|
"Cerealkiller via OfficeKB.com" <u59...@uwe>
|
excel
I have a spread sheet and in it i have data validation tables when i finish
picking from them and email the sheet i then want to clear the info in the
tables but not the data validation table and not usr macro
|
6/5/2010 5:57:02 PM
|
1
|
=?Utf-8?B?YmVubmV5?= <ben...@discussions.microsoft.com>
|
what tab for calculating percent and decimal?
I want to find the percent for each column. Which tab do I click to get the
drop down choice for percent. I found it once and forgot to remember it. I
also remember seeing the dropdown had decimal as well. I am just starting to
explore using this for my grading system at school. Today is my first day
exploring this site.
|
6/5/2010 5:16:05 PM
|
1
|
=?Utf-8?B?SGVpZGk=?= <He...@discussions.microsoft.com>
|
sum by rows in Pivot
Hi,
see table below.
Col A Col B Col C
a 1 7
s 4 9
x 8 4
d 9 3
v 4 2
b 3 5
n 6 6
m 9 8
r 2 9
d 4 1
a 6 9
f 7 5
See Excel 2007 Pivot table result below.
Values
Row Labels Sum of Com B Sum of Col C
a 1 7
s 4 9
x 8 4
d 9 3
v 4 2
b 3 5
n 6 6
m 9 8
r 2 9
d 4 1
a 6 9
f 7 5
Grand Total 63 68
I am not getting "Grand Total" by row in Excel 2007.
Can someone explain why?
Thanks,
Dinesh
|
6/5/2010 4:44:48 PM
|
1
|
=?Utf-8?B?RGluZXNo?= <Din...@discussions.microsoft.com>
|
maintaining constant percentage
Am trying to construct formula in excel 2007 for maintaining a constant percentage. Example: company 1 has 1,000 shares. Company 2 wants to purchase 10% of company 1 and always maintain the 10% rate. Buying 10% more shares would give a total of 1,100 and their percentage would be less than 10%. What formula can be used to calculate this and would find out how many more shares they would need to purchase in the event company 3 purchases X shares.
|
6/5/2010 4:43:08 AM
|
1
|
SF123 <u...@msgroups.net/>
|
How to Convert 24/03/2010 as text into 03/24/2010 date format
Hi ,
I’m using Ms Excel 2003 and in my excel sheet there is a column in which
dates are entered as DD/MM/YYYY (e.g. 24/03/2010 as a text) format and I
wanted to convert it into MM/DD/YYYY (e.g. 03/24/2010).
Can excel programming is required to convert such date or is there any excel
function.
Please suggest.
--
------------------------------
Thanks
Nitesh
------------------------------
|
6/5/2010 4:34:29 AM
|
3
|
=?Utf-8?B?Tml0ZXNo?= <Nit...@discussions.microsoft.com>
|
Simplify Weighted Average Formula
I have a s/s that has the months of the year across the top and below 3
categories for each month and I want a weighted avg for each product. eg:
A B C D E F G H I
January February March etc. to Dec
Days Oil Gas Days OIl Gas Days Oil Gas
6 12 200 4 5 180 7 8 300
formula: =(a1*b1+D1*E1+G1*h1)/(a1+d1+g1)
Is there a way to simplify this? Thank in advance for any help.
--
ferne
|
6/5/2010 4:04:38 AM
|
4
|
=?Utf-8?B?ZmVybmU=?= <fe...@discussions.microsoft.com>
|
Create Formula for Weighted Average in non-consecutive cells
I have a spreadsheet which across the top has the months Jan to Dec and
Total. Under each month is 4 categories Days/oil/gas and would like to
simplify a formula for a weighted avg. eg.
A B C D E F G H I
JANUARY FEBRUARY MARCH etc. to December
days Oil gas days Oil Gas days Oil Gas
6 22 13 4 5 18 7 12 15
formula: =(a1*b1+d1*e1+g1*h1)/(a1+e1+g1)
Is there any way to simplity this. Thanks for any help anyone can give.
ferne
|
6/5/2010 4:04:37 AM
|
0
|
=?Utf-8?B?ZmVybmU=?= <fe...@discussions.microsoft.com>
|
Totaling columns
I was so impressed with the wonderful responses and spot on answers to my
first question on this site I thought I would give this one a try. I did try
to research to find this on the site, but perhaps I am wording my search
incorrectly.
My question is: On my download I run a macro that I have set up do
calculations on my worksheet.
1.Each time the report is ran it would have varying information and
varying numer of lines.
For each run of the report the columns below would a have the following in
common, but again each run would have a varying amount of rows)
2. Col A will
|
6/5/2010 2:22:54 AM
|
4
|
=?Utf-8?B?Sm9obg==?= <J...@discussions.microsoft.com>
|
Weibull function in Excel
I have a survival dataset (see below). I want to fit to Weibull function
S(t)=EXP(-alpha*Time^gamma). If I use Excel Solver, alpha=0.00367 and
gamma=2.32. If I use a method tranforming probability to Ln(Ln(1/S(t)) which
will be a linear function of Ln (t). But I got a different alpha and gamma.
When I compared two alphas adn gammas, the Solver results had a better
goodness of fit. What is the problem? THanks
Month Probability of survival
0 1
1 1
2 0.92
3 0.90
4 0.88
5 0.83
6 0.76
7 0.74
8 0.69
9 0.57
10 0.48
11 0.39
12 0.27
13 0.27
14 0.13
|
6/5/2010 1:44:21 AM
|
3
|
=?Utf-8?B?QmFyYm8=?= <Ba...@discussions.microsoft.com>
|
Keeping Formulas Not Data
I input my formula, but would like to fill in the data later. How do I save
the Formula without there being data. I am trying to create time sheet that
will be filled out weekly so the data will change. I want the formulas to add
hours etc. to be in the worksheet with or without the data. Help!!
|
6/4/2010 11:21:23 PM
|
1
|
=?Utf-8?B?SmVubmkgUg==?= <je...@greenconstructionservice.com>
|
Fill in Column with a series of repeating numbers
I am trying to fill in an amortization years column. The first 12 rows are
"1", the next 12 rows are "2", the next twelve rows are "3" and so on. I've
got 360 rows to fill. Any suggestions?
|
6/4/2010 10:53:41 PM
|
2
|
=?Utf-8?B?bWltaQ==?= <m...@discussions.microsoft.com>
|
Data Labels in Excel Pie Charts
How do I get the data labels to stay where I put them in pie charts. I have
a series of pie charts set up and update the data they are based on monthly.
I find that most of the time when I go to the pie chart, whether or not I
have updated the source data, the labels will move and typically so that they
are not able to be read, eg all of them at the top of the form with some on
top of the other.
Is there a way to freeze the data labels so that I dont have to keep
reformatting?
--
Thanks as always
Marlaine
|
6/4/2010 10:53:41 PM
|
0
|
=?Utf-8?B?TWFybGFpbmU=?= <Marla...@discussions.microsoft.com>
|
barecode command
customize toolbar , all commands, barecode cammand,
after barecode command has been placed in toolbar, it has not funtion, i am
unable to click on it , under help it states that one the stand alone version
of excell or the excel version that came with professional package or higher
has the barecode command . my office package is professional version. the
command showes up in toolbar but does nothing
|
6/4/2010 8:10:54 PM
|
0
|
=?Utf-8?B?Ymdz?= <...@discussions.microsoft.com>
|
COUNTA or COUNTIF or COUNT
Trying to count the times "YES" occurs in column C3:C5 for each time "Bill"
indicated in column B3:B5?
--
Thanks - liz
|
6/4/2010 7:48:28 PM
|
4
|
=?Utf-8?B?TGl6?= <...@discussions.microsoft.com>
|
F4 no longer automatically creates absolute reference
I select the text of a cell name (A1, for example), hit F4, an nothing
happens. I have to go in and type my $. How do I reset F4 to work?
|
6/4/2010 7:46:18 PM
|
2
|
=?Utf-8?B?bW9sbGE=?= <mo...@discussions.microsoft.com>
|
Exported data from Banner database to Excel
When I take a Banner database exported to excel and save it as .dbf file to
use in mailing software, it drops certain fields in the name field. Does
anyone know why this happens, is there some thing in those fields that is
hiding the information? I causes great grief as the addressing software will
shift all the data from the remaining fields up and totally mess up the name
to proper address. Help?
|
6/4/2010 5:29:01 PM
|
0
|
=?Utf-8?B?Q0JC?= <...@discussions.microsoft.com>
|
iserror and ifs nested formulas
Please help!
I am trying to get the formula below to return a value to the cell ONLY if
the answer to ((c30-$30)/g$30) is greater or less than 20%.
I am using the below formula.
=IF(ISERROR((C30-$G30)/$G30),"-",IF(((C30-$G30)/$G30)>ABS(20),((C30-$G30)/$G30)," "))
Thanks
|
6/4/2010 5:05:25 PM
|
4
|
=?Utf-8?B?Vmlja2k=?= <Vi...@discussions.microsoft.com>
|
Formula to pull the lowest supplier name
I need assistance creating a formula to extract the supplier name associated
with the lowest supplier bid. A sample of the data looks like this. I need
to be careful as some quotes will be zero and I do not want to pull this as
the minimum supplier.
Sup A Sup B Sup C Minimum Sup Bid Minimum Sup Name
$/lb. $/lb. $/lb. $/lb.
Item 1 1 2 3 1 ?
Item 2 0.5 0.2 0.4 0.2 ?
Item 3 2.4 1.9 0.8 0.8 ?
|
6/4/2010 5:04:08 PM
|
3
|
=?Utf-8?B?Q2Fzc2l1cw==?= <Cass...@discussions.microsoft.com>
|
Multiple IF's with an OR
Cell DQ contains a formula that pulls in the status of the item.
Here is my existing formula so far:
=IF(O2<=N2,IF(DQ2="Text1",IF(L2>0,"Yes","No"),""),"")
What I need is for the formula to be edited os that if DQ2=Text1 OR Text2
but I don't know how to do that in Excel 2003.
Thanks.
|
6/4/2010 4:18:56 PM
|
5
|
=?Utf-8?B?TmFkaW5l?= <Nad...@discussions.microsoft.com>
|
Counting question
In column A I have set of characters that are entered into the rows below
(i.e. Y, N, MRO) in column B I have another set of characters that are
entered into the rows below (i.e. A, E, on so on). I want to count the
instances when the rows in Column A contain a Y and the rows in column B
contain an A. Is there an simple formula for doing this? Any help will be
appreciated.
--
John
|
6/4/2010 3:43:15 PM
|
16
|
=?Utf-8?B?Sm9obg==?= <J...@discussions.microsoft.com>
|
Countif Question
--
John
|
6/4/2010 3:40:50 PM
|
0
|
=?Utf-8?B?Sm9obg==?= <J...@discussions.microsoft.com>
|
How to tell COUNTIF to not count a few characters
Im working on a colum that is a medical schedule for Doctor who will be
working that day so that I know how many exam rooms will be needed - right
now Im working with: =COUNTIF(F14:F43,"*") which tells me how many cells are
not blank. But I would like to have countif not count cells in that same
colum who have values like: OFF, ADMIN, OFF SITE and etc. Am I using the
correct function? PLEASE HELP!
|
6/4/2010 3:29:20 PM
|
2
|
=?Utf-8?B?UmFmYQ==?= <R...@discussions.microsoft.com>
|
Workbook causes calculation errors
I've never seen this error before, and unfortunately, my Google searches
keep bogging me down with the simple "Automatic/Manual" solution...
I have Workbook A, which contains a large amount of data/formulas (3000 rows
x 100 columns, several columns using SUMPRODUCT checks). The workbook is in
Shared mode, and due to amount of calculations it does, is left in manual
calc mode. Up until a few days ago, users could make changes to the data,
hit F9 to recalc, save, and move on. Then something happened...
Now, the workbook always displayed "Calculate" in the status bar, even after
|
6/4/2010 3:04:14 PM
|
2
|
"Luke M" <lukemor...@nospam.com>
|
Count number of instances
Need a formaula to look at an entire column and count the number of
different times (say date of product)
Thanks
--
ce
|
6/4/2010 2:41:57 PM
|
4
|
=?Utf-8?B?Q3VydGlz?= <curtis.ea...@yahoo.ca.(do not spam)>
|
Troubleshoot
Can someone help me with the following statement:
=AVERAGEIFS(BeezidTable[final],BeezidTable[time],">TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()))")
It returns DIV/0, but it should return a proper average.
Thanks, Roy
|
6/4/2010 2:28:42 PM
|
2
|
=?Utf-8?B?cnd0cmFkZXI=?= <rwtra...@discussions.microsoft.com>
|
calculate equated monthly installment ?
How do we calculate equated monthly installment value for given int rate and
period for a capital available and reverse of the same. Thanks
|
6/4/2010 2:13:02 PM
|
2
|
=?Utf-8?B?RCBWIEJpZHJp?= <D V Bi...@discussions.microsoft.com>
|
Macro help - add column selection
I have the following replace info in a macro.
Selection.Replace What:="Of", Replacement:= _
" of ", LookAt:=xlPart, SearchOrder:=xlByRows, _
MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
I only want this applied to Column A. What do I need to add so it only does
the replacements in Column A?
Thanks, Heather
|
6/4/2010 1:27:46 PM
|
1
|
=?Utf-8?B?SGVhdGhlcko=?= <Heath...@discussions.microsoft.com>
|
MEDIANIF
Was this function removed from 2007 or do I just need to download an add-in?
|
6/4/2010 1:24:25 PM
|
1
|
=?Utf-8?B?cnd0cmFkZXI=?= <rwtra...@discussions.microsoft.com>
|
Can't Edit Worksheet Comments
I'm running Vista Home Premium SP2, 2 GB RAM, Firefox, Spyware Doctor, MBAM,
SAS and CCleaner, Office 2007.
All of a sudden only one (of many) worksheets inside one particular (xlsx)
Excel file will not allow me to edit the comments in any of the cells where
the comments exist. When I right click the cell and select `Edit Comment'
(which is not greyed out) nothing happens. If I try this on any other xlsx
files I have or any other xls files, comment editing works fine. I tried the
help manual and a reboot to no avail.
I've been using/modifying this file for years. It contains tons of
|
6/4/2010 1:21:46 PM
|
1
|
"Paul Calcagno" <pcalca...@cfl.rr.com>
|
AMVERAGIF Condition
I am having trouble adding an AND statement to the condition portion of the
AVERAGEIF statement. Is there a trick to doing this?
|
6/4/2010 1:10:52 PM
|
6
|
=?Utf-8?B?cnd0cmFkZXI=?= <rwtra...@discussions.microsoft.com>
|
Import old dos sequencial data
I have an old database that stored it's data in a sequencial format with
fixed lengths for each field. As Windows 7 64-bit no longer allows the
running of the database I need to access the data in another way so wish to
import it to excel. I can get as far as marking the first record's field
lengths but there does not seem to be a way of marking the end of the record.
Instead it leaves the rest of the data in the final field!
Can anyone suggest the best way of doing this? Thank you.
|
6/4/2010 12:32:39 PM
|
3
|
=?Utf-8?B?UmljaCBTdG9uZQ==?= <RichSt...@discussions.microsoft.com>
|
How can i protect a formula and still allow copy and move data?
i have 12 columns with data on days and each new day i want to add a new day
to the set of 12 columns without adding a 13th one. So the oldest day are
removed and the view is still 12 days.
In these columns some values are calculated with formulas from data residing
in the column (not from other columns) and i want to protect the formula but
allow the column to be moved one step to the left.
As of now i havent been able to use the built in functions of protection of
cells and protection of formulas.
Any ideas?
|
6/4/2010 12:03:04 PM
|
1
|
=?Utf-8?B?QUxQ?= <...@discussions.microsoft.com>
|
How do I unhide collom a?
I hid collom A and now can't unhide it! Please help?
|
6/4/2010 8:22:44 AM
|
5
|
=?Utf-8?B?SG9ubmVzdHk=?= <Honne...@discussions.microsoft.com>
|
How to give a string of data into different columns
Super expert,
If I have cell containing a series of data like this ....
1,12,9
1,2,9
1,22,17,18
23,23,1,9
24,21,1
1,23,11
22,1
2,3
Is it possible to use function or command to split them into columns?
1 12 9
1 2 9
1 22 17 18
23 23 1 9
24 21 1
1 23 11
22 1
2 3
I don't want to use "TEXT TO COLUMN" as some of the addresses can be
overwritten.
Thanks so much,
Regards,
Elton
|
6/4/2010 5:56:24 AM
|
8
|
=?Utf-8?B?RWx0b24gTGF3?= <Elton...@discussions.microsoft.com>
|
Import external data
Sir,
I am using MS excel 2003. I try to get data (a1:u17000) from another file
using "Import external data" function. When I refresh data, not all data
imported. Column R & S failed to extract and column U some data OK.
|
6/4/2010 2:26:54 AM
|
6
|
=?Utf-8?B?bm9yZGl5dQ==?= <nord...@discussions.microsoft.com>
|
vendor matches
This is my first question on this site, so I hope I hope this makes sense.
I have vendor numbers in Col A-each vendor number would only be listed one
time and not in numeric order. In Col B-- I assigned a number beside each
vendor number in Col A. In column G, the same vendor numbers are listed but
they may be listed more than one time and not in order. What I would like to
do in Col H is if Col G has a match in Col A, I would like it to put the
corresponding number from Col B in Col H.
(Vendor#) (Vendor#)
Col A Col B Col G Col H
123411 1
|
6/4/2010 2:03:51 AM
|
6
|
=?Utf-8?B?Sm9obg==?= <J...@discussions.microsoft.com>
|
extract data from pivottable which meets certain conditions
What is the correct formula for extracting data from a pivot table report
which meets a certain conditional set of criteria?
|
6/4/2010 1:25:23 AM
|
1
|
=?Utf-8?B?YmVmdXp6YWxlZDIwMTA=?= <befuzzaled2...@discussions.microsoft.com>
|
Size of file with pivot table
I have a file that was 8MB when I started. I created a pivot table pulling 7
fields from a worksheet. Now the size is 20MB. Any ideas why this one pivot
table would cause the file to be so large when the 8MB file already had pivot
table sin it?
When it was 8MB, it had 6 pivot tables.
Now it's 20MB and it has 7 pitvot tables.
Why is this one table so much larger?
|
6/3/2010 11:57:01 PM
|
2
|
=?Utf-8?B?TmFkaW5l?= <Nad...@discussions.microsoft.com>
|