Reply:

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. Example: 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? Thanks, Eddie Try =LARGE(A1:C1,2) VBA Noo -- VBA Noo ----------------------------------------------------------------------- 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
Dear experts, 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 -- Jacob "Find Duplicate names and delate" wrote: > Dear experts, > I have a small ...

Distribution List #23
I need to copy a distribution list from one users Outlook 2000 to another. I don't want to copy the entire Contact list, just one distribution list. Thanks -- Jerry Not sure what kind of e-mail account type you are working with, but try creating a new PST and then copy the personal distribution list that is in the primary contact folder to the new PST. Close the new PST and then e-mail that to the other user. /neo ps - if both users are in the same microsoft exchange site, you don't have to use a PST. you can attach the personal distribution list from the contact folde...

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 it repeats. What are you wanting to do with the info? To return position (column number) of number 1234 within row 2: =MATCH(1234,2:2,0) A formula that signals it's the first occurence: =COUNTIF($A2:A2,A2)=1 This could be used in a helper row, or as a conditional format f...

Code Line to Empty Clipboard
Temporary memory loss: There is a single line of code that will empty/clear the content of the Clipboard. Entering the statement = False performs. what is it? ???????? = FALSE Tks in advance,, Application.CutCopyMode = False -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "JMay" <jmay@cox.net> wrote in message news:tXwLb.70607$hf1.60972@lakeread06... > Temporary memory loss: > There is a single line of code that will empty/clear the content of the > Clipboard. > Entering the stateme...

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? BUMP! adriangibbons@yahoo.co.uk (Adrian Gibbons) wrote in message news:<34a2acd5.0404130713.123dbaab@posting.google.com>... > I'm using Windows ME and I've switched from RichEdit 1.0 to 2.0 for my > CRichEditDoc/View application...

Check if a row is empty
I have a table that can contain emtpy rows. Row is considered empty when all the columns (except the primary) are NULLs. Is there a function in Sql Server to test if a row is empty? On Jun 17, 2:42=A0pm, sChapman <sumant...@googlemail.com> wrote: > I have a table that can contain emtpy rows. Row is considered empty > when all the columns (except the primary) are NULLs. Is there a > function in Sql Server to test if a row is empty? select * from tables where col1 is null and col2 is null and col3 is null..... so on Amish Shah http://shahamishm.blogspot.com Pe...

Distributed Processes box is grayed out
I'm trying to set my User Preferences to make use of a process server, however, the radiobuttons in the Distributed Processes box are grayed out. I'm Poweruser and the process server is set in DPS setup. Is there any product/module that I need to install or register? Thanks, Hector ...

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 program. Thanks again for all your help Gordon As ALWAYS, post your code for comments & suggestions. -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com "Gordon" <gwelch1938@yahoo.com> wrote in message news:1184612089.486737.144020@n60g2000hse.googlegroups.com... > My program takes a name from sheet3 goes to sheet1 to Find the na...

Finding an event
Hello, 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 Peter Peter, That triggers the Workbook_WindowActivate event, you can use that. HTH Bob "Peter Ostermann" wrote in message news:i9m5v8$7bv$02$1@news.t-online.com... Hello, I am developing an app that uses a single worksheet to enter data. When user double clicks a button...

Lost Recent Documents List
Following a recent windows update my list of "recent documents" in all Office applications disapears every time my computer reboots. Is there a way to fix this? SeattleMike56 wrote: > Following a recent windows update my list of "recent documents" in all Office > applications disapears every time my computer reboots. Is there a way to fix > this? You haven't said the version of your Office but assuming you are using Office 2007, then open Word 2007 and try this: 1. Click the Microsoft Office Button, and then click Word Options. 2. Click ...

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, Dee If desired, send your file to my address below. I will only look if: 1. You send a copy of this ...

List Validation
I was wondering if there was anyway you can have a drop down list in one workbook that comes from a different workbook. Example: I have a workbook saved with a list of names and I want to have that list of names come up in a form that I have saved in another workbook. http://www.contextures.com/xlDataVal05.html note that the other workbook needs to be open -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Renee" <...

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 out why???????? Thanks ...

Limits in 'All Address Lists'?
Hi all! I try to rebuild a large number (~2000) of Ex5.5 recipient-containers in the E2k3 'all address lists' container. The LDAP filter for each address list is set on to the EX5.5 attribute 'obj-view-containers' (transferred to 'extension-Attribute-14' by ADC). I recognized that the AD-user attribute 'ShowInAddressBook' is a multi-valued field, with a limitation of around 800 entries (RUS won't work with more entries). This doesn't matter, because a recipient belongs only to 1 address list in most cases. Meanwhile I created about 1200 address lists...

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 please help -- Lorenzo Díaz Cad Technician ...

How do I create a comparison chart from a data list?
I want to create a bar chart. On the left is a list of services. Each bar represents a company. Each company will be shown in the chart to offer services up to a certain point, so the bars will get increasingly longer until you get to the bar for my company which shows the longest bar because it offers the most services. Any idea how to structure my data to get this type of chart? -comic guy I don't know if this will work for you? Just a suggestion +------------------------------------------------------------------- |Filename: Services.zip ...

Outlook Mail: creating a quick mail list?
In my previous version of Outlook, I somehow created a new button for my "Mail" section that contained the 4 or 5 most frequently used e-mail addresses. When I wanted to e-mail one of these people, all I had to do was click on the drop-down menu and then click on the specific person, which then created a new untitled message form addressed to that person. Unfortunately, I lost this when I upgraded to 2003! Does anyone know how I can create the same again? Jay It is discussed in my guide which you can find here; http://www.sparnaaij.net/howto/customizetoolbar.htm -- Roady ...

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 Sub macfindrow() 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, _ After:=Range("A1"), _ Lookin:=xlformulas, _ Lookat:=xlpart, _ ...

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 reply@discussions.microsoft.com> 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 -- Brian Tillman ...

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 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? > > Cindy > Right click on the Start button and choose Properties --> Customize ...

Can't empty trash
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Email Client: pop I copied some photos of myself (taken by a newspaper) from a PC to my iMac OS10.6. Then I tried to delete them, and eventually got rid of them one by one. But the empty folder is parked stubbornly in the trash can, and I get the message 'Photos Pat still in use' -- which they are not. I went to the info section, and nothing is ticked there that should prevent deletion. Annoying the hell out of me, because I like to be tidy. Can anybody help? Please. Pat On 1/10/10 5:01 AM, Patrick_Hu...

using new List<String>();
Hello, I wonder do I create a memory leak by using private void myFunc() { List<String> joblist = new List<string>(); // ... add a alot of string into the joblist } and then call myFunc "repeatedly" from the main program It feels like I should return the memory somehow, but how? // Anders -- English is not my first language so any error, insults or strangeness has happend during the translation. Please correct my English so that I may become better at it! On 5/26/2010 11:02, Anders Eriksson wrote: > Hello, > > I wonder do I crea...

List box (and queries) not sorting dates or showing correct headers
G'day all, I have inherited a system with a search function screen that is acting weird. There are actually two search screens, both constructed in a similar fashion, but the first does what it is supposed to do and the second is misbehaving. The form has a bunch of unbound controls allowing the user to enter search criteria. The only mandatory criteria is the sort order, which is set from a combo box. The data source for the combo box is a table, sys_GAPSSortBy, which contains a list of query names and a user- friendly label for use by the combo box. When the user clicks the "Searc...