I need to compare 3 numbers and find the one in the middle
I have three numbers in a single row and would like to identify the middle
number enter that number in another cell.
1st # 2nd # 3rd # result
628 678 720 678
655 625 700 655
748 720 725 725
is there a function in excel that can do this?
VBA Noob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3383
View this thread: http://www.excelforum.com/showthread.php?threadid=56811
fasteddie wrote.....Find Duplicate names and delate
I have a small doubt could you clarify that???
That is I find duplicate name but I want to delete one name only, if I
filter DUPLICATE….. both names are showing…
1. Select the range of data including the header. You need to have headers
for these columns
2. From menu Data>Filter>Advanced Filter>Copy to another location
3. In 'copy to' specify the target cell and check 'Unique records only'
4. Click OK will give you the unique list
"Find Duplicate names and delate" wrote:
> Dear experts,
> I have a small ...Finding a Median
I'm trying to write a query that will return a median for various
values taken from a previous query. I've seen some suggestions in my
searching, but I haven't been able to get them working. They are also
all from before 2003 and refer to Access 97 and 2000.
Has any functionality been added to 2003 for this? Or is there a non-
code-based way to do it? I've seen it suggested to write a code to
open the query, sort it, find the total number of records, divide it
in half, then seek out the middle record using that value. I'm still
very green when it comes to code, though...Find a Value the first Time It Occurs
I have a row of values that shows the total cumulative number of sales of
items by month. Occasionally, there may be no sales in a month for an item
so the cumulative value would stay the same for more than one month. I want
to select a number in the row the first time it occurs and not select it if
What are you wanting to do with the info?
To return position (column number) of number 1234 within row 2:
A formula that signals it's the first occurence:
This could be used in a helper row, or as a conditional format f...Autofill Worksheets
Is there a way in Excel 2000 to rename the first two
worksheets and then use an autofill type feature to add
more worksheets with a series of names? For example, name
one worksheet January, the next one February, then insert
new worksheets that would be automatically named the
i would probably approach it this way,
choose tools / options / general
change "sheets in a new workbook" to 12
open a new workbook - it will have 12 sheets
go back into tools / options / general and set the sheeets back to 3
then run the following code
Sub n...Ressource Name for External Link
When connecting a user and going to his project on PWA, Ressources names
appear. However, if the link is an external to another project, the name of
the External Ressource name does not appear.
Does anyone know how to solve this problem?
This is not a bug in the software. External links only include a small
amount of information, and does not include the resources assigned to the
external task. Furthermore, there is no way to force the external task to
display resource names, but perhaps you could write custom code in VBA to
extract this informa...Find/Replace in RichEdit 2.0
I'm using Windows ME and I've switched from RichEdit 1.0 to 2.0 for my
CRichEditDoc/View application so that I can use the ITextDocument
interface and can do things such as suspend/resume the Redo buffer.
Problem is, now the Find/Replace dialogs don't seem to do anything. If
I revert back to RichEdit 1.0 they do!
What's going on?
firstname.lastname@example.org (Adrian Gibbons) wrote in message news:<email@example.com>...
> I'm using Windows ME and I've switched from RichEdit 1.0 to 2.0 for my
> CRichEditDoc/View application...Linking Contacts in Outlook 2007
I just converted from Outlook 2003 to Outlook 2007. In Outlook 2003 at the
bottom left of the address card was a field in which you could link the open
contact to other contacts in your address book. That field does not appear in
the address card in Outlook 2007. Can someone help me figure out how to make
that field appear? Thank you.
That option is here:
Tools > Options > Preferences > Contact Options... > Show Contact Linking on
"JMD01519" <JMD01519@discussions.microsoft.com> wrote in message
news:BACF9C2B-6FAC-48F4-B...Find (but not find)
My program takes a name from sheet3 goes to sheet1 to Find the name.
If it cannot find name, how do you do an If/End to Exit Do while or
find out if name has been founf? I have "On Error Resume Next" in
Thanks again for all your help
As ALWAYS, post your code for comments & suggestions.
Microsoft MVP Excel
"Gordon" <firstname.lastname@example.org> wrote in message
> My program takes a name from sheet3 goes to sheet1 to Find the na...Linking tables together
I have set up five tables in my database but now I want to merge the
tables into one table. How do I do that?
If all the tables have identical structures, you can use a union query.
Select * from tbl1
Union Select * from tbl2
Union Select * from tbl3
"Maggie" <email@example.com> wrote in message
>I have set up five tables in my database but now I want to merge the
> tables into one table. How do I do that?
You are best not to. The information in the tables will refer to a sp...Finding an event
I am developing an app that uses a single worksheet to enter data. When user double clicks a button, a new window (in same workbook)
opens with a new sheet. My problem is that excel does not seem to have any events for close of window if there are multiple windows
in a workbook.
Can someone help
That triggers the Workbook_WindowActivate event, you can use that.
"Peter Ostermann" wrote in message
I am developing an app that uses a single worksheet to enter data. When user
double clicks a button...is there a comand to return the mane of a worksheet inside a cell
Trying to find a command that returns a worksheet name inside a cell
This one will give you the full path: =CELL("filename")
"Fabian" <Fabian@discussions.microsoft.com> wrote in message
> Trying to find a command that returns a worksheet name inside a cell
=MID(CELL("filename...Find value in a column and insert rows above
The set up looks like this:
ColU ColV ColW ColX
Y N N N
Y N N N
N Y N N
N N Y N
N N Y N
N N Y N
N N Y N
N N Y Y
Columns will always be U through X and will always be sorted in this order.
I need to find the first Y in each column and insert 2 rows above that row.
On the blank row above the first Y, I need to highlight in yellow and put
title in the first cell, such as New, Old, Existing, Deleted.
Any help would be greatly appreciated.
Thanks for your time,
If desired, send your file to my address below. I will only look if:
1. You send a copy of this ...link .pub files
I have produced a series of .pub files [Publisher 2003] for a book - each has
illustrations, footnotes etc as separate text or picture boxes. I now want
to put all the chapters into a new .pub file so that I can take the complete
book to a printer - but I can't find a way to do this!
Best 'fix' so far has been to save each chapter as a Word file and import
that into a new .pub file. But that does not deal with the pictures, which
all have to be re-inserted in the precisely correct position.
there MUST be a better way! Or is it another problem with Publisher, like
the inabi...Sum if Condition is Equal in Range Date and find column
I want to make a sum if Range is a week number and if style is Equal to
CONC-92 or CONC-45
Week# 49 Week# 50
CONC-92= 27 CONC-92= 30
CONC-45= 27 CONC-45= 30
Datas are in a pivot table and...
Pivot table looks like this:
Date CONC-92 CONC-45 CONC-92 CONC-45
12/7 5 5 10 10
12/8 2 2 10 10
12/9 5 5 10 10
12/10 5 5 10 10
...How to make "This workbook contains links to other data sources" appear?
How to make "Microsoft Excel
This workbook contains links to other data sources
To update all linked information, click Yes.
To keep the existing information, click No." pop up or appear on the Task
bar after clicking "Open Link" in "Linked Worksheet Object" in a context
menu of a linked object in Word 2003 sp2? The window appear only after
clicking an Excel button in the Task bar.
...cannot find database
I have an excel spreadsheet that is supposed to update a access db.
Whenever I try to save the .xls I get an error stating cannot find db.
Even when I open the db with access, I get the error and the db opens
anyway?????? This only happens on 2 out of 20 pc's and I cannot figure
...Trapping a NO FIND after a find
I use the code below to store a row number to a variable after a find.
I would like to trap a NO FIND if the find is unsuccessfull
Any ideas. FSt1 provided the code below
dim rn as string
dim rng as range
dim therow as long
rn = inputbox("enter something to find")
if rn <> "" then
Set rng = nothing
Set rng = range("A1:IV65536").Find(what:=rn, _
...How do I find the out of office reply?
My out of office reply is missing from tools. How can I retrieve it?
Out of Office reply <Out of Office firstname.lastname@example.org> wrote:
> My out of office reply is missing from tools. How can I retrieve it?
Unless you are using an Exchange server, you will not have the Out of Office
Assistant. See this: http://www.slipstick.com/rules/autoreply.htm
...How to reduce the number of shortcuts/links in the recent documents list?
When I look into the folder:
C:\Documents and Settings\<username>\recent
then there are currently approx 20 recent documents listed.
How can I permanently reduce the number or even disable this list?
Cindy Parker wrote:
> When I look into the folder:
> C:\Documents and Settings\<username>\recent
> then there are currently approx 20 recent documents listed.
> How can I permanently reduce the number or even disable this list?
Right click on the Start button and choose Properties --> Customize
...Removing Linked Worksheets in Excel
We have a file that has bounced around over multiple years, under multiple
versions of Excel, that contains links to various Source Files. Whenever
the file is opened, it asks if we would like to update the information in
the linked documents. Click NO makes the file usable, so there is no lost
data. It is just a bit annoying to have to continue to do so.
Some of these files exist, and some have not existed for years. In either
case, we have been unable to remove the link to the files that are
referenced. The status on each of these linked source files is A.
Any ideas/help/direction on ...copy to different worksheet
Here's my problem.
In worksheet 1, I have summation formulas in a one row, at a4, b4, c4, d4
I want to put the results of the above sum formulas into a different
worksheet and put them in one column, such as a1, a2, a3, a4 and a5.
Can anyone help me?'
Try this in A1 of Sheet2, and copy down:
Please keep all correspondence within the Group, so all may benefit!
"jskamm" <email@example.com...office link
Can any one help.
I have a error - null command file entry in swdrvs appear when i try to
merge a letter in the card area of myob can any tell me how to fix this.
Sounds like an MYOB problem to me. Look for assistance in the MYOB forums
Hope this helps,
Doug Robbins - Word MVP
Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.
"gb007" <firstname.lastname@example.org> wrote in message
> Can any one help.
I have a excel doc that has 4 tabs(sheets) named AIX, HPUX, Windows
Other. Each sheet is a listing of all our servers of each type and th
relevant info on each (hostname, location, version, vendor, dat
purchased, etc..). Each sheet is also auto-filtered on the top row b
I would like to add a 5th sheet called "All" that list's all of ou
servers on one sheet. Is there a way to create this sheet so i
automatically gets it's data from the other sheets and is updated whe
the others are updated?
Message posted from http://www.ExcelForum.com
I th...Finding numbers in rows and highlighting them
Hi everybody :)
I need help.
This is a lotto system.
I have a spreadsheet with 508 rows and 45 columns.
In each row there are 45 numbers mixed (1 to 45).
I need a script or some other way to find where particular (drawn)
numbers are in each of the 508 rows.
If my explanation is not clear please ask for farther clarification.
Thank you in advance for your help.
Johncobb45's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1658
View this thread: http://www.excelforum.com/showt...