pasting of variable cell value into macroI have written a macro that runs an autofilter which grabs cell info from a
different worksheet within that workbook (an entered date). It then uses that
date to autofilter. It works fine the first time, but aparently plugs that
info permanently into the macro and will not work on subsequent runs. I need
a macro that will grab variable info from a certain cell each time and run
with that new cell value each time. Any ideas?. (& yes, I am a newbee)
sorry..
Your problem is refreshing the autofilter. It is best to clear the old
filter before applying the new filter. Here ...
Value Y axis label is cut offI can't figure out how to increase the "text box" around the Y axis
label. In the display, it shows the entire word, but in the actual
chart, the last letter of the word is cut off. It appears that I can
only move the position of the entire label, but I'm not able to
stretch the label so that it includes the entire text. I tried
putting a couple spaces after the text in the Title field in the Chart
Options screen, but this didn't help.
Example: The Y axis label is "Annual Return" and it looks like it
says "Annual Returr" due to the "n" b...
Viewing field values at the accounts levelI created several customised fields and bulk imported account data - all
looks fine except for one numerical field, which does displays only blanks.
When you double-click on the account, however, you clearly see there is a
non-zero value there.
When I sort by this field, it does the right thing, just that somehow the
field value does not show up under the field name at all when viewing all
accounts.
Any help would be great. Textbooks etc don't seem to cover this sort of
newbie snag! Thanks
...
Lookup value off by one rowHi,
Any help you can provide on this would be appreciated. I have a worksheet
that identifies how far a number is from target. I created the lookup below
to coorespond to the productivity increase for next year.
=LOOKUP(C4,LookUpValues!$A$1:$A$402,LookUpValues!$B$1:$B$402)
C4 is -10.9, in the lookupValues tab -10.9 is in row 93 column A as is the
desired result return of 5.6 in column b, however the lookup function is
returning 5.7.
The issue may be that the data and the lookupValues tab numbers are not
exactly the same. -10.90001 and -10.9004 may display the same, but w...
Importing values w/trailing minus signsXL97 & 2k
For many years I've regularly imported downloaded (mainframe) files into XL and, where
there were values with trailing minus signs, I used the Import Wizard to define the
position as a separate column.
I wrote a utility macro that flips the value.
Recently someone mentioned that they accomplish this with the import wizard and I looked
until I was blue in the face but cannot find it so I assume that-if this individual was
correct-it is in a version newer than the one(s) I use (I didn't hear what version he was
using).
Is this correct, or am I indeed blind?
--
Regards;
R...
Help with interpolating valuesHi,
I have two series of data as follows:
Distance Height
0 0
6 12.5
11 23
12 16.25
14 26.75
24 27.25
42 22.75
45 30
55 52
70 67
90 79
115 83.5
I need to find the heights corresponding to :
5.
10
15
20
25
30
and so on till 115 (ie at distances in multiples of 5)
What is the best way to do this? I am new to statistical functions in
excel.
Thanks in advance for the help.
Regards,
Raj
On Tue, 6 Apr 2010 03:22:50 -0700 (PDT), Raj <rspai9@gmail.com> wrote:
>Hi,
>
>I have two series of data as follows:
>
>Distance Height
>0 0...
Mode functionHi,
I'm using the following expression to return the mode of a list of numbers:
=IF(H1028="","",MODE(H1028:H1031))
If the four checked cells all have values but there's no two values the same
(i.e. no mode) what I need is an expression that will return me a default
value of 2 rather than the #N/A error value.
Thanks for looking,
Steve.
=IF(ISERROR(MODE(A1028:A31)),2,MODE(A1028:A31))
Regards,
Stefi
„Struggling in Sheffield” ezt írta:
> Hi,
> I'm using the following expression to return the mode of a list of numbers:
>
> =IF(H1028="...
This email already exist in this organisation. ID: c10312e7Hello,
We are using SBS 2003 in a small organisation (1 server, 4
workstations)
I am trying to add an email address (xxx@yy.nl) to a public folder.
This email address previously was assigned to a (the only)
distribution group, but was removed there. The public folder xxx gets
an email addres of xxx1@yy.nl and if I change it to xxx@yy.nl the
error message appears. I can't assign this address back to the group
either. If I send an email to this address the notification states
that it's refused by the public folder store.
Searched all the discussions concerning c10312e7.
I have tried th...
Getting Excel to return Hiragana using code/char functionsI have a Japanese computer which does this perfectly, but when I tried to use
the worksheet on an English computer with Japanese language enabled, it only
came up with errors. The code it was returning for the Japanese characters
was much to low & putting in higher codes meant it didn`t recognise it.
What can I do to make it work?
...
Return a number in one cell to long hand text in another.Ie. 123.65 to One hundred, Twenty Three & Sixty Five Cents
Take a look at http://www.xldynamic.com/source/xld.xlFAQ0004.html
--
HTH
RP
"CP" <CP@discussions.microsoft.com> wrote in message
news:C0D9B8E3-3D66-4EA0-9184-57762BD663D6@microsoft.com...
> Ie. 123.65 to One hundred, Twenty Three & Sixty Five Cents
Go to Google and search the newsgroups for "spell number"
On Wed, 20 Oct 2004 15:07:02 -0700, "CP" <CP@discussions.microsoft.com> wrote:
>Ie. 123.65 to One hundred, Twenty Three & Sixty Five Cents
...
Formula to sum values extracted from stringHi all
I'll preface this by pointing out that I do NOT want to use text to
columns, nor a VBA solution. I'm looking for a formula alternative -
maybe an array formula.
I have a single column of data extracted from a string, which
represents numeric values, single space-separated. The data looks like
this:
8.56 2,514.12 3.18 0.35
What I'd ideally like is a formula that sums each of the four values,
which in the above example would be 2,526.21.
Any suggestions appreciated.
>8.56 2,514.12 3.18 0.35
Assume that string is in cell A1.
Create this named...
Assign a Value to a Duplicate Entry Within the Same ColumnWithin a single worksheet I have thousand-plus rows of data and one of the
columns within that worksheet I have a series of numbers. After I've
identified the duplicates within that column I want to assign a value based
on the first time that number shows up (in this case by I'v sorted by date),
so the first duplicate would have a value like "1." I then want to assign
the next duplicate(s) sequentially (2, 3, 4, etc.) When finished I would
want a new column of data that would have far more "1s" than "2s," more "2s"
than "3s,"...
Percent value rounds up in AccessI have a table with a field that is set to Number, Double, format
percent, 3 decimals
THere is a form through which the value is entered into the table. Its
format is set to Percent and 3 decimals
When the value is entered into that field, it displays 3 decimals of a
percent - but the actual value is rounded to the second decimal point.
How can I get to display the Percents WITH 3 decimals without
rounding?
Thanks,
When I go to the Format tab of the properties sheet for the control that
displays the value and set the Format to Percent and the Decimal Places to 3,
I get a percent with three d...
How do I search for the second largest value in the array?How do I search for the second (or third and so on) largest value in the
array either in column or row?
=LARGE(A:A,2)
=LARGE(A:A,3)
=LARGE(1:1,2)
=LARGE(1:1,3)
--
David Biddulph
"Golf" <Golf@discussions.microsoft.com> wrote in message
news:241155EE-30CA-4E7C-8E8C-2215F1523919@microsoft.com...
> How do I search for the second (or third and so on) largest value in the
> array either in column or row?
Assume that you would like to get the result from A column Data.
Column:-
This will get the Largest number from A Column
=LARGE(A:A,1)
Similar ...
Hiding zero valuesI have a chart with data in Columns C and E. I want the columns to zero out when subtracted (ex:=E2-C2). My issue is I only want zeros in the answer column G to display in the rows with data, not in the rest of the column where I put the formula. Is that possible? Any ideas would be helpful. I can't hide zero values becuase then nothing in the column would display at all. I tried an If Statement but I get a circular reasoning error. HELP!
Submitted via EggHeadCafe - Software Developer Portal of Choice
A C# WaveOut API Player - Recorder Library
http://www.eggheadcafe.com/tutorials/...
how to return a xmldocument to classic asp
Hi everyone,
I'm making a SOAP request to a webservice from classic
asp with(SOAP Toolkit v3.0).
This function has to return the XML document or the
xmlstring to the classic asp page.
How can i do this?
Here is how i try todo it now:
Public Function getData(ByVal strParamValue As String)
As System.Xml.XmlDocument
Dim connIsOpen As Boolean
Dim strXml As String
Dim xmlDoc As New XmlDocument()
'Dim xmlNodlist As XmlNodeList
strParamValue = strParamValue + "%"
connIsOpen = openConnection()
If connIsOpen Then
...
Possible to hide a sub-report if NULL values?Hi,
I have created a report (column) that list open invoices and I have also
attached a sub-report (different table) that displayes comments.
Problem: sub-report is showing for all invoices, but I would like it to show
ONLY for invoices that has a comment.
That is, invoices that has no comments only list their usual values, and
invoices with comments I have a sub-report displaying the comment.
Is that possible? (otherwise my invoice-list with contain a lot of
unecessary space - used by the sub-report).
Kindly,
Mikael
Mikael Lindqvist wrote:
>I have created a report (column) that l...
Catch when the Probability value has chaged due to a Sales ProcessHi
I'm coding a callout for the CRM 3.0, I would like to be able to catch when
the opportunity's Probability value has change due to a stage change in a
Sales Process workflow.
I have the following code:
public override void PostUpdate(
CalloutUserContext userContext,
CalloutEntityContext entityContext,
string preImageEntityXml,
string postImageEntityXml)
{
string preProbability = String.Empty;
string postProbability = String.Empty;
// Get pre-values
XmlDocument preImageEntity = new XmlDocument();
preImageEntity.LoadXml(preImageEntityXml);
foreach (XmlElement elemen...
How do I chart two separate sets of x and corresponding y values .I would like to chart two sets of x and y values with each set of x values
corresponding to its own set of dependant y values. The two sets of x values
for the ordinate are entirely different. It seems like I can only chart two
sets of data on the same graph with the same values for x and two separate
sets of dependant values for y. Is there any way possible to get around this
problem?
Select your first set of X&Y data, Insert/ Chart (Chart type XY, & choose an
appropriate sub-type)/ other options as appropriate.
Now select your second set of X&Y data, Copy, select your c...
user id on posting journalHi,
I am wondering what is the logic of having the the id of the user who
printed the posting journal rather than the user who posted the transaction?
is there anyway to change this logic
Regards,
Michael,
IMHO, the logic is that when you have 5 users all printing reports to the
same printer and not picking them up right away, it's helpful to have the
user who printed in the header to figure out who each printout belongs to.
The user who posted the transaction is stored in the database, and while I
have not tested this for all posting journals, I believe you can add it on
most of t...
Cell Value as Named Range ReferenceLittle bit of a quirky question...
Trying to use a cell value as a reference in a formula, where that
cell value is the name of a named range.
So, assume A1:A3 is a named range: Rng1. And, B1:B3 is Rng2.
I want to get the correlation vale for A1:A3 and B1:B3
So, cell D1 contains "Rng1" and D2 has "Rng2"; and cell D3 has the
formula: =correl(D1,D2). But I get an error. Have also tried using
Indirect to no avail.
Any help would be hugely appreciated. Thank you.
=CORREL(INDIRECT(D1),INDIRECT(D2))
--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music
"ste...
How do I change FALSE values to 0?How do change values of TRUE or FALSE to 0?
what is the formula you are using?
"Redleg40" wrote:
> How do change values of TRUE or FALSE to 0?
=IF(AD7<0,AD7*-1)
&
=IF(AD13>=0,AD13)
"Jambruins" wrote:
> what is the formula you are using?
>
>
> "Redleg40" wrote:
>
> > How do change values of TRUE or FALSE to 0?
Put a 0 in for the value_if_false argument. Standard IF syntax
=IF(condition,value_if_true,value_if_false), so for your first formula
=IF(AD7<0,AD7*-1,0
--
MrShort
----------------------------------------...
Icon SetsI would like to display in cell A2 a red diamond if the value in
U2="Storage"; a Green Circle if the value in U2="Central Files" "Office" or
Floor"; and a yellow triangle if the value in U2="Missing".
I saw the response to "ICON Arrows UP or DOWN", but I couldn't understand
where the different parts were supposed to go.
Nolene, you can put an IF statement in column A that reflects the information
in column U:
=IF(U2="Storage", 1,IF(or(U2="Central
File",U2="Office",U2="Floor"),2,...
Lookup query value from FormHello.
I have a form that I would like to lookup values in several taxt
boxes. The values I want displayed are from several different Sum
Queries.
Example: I want to pull Total Working Blance from a query and monthly
rent revenue from another query. The values all come from different
tables.
Is this possible?
Thanks for the help.
you can use a DLookup() function to retrieve the queries' values. read up on
the function in Access Help, so you'll understand how it works. then add an
expression to each textbox control's ControlSource property, as
=DLookup("MyField", ...
Find the top value in a listI have a worksheet created in EXCEL 2003 which i use to record swimmers times
in several lists. One examlpe is in cells D109 to 113. In cells D111 to 113
are recent times and D109 to 110 are empty. As I add current times to the
top of the list. I want to be able to retrive the current value at the top
of the list and show it in D106. D107 & 108 are used for other values. At
present I have the following formula in cell D106
=OFFSET(D108,COUNTBLANK(D109:D113)+COUNTA(D109,D113),0). This works well but
makes updating the list difficult. Is there a simpler way to achive the same...