Can you search for a value output by a formula?
I want to search for a value in a cell that comes from a formula. for
example, if I have =A1*A2=15.58 in cell A3. I like to do a search for 15.5
and arrive at cell A3. Is that possible? thanks.
Hold down [CTRL] and press [F].......that's a shortcut for <edit><find>
Find what: 15.58
Click the [Options] button
Look In: Values
Click [Find Next]
Does that help?
> I want to search for a value in a cell that comes from a formula. for
> example, if I have =A1*A2=15.58 in cell A3. I like...sumif criteria using date
How to put in the criteria if I want to sum Column 'B' if month in
column 'A' doesn't exceed MAR-2011
If those values in column A are real dates:
> How to put in the criteria if I want to sum C...remote database needs prefix database in sql
I'm trying to write some SQL for a remote sql05 database and it requires me
to prefix any table names with the database name.
Is there anyway around this, kinda clutters up the sql, i think.
This is the way object identifiers work. :)
You can, however, use synonyms on SQL Server 2005 (and above).
Matija Lah, SQL Server MVP
what does it mean when some databases require it and others don't?
> This is the way object identifiers work. :)
> You can, however, use...Workflow based on create Product entity -- possible?
Sorry if this is an elementary question -- I'm kind of fumbling my way
around on this, and I haven't found any documentation or resources on
any other sites that directly answer it.
The basic workflow I want to accomplish is for our accounting
department to be notified (via email) when a product specialist adds a
new Product to the system.
I'm trying to use Workflow Manager to create a new workflow based on
the create event for the Product entity type, but that type isn't in
that primary list in Manager. I see maybe 25 built-in types in there,
but not Product.
What criteria should be placed on the textbox "qty" on Form1 so that the
quantity that is going to be purchased should not exceed the quantity on hand,
which is shown on the textbox "unitsleft". Also if the quantity purchased
exceeds the quantity on hand, what should i do so that the quantity purchased
will equal the quantity on hand so that it will just purchase the remaining
units instead of exceeding the quantity on hand. Is this possible? If so,pls
Pls reply ASAP! Really needed! Thanks again!
Message posted via AccessMonster.com
http://www...installation error, 2003 server, active dir needs to be in native mode
I was able to change exchange server from mixed to native
mode but am not finding anything specific to "active
directory needs to be in native mode" error message. The
installation stops at this point.
This is done from the AD admin utilies. The Implementation Guide (IG.PDF) has
the directions in it. In one of the AD admin tools, you get to the properties
fo the domain and then change the level of the domain.
On Sat, 24 Apr 2004 04:16:51 -0...Need help with the following code
I got the following code which is giving error in the strTSQL statement. I
appreciate any help. Thanks
Public Sub ExecutePassThrough1(strParam As String)
Dim strTSQL As String
Dim strQueryName As String
strQueryName = "Query1"
strTSQL = "EXEC sp_gettitles " ' & strParam & "'" -- problem with
Call BuildPassThrough(strQueryName, strTSQL)
On Jul 20, 1:30 pm, Jack <J...@discussions.microsoft.com> wrote:
> I got the fo...need drop-down arrow in cell
I want to create a spreadsheet for others to update by
adding a row of data and filling in the required
information described by column headings. Some columns
will require a choice from a list of categories while
others are freetext. For the category columns, is it
possible to provide a combo box type list upon clicking on
the appropriate cell that will display the categories and
allow the user to choose one. Upon choosing the category,
the value is entered in the cell. I do not want to draw a
combo-box control in every cell of the sheet and I also do
not want to create in input form...Using COUNTIF with MONTH in formula
I have a number of formulas where I use the COUNTIF() formula to
count the number of occurences of a particular item in a range.
Now I would like to use in it conjunction with the MONTH() formula
and a list of dates to count the number of dates that occur in
a particular month.
For example, range A1:A100 contains dates and I want to know how
many of the dates occur in June. Given that MONTH returns numbers
1-12, I've been trying something like this:
but I can't get it to work. I've tried using the CNTL-SHIFT-ENTER
to get this to work as an...hide rows based on cell value
I'm new to Excel and VBA. I try to hide rows based on whether the user enters
a specific word(s)/phrase into a specific cell. For example, if cell M49 has
a value of "i love lucy", then unhide rows 50 through 55, if cell M49 is
empty or has any other value than "i love lucy", then hide the rows. How do I
' Sheet 1 Class Module
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("M49")) Is Nothing Then Exit Sub
If LCase(Range("M49").Value) = "i love lucy" Then
Range("A50:A55"...If formula #3
I am trying to find an if formula that says if the result of A-B is less than
..03 then 0 but if the result is less than 0 (example -.03) than show result.
The reasoning may help. We don't want to be bothered with amounts less than
3 cents but we do want to display the credit balances because we have to
refund the amount.
Another way of trying to explain what I am trying to do is if the result of
A-B is either .01,.02,.03, than just make it 0 but if it is -.01 show result
Any help would be appreciated.
&...Is the IF statement what I need?
I have two cells that each have drop down lists. The first cell has the text
yes and no, If i choose yes i want the second cell to return N/A for example,
and if it is no I want the drop down list to be usable in the second cell.
Thanks for any help
Yes, in a word. This is what I came up with:
In cell A1, Data Validation:
Source: Yes, No
In cell B1, Data Validation:
In cell B1, formula: "=IF(A1="Yes", &qu...if formula #14
i have a column, i have to generate a formula usinfg a if statement that if
its divisable by 3 than it should be true otherwise false
(remove nothere from the email address if mailing direct)
"zomex" <email@example.com> wrote in message
> i have a column, i have to generate a formula usinfg a if statement that
> its divisable by 3 than it should be true otherwise false
> i have a column, i have to generate a formula usinfg
> a if sta...Formulas in the spreadsheet I use as a model are now incorrect.
I have a spreadsheet with formulas, columns and rows that I copy for use on a
weekly basis. This week I copied the spreadsheet and the formulas are
incorrect What happened?
That's nowhere near enough to go on...
How did you copy it? What is incorrect about the formulae?
In article <E24CAB11-20BA-4907-BB41-C57940E4B5CB@microsoft.com>,
"Lollycat" <Lollycat@discussions.microsoft.com> wrote:
> I have a spreadsheet with formulas, columns and rows that I copy for use on a
> weekly basis. This week I copied the spreadsheet and the formulas are
&g...Need help with outlook and MSN Messenger!!!
How do I prevent my Outlook from forwarding the emails I receive to my
ISP account to my MSN Messenger's email account?
Ever since I Installed office 2003, all the emails which arrive to my
ISP's email account are automatically forwarded to my hotmail account
and I want to put an end to it.
(I am using Outlook 2003 and not outlook express...)
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
..."You may need to log on as Admin......I already did?"
I tried to stop a startup task (quicktime). I got the following warning "an
access denied error was returned while attmpeting to change a service. you
may need to log on using an administrator account to make the specifidied
I am loged on as an administrator
Not really related to Media Center (the focus of this newsgroup), this
question would be better posted in a general group for whatever OS you have.
However are you in a domain environment/corporate network?
Network policies might be in effect.
James Wolf [MS-MVP]
"I...How do I create a formula in excel to automatically copy text fro.
Need to set up a workbook that copies text from various worksheets in the
workbook into a summary page at the beginning of the workbook. Cannot figure
out the forula to copy one cell of text to another cell automatically -
formulas return a value, they cannot perform an action
you can have formulas on your summary page that return
values from other parts of your work book.
this formula anywhere on your summary page will return
what ever value is in cell A1 on sheet 2.
>Need to set up a workbook t...Need Help with drop down list with conditions...
I need help.
I'm having a very difficult time creating a sequence of list which change based on the item selected on the main list, lets call it the index:
The Index list, the first list, would define vendors. In this case Hotel Companies (e.g Hilton, Marriott, Sheraton).
The following list, the 2nd list, would define properties, but the properties would vary based on which hotel company is selected (e.g. If Hilton, then "The Plaza, the Waldorf Astoria. If Marriott, then Marriott Marquis, Marriott Convention Center etc etc...) on list #1.
And Last but not least, the 3rd list would...I need to alphabetize entire excel document.
Please let me know the best way to do this.
Select your range
> Please let me know the best way to do this.
...Help with Formula Please
I have the following formula in cell c1 in a spreadsheet:
200 over - 195
200 over + 205
200 under FALSE 205
200 under + 195
What I've done above is test the formula for all four possible
outcomes. As you can see the third outcome in the table (the fourth
argument in the formula) is false, but I want it to read "-".
I have changed the formula around every way I can thi...Populate field based on combo box
I know this shouldn't be so hard - but I'm having a brain ... or something!
On a form, I would like to select a District Number from a combo box and
have the District Name appear in a text field. My form is based on a query. I
know somehow I need to add criteria to my query to point to the info in the
combo box but I'm not sure exactly where to put this criteria. Should the
combo box field for the District Number on the form be based on the
Districts table or is this the field that comes from the query? Or is it the
District Name field that comes from the query? I have neve...How do I write a formula in excel where 1 = .05 and 2 = .75 etc.
How do I write a formula in excel where 1 = .05 and 2 = .75 and 3 = 1.23?
So, if the number entered in the cell is 1 then .05 is muliplied by another
let's assume you enter 1 in A2, and in B2 you want 0.5 multiplied by cell
A12, so in B2 enter
to complete your example , if none of the 3 numbers are entered I assume you
=if(A2=1,A12*0.05,if(A2=2,your cell*0.75,if(A2=3,your cell*1.23,"")))
> How do I write a formula in excel where 1 = .05 and 2 = .75 and 3 = 1.23?
> So, if the numb...I need a templet or file for creating a personal checkbook.
I would like a templet or file that I can covert to Lotus 123 that will track
There is a few templets out there but I can not convert them to Lotus?
Any help would be appericated in advance.
...Newbie needs help with first scatter plot
I have a query with two fields: a date and a list of repeating words.
I want to create a simple scatter plot with Date on the X-axis and
Color on the Y-axis (there's only seven possible values for the words,
so I'd like each word on the Y-axis and a dot in the plot above each
date where it occurs). When I use the Chart wizard and select Scatter
Plot, the wizard is generating charts that plot *counts*, rather than
showing a single dot for each time it occurs.
I thought what I wanted to do was pre...Formula question #4
Ok, so to bring you up to speed, here's what I've got so far:
My spreadsheet contains a worksheet, which contains data from a survey
Each row is a person, each column a question, and each cell contains th
answer that that person gave to the question - either "yes", "no", o
Here's what I want to know how to do:
I made a new worksheet that I want to display short and simpl
statistical information about the first worksheet. There's one formul
that I would like to use, but can't seem to figure out. What I want i
to do is take one q...