Trendline values #2
I used the function "LOGEST" to get an exponential fit of a series of
numbers, which gives me a value of 1.0610. I also used "RSQ" function to get
the R-square, which is 0.9442. Then I made a chart based on the same series
of numbers and add trendline to the curve. I selected "Exponential" under
"Type" and checked "Display equation on chart" and "Display R-Squared value
on chart". The value shown on the chart is "y=3928.8e^0.0592x" and
"R^2=0.9104". I expected to see "y=3928.8e^0.0610x" and "R^...problem carrying over values
I have one form that has a button I''ll call it form1. The button
looks at a text box for an ID and if its null it opens form2 and
creates a new record in form2. If the text box is NOT null, it will
go find the ID that's in the text box and filter it in form2.
When the new record is created in form2, I need the ID to be put into
the NULL text box in form1. I know how to do this however, if you
open form2 on its own, then the error msg comes up that it can't find
form1. I know why I'm getting this error, but don't know the fix for
Is there a work around? Thanks...Can I make a row "float"?
I would like to make a row float.
So if I scroll down to row 211 or whatever, I will have one row tha
will always be on top no matter how far down I scroll.
Thanks in advance.
dvcrogers's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3262
View this thread: http://www.excelforum.com/showthread.php?threadid=52413
Say you want row 4 to freeze
Select row 4, then go to window and freez
--------------------------------------------------------...different start time different days
How can I set different start times for different days? Outlook seems to
assume I work every day for the same hours, not so. I was hoping to use
its shading as a visual guide for different days, but it wants all days
to have the same time schedule.
Outlook doesn't handle shift work. You could make tentative appointments for
the work hours to highlight them.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
...clash between different versions of excel?
Hi all. I created an excel document using excel2003 and save it in a file
server. As it is a shared file, it was opened by another user using excel97
for editing. However after the file was saved by the user of excel97, the
layout of the content in the file became very different compared to the 1
that was saved by myself when i was using excel2003. As the user of excel97
merely change the data without editing any layout, why did this happened? Is
it due to the different versions of excel being used? How can i solve this?
Thks in advance.
...same subform used in two different forms
Is it possible to use the same subform in two different main forms
simultaneously? If it's possible, is it good practice? I can foresee
that there may be problems with code, but the subform I'm thinking of is
FamID (primary key)
IndID (primary key)
....other personal data
Two main forms for different types of data entry
frmFamily with family information on the main form and address
information...Excel formatting #3
Could someone please help with a macro or any other suggestion to format an
Excel sheet. Basically data is downloaded from a bank every week and the
size of the file can vary but the formatting is constant. That is each
record is 7 lines. So first record is line1-7, second record is line 8-14,
third record is line 15-21 and so on.
I need to format this data and basically I can record a macro for one data
set that is for the record on line 1 to 7. My question is how can I set it
to replicate so that it replicates for line 8-14 and then 15-21 and so on.
The source formatting remains the same...#VALUE! error
I'm sorry but I added to this formula and it started with the #VALUE!
again. The error goes away once I enter data. It's just so tacky
looking seeing all these error messages. Please help!
You have your closing parenthesis for the IF function right after the "$F$15
reference which means the division by D3 is not controlled by the IF
function's testing for D3="". I think moving the parenthesis to the end of
the calculation will yield the result you want...
=IF(O...Values in the Legend?
Is there a way to show values in the legend - behind the series text?
Do you want to show just a single value? You can either build a
lengthier label (like =A1&B1), and use this as the new series name, or
you can select multiple cells for the name, and Excel puts them together
with a space between.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
Phil Hageman wrote:
> Is there a way to show values in the legend - behind the series text?
> Thanks, Phil
...Adding on to a formula across rows and columns
I need to add a second section of a formula onto an existing formul
across rows and columns.
The problems are:
-Not all cells currently contain formulas (some are blank)
-Not all the formulas are the same (there are at least 2 different
formulas among all the existing formulas that I want to add that secon
formula or section to)...and the different formulas are somewha
-Some of the existing formulas contain relative references (I want t
change them to absolute references)
-If I use relative references to somehow copy a portion of a formul
across all remaining rows and columns,...Separating data into new sheet
I have the following data on worksheet "Sheet1"
I have worksheet "Sheet2" that I want user to input what CODE they want to
Let say A
then on "Sheet2" i would get:
It is a combination of sorting, copying and moving the wanted data to the
Is there an excel feature/solution that does this? or a VB code is needed?
Thanks in advance
...Conditional Cell Category
Is it possible to make a cell's category conditional on the value in
I would like to have a cell display its value as a currency if the
cell before it says "Monthly", and as a percentage if the cell before
it says "Annual".
I am working in Excel 2003.
Thank you, Trey ~
On 29 June, 15:39, one third <g...@hotmail.com> wrote:
> Is it possible to make a cell's category conditional on the value in
> another cell?
> I would like to have a cell display its value as a currency if the
> cell before it says "Monthly", and as ...maximum number of rows that can be coppied to clipboard
is there a maximum number of rows that can be copied to clipboard from a
table? using access 2002 on XP,
> is there a maximum number of rows that can be copied to clipboard from a
> table? using access 2002 on XP,
I have Access 2003 when I tried to copy a table with 70,000 records
it said the limit was about 65,000.
Andy Wiggins FCCA
Excel, Access and VBA Consultancy
"Roland" <Roland@discussions.microsoft.com> wrote in message
> is there a...What Excel macro puts data in the NEXT row of a sheet?
I have a list of data in col B of sheet 2 which I need to copy and transpose
into sheet 1, then delete the data in sheet 2 to use the form again to copy
and transpose onto the next line in sheet 1. I have tried with a macro
shortcut I've called ctrl + e. (I am really using the data form process but
cannot because I have too many inputs).
Is there a simple macro I can copy and paste?
...How to see if different workbooks are linked?
How can someone determine if two workbooks are linked? I can see it is I find
the cell, but is there a way to see it at a glance?
You can use Edit>Links in the menubar(not in all excel versions)
If it is gray there are no links
Regards Ron de Bruin
"Tracy@Saunatec" <Tracy@Saunatec@discussions.microsoft.com> wrote in message
> How can someone determine if two workbooks are linked? I can see it is I find
> the cell, but is there a way to see it at a glan...Min and Max values for different salespeople?
I am trying to find the minimum and maximum sales for each salesperson. I
can not sort by salesperson -- I must sort by sales date. How do I do this?
1/2/1999 Bob $7
1/5/1999 Rick $20
1/7/1999 Sue $75
1/10/1999 Bob $5
1/15/1999 Sue $3
1/27/1999 Rick $53
So, I need to know Bob's minimum sale was $5, and his maximum sale was $7.
I know how to use the MIN and MAX functions, but how do I tie in the sales
Assume your salesperson names are in column B and their corresponding sale
amount is in column C:
=MAX(IF(B1:B10="Bob&...want to turn PT row data into column data
name win loss score
paul 1 325
Jane 0 1 225
walt 1 400
nancy 0 200
jane 1 300
nancy 1 200
paul 1 365
walt 1 350
when i create p.t. I get (or a vague approximation)
but this is what I would like:
name win loss avg
Paul 2 0 345
Jane 1 1 260
walt 1 1 375
nancy 0 2 200
Grab the g...Only Display records before and after a change in teh value of a f
I have a table that looks like the following
RUNID | DATETIME | PROCESS
0001 1/1/09 1201 Neck
0001 1/1/09 1202 Neck
0001 1/1/09 1203 Neck
0001 1/1/09 1204 Neck
0001 1/1/09 1205 Neck
0001 1/1/09 1206 Body
0001 1/1/09 1207 Body
0001 1/1/09 1208 Body
0001 1/1/09 1209 Body
0001 1/1/09 1210 Neck
0001 1/1/09 1211 Neck
0001 1/1/09 1212 Neck
0001 1/1/09 1213 Neck
0001 1/1/09 1214 Body
0001 1/1/09 1215 Body
0001 ...Don't chart X-axis without values.
On a line chart I am plotting two individual columns and
then SUM(ming) these two for a total. Future dates of the
individual columns have no data BUT the formula for
SUM(ming) the two results in zero (0) which is plotted on
my chart. I've tried a number of approches to the
formula, blank (""), and Null (which results in a string
and causes an error.
How can I leave my formula in the future dates and not
effect my chart. Obviously, with moving from 300k to zero
in one week is scary.
Excel can't return a NULL or BLANK from a function (not t...formulas when there may/may not be a value
What formula do you use when there may not be a value there? Like:
ITEM QTY SOLD
T0887 50 1
T0887 200 2
T0992 50 3
# of sold items for each item?
(remove nothere from the email address if mailing direct)
"NTaylor" <NTaylor@discussions.microsoft.com> wrote in message
> What formula do you use when there may not be a value there? Like:
> ITEM QTY SOLD
> T0887 50...combine hide row macro with conditional formatting
I'm sure one of you gurus can solve this in a flash. I've recorded a
simple macro to hide a row (Alt O, Alt R, Alt H) but I want it to run
automatically based on a cell value. For example: If cell value "A1"
is "x" then I want the macro to run, and repeat itself down the column
"A2, A3" etcetera until it reaches a blank cell. Is there a way to
plug my existing macro "hiderow" into Conditional Formatting for a
column; or is there a simpler solution?
~~ Message posted from http://www.ExcelTip.c...%s in Accounting Format
I am using Excel 2007.
I want to have a column that lists percentages - but to still be able
to use the accounting single underline correctly. When I manipulate
the accounting format to _(*#,##0.00%_) the underlining is not
correct. If I use the accounting format I cannot get "%" signs.
Does this work?
_(* 0.00%_);_(* (0.00%)
"jadeB" <email@example.com> wrote in message
>I am using Excel 2007.
> I want to have a column that lists percen...Autofit row height in only some rows
Is it possible to change this macro to only autofit the row height on rows
254-332 in the workbook? I am using this macro:
Private Sub Workbook_SheetCalculate(ByVal Sh As Object)
Application.EnableEvents = False
Application.EnableEvents = True
Thanks in advance for your help.
Private Sub Workbook_SheetCalculate(ByVal Sh As Object)
Application.EnableEvents = False
Application.EnableEvents = True
...Get Dictionary value
I am just wondering: is there another way to get a IDictionary value
String value = config["key"].ToString();
Is does not feel C# to have something like config["key"].
But that's just me ....
> I am just wondering: is there another way to get a IDictionary value
> String value = config["key"].ToString();
> Is does not feel C# to have something like config["key"].
> But that's just me ....
Probably. But, if you r...Field whose value increments automatically
Is it possible to create a field which automatically increments by 1 every
time I open the worksheet?
Only with code. Use the Workbook_Open event procedure to
increment a value in a cell. For example, put the following code
in the ThisWorkbook code module:
Private Sub Workbook_Open()
.Value = .Value + 1
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Quinnboy" <Quinnboy@discussions.microsoft.com> wro...