Reply:

excel #35
i want to try this again. I am trying to determine a winner for each county. In b5:e5 I have my canidates. In column A6:a139 i have my counties, B6:E6 i have the votes for each canidate. in G6 i have my total votes, and in H6 i need to input the winner by name using a formula. I tried =index(b5;e5,match(max(b6:e6),B6:e6)) that gave me the person with the least votes and i need the highest votes. Please tell me what am i doing wrong. I am on windows vista home premium, excel 2007, service pack 1 thanks Shone > =index(b5;e5,match(max(b6:e6),B6:e6)) You must set MATCH to look f...

Postcard conversion...
I have been printing 5 1/2 x 8 1/2 cardstock postcards and would now like to convert my 2 per page size to 4 per page or 4 x 6 size postcards. How can I convert my larger graphics and text w/o having to go thru the madness of cutting, pasting, and resizing everything to the smaller size postcard? Thanking you in advance. Frank Engels ...

VC6 -> VC2005 conversion problem
Hello, I'm converting my project from VC++6 to VC++2005. among many compilation errors now solved, that one is stucking me : I have that template : template <class T> class TLineApproximator { public: //! \name Structures and typedefs //@{ //! 2D homogenous point struct SHomog { public: SHomog(T _x=0, T _y=0, T _w=1) { x=_x; y=_y; w=_w;}; T x; T y; T w; }; //! 2D point struct SPoint { public: SPoint(T _x=0, T _y=0) { x=_x; y=_y;}; static void CrossProduct( const SPoint& p, const SPoint& q, SHomog& r) { r.w = p.x * q.y - p.y * q.x; r.x...

Is it possible to view Excel split screen by tab within same file
I would like to view split screen tabs within the same Excel workbook. Is this possible? Hi SS. Go to Window - Arrange - and select the view you would like. It shows all tabs. Minimize or close the ones you don't want. I find the vertical view the easiest to use. HTH -- Sincerely, Michael Colvin "SS" wrote: > I would like to view split screen tabs within the same Excel workbook. Is > this possible? Window|new window Window|Arrange (horizontal/vertical/whatever you want) Check windows of activeworkbook (if you only want that one workbook) You'll see som...

Outlook 2003 Cached Exchange Mode freezes up
We're using Outlook 2003 with the cached exchange mode set. Sometimes desktop computer email will not update when in cache mode. What is required to fix this problem? Thanks, Jim ...

Converting from Pockect Excel to Excel XP
I setup a mileage sheet for my Pocket PC which has Pocket PC 2003 that came with Pocket Excel. When I formated the sheet some of the cells have boarders and others do not. There are a few cells that are irregular from the others, for example Column B3 - B34 all have a full boarder then in Column C the full border extends down all the way down to C35, there is then additional data with just a bottom boarder on D38. This leaves Cell A34-A38 with out any data or boarders at all and this is exactly how it locks on the Pocket PC. How ever when I transfer the excel file to my Home Computer...

Excel 2007 "document not saved" when on a network share AND file set as an offline file
Hello~ Have this annoying REPEATABLE problem with Excel 2007 running on Vista Business saving to a share on Windows Server 2003. On the client, Vista and Excel all up-to-date with SPs, the machine is part of a domain, and some files on different shares are set to be available offline. On the server, Windows 2003 also up-to-date, the client user has full permissions in all the directories in question - both share permissions and NTFS permissions), and the directory is set to make only files users specify to be available offline. Client has no problem opening and saving files in Excel that ar...

MOVING DOCUMENT IN EXCEL
I NEED TO MOVE THE DOCUMENT UP, IT IS SHIFTED DOWN TO WHERE I CANNOT SWITCH TO THE OTHER WORKSHEETS Window|Arrange|Tiled and resize by hand?? LAURA wrote: > > I NEED TO MOVE THE DOCUMENT UP, IT IS SHIFTED DOWN TO > WHERE I CANNOT SWITCH TO THE OTHER WORKSHEETS -- Dave Peterson ec35720@msn.com ...

Conversions
Hello! I work as an Information Specialist. Majority of our job requests involve conversions. We just received an Adobe Acrobat pdf in which the original document was created in MAC OS. The conversion was successful through Omni Page as we only needed to capture text to convert to a Word document. I was wondering is there any other suggestions you can recommend for conversions from other softwares such as MAC. Thanks so much for your time. A PDF file is a PDF file, no matter which OS was used when the file was created. If you want conversions for specific Mac formats t...

where do i ope PHStat in excel
i have installed PHStat for excel on my computer, but i dont know where to open it once ive opened excel. i have office 2003 so any help would be great, thanks Ramsbee987 - > i have installed PHStat for excel on my computer, but i dont know where to > open it once ive opened excel. i have office 2003 so any help would be > great, thanks < First choose Tools | Add-Ins. It should be listed, and be sure there's a check mark. Then a PHStat item should appear on the menu. - Mike www.mikemiddleton.com If you have phstat and excel on the desktop, you can drag phstat on...

Outlook 2003
Exchange 5.5, sp4 - Outlook clients using 2003 or XP are getting the popup messages that Outlook is attempting to contact the exchange server. This happen very frequently and is annoying my users. I know we can turn that option off - but management now thinks that my exchange servers are to blame. Has anyone else seen this or having the problem? My Outlook 2000 users are not experiencing any latency etc - only 2003. Maybe a registry hack we could do during installation? Any ideas? TIA Nancy Stevens Nstevens@tycoint.com ...

excel as a repository
why is it that people use excel for a repository? i mean-- Access was used to store data-- Excel doesn't have the basics for storing data. i mean-- why do people use Excel EVER? it kinda blows my mind.. i just wish that you kids would grow up and learn a real program. i mean-- im trying to import data from Excel into a database-- and i have this column that Excel keeps on coughing on.. i mean i just dont understand why people make all these pretty reports in Excel-- the problem is that Excel is a complete 1 way street. Give excel real validation-- give excel the ability to store data...

TYPE CONVERSION
My goal is to automatically update the End Date to display the create date from a record previously reported. For example the end date for the first record listed below should be 9/24/2009 12:41:00 PM and the end date for the third record listed below should be 8/21/2009 9:00:00 AM. ID CATEGORY RANGE CREATE_DATE END_DATE 3426 Service 24 months 9/15/2009 9:35:00 AM 3426 Service 24 months 9/24/2009 12:41:00 PM 3426 Service 36 months 8/20/2009 12:23:00 PM 3426 Service 36 months 8/21/2009 9:00:00 AM I have the query listed belo...

Cannot select and then copy an entire worksheet, in Excel 2008
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Have been using excel 97 2004 with no problem for years. Now have new Mac and new excel spreadsheets which are 750 times bigger. Now, as earlier, I can still 'move and copy' a sheet over to a new workbook, but when I select the entire sheet (top left corner), then 'copy' the selection, excel freezes, and I am warned there is not enough memory. <br><br>I want to be able to create individual invoices from my own invoice template spreadsheet (which contains formulas referring to custome...

how do u get Excel file sizes smaller?What takes up so much space
Sometimes Excel files get incredibly big very fast apparently without adequate reason. Once big one seems to never be able to get them smaller again. Any ideas why and how to reduce? What are the factors that one must avoid if one needs small files? (My current file has jumped to 42Mb and needs to go back & forth over slow dial-up lines. Zip only reduces it to 39Mb). Thanks A couple of things I have noticed along a similar line .... I sometimes copy a large file into a worksheet, then delete a lot of it to retain only the parts I need. If I save it while the large file is there, ...

Pasting Word table cell with paragraph markers into single Excel c
I have a Microsoft Word document that contains a table, each cell of which may contain paragraph markers. I need to copy and paste this table into Excel. However, whenever a cell from the Word table contains paragraph markers, rather than pasting the contents of the entire cell into a single cell in Excel, the paragraph markers are treated as delimiters, and the data is pasted into multiple Excel cells. If the cell from the table in Word contains one paragraph marker, then when I paste that cell to Excel, it pastes it into two cells. If it contains two paragraph markers, then it pa...

Excel File Overwrite
How can I restore an overwritten file? I was backing up my files and I accidentally saved an old version instead of the new one. This sets me back to May 2009...I cannot find the file I used on Friday Jan 16, 2010. Help please!! Hi, Check with IT if the have backed up your file, or see if you sent the file by email to someone, otherwise sorry but the file is gone "GradAsh10" wrote: > How can I restore an overwritten file? I was backing up my files and I > accidentally saved an old version instead of the new one. This sets me back > to May 2009...I cannot ...

Outlook 2003 Sort issue
I am using Outlook 2003. The issue, which is Intermittent, when i'm viewing my mailbox and i click on an email just to highlight but not open and then click on the subject column to sort by subject. The mail sorts by subject but the email that i had highlighted isn't highlighted anymore and is lost in the sort. My mail is being delevered to a .PST file and i am running windows XP. Has anyone seen this problem? Please help Yes, I've seen that behavior before. I don't think there's any fix for it, unfortunately. -- -Ben- Ben M. Schorr, MVP Roland Schorr & Tower htt...

Copying formulas in excel
I have the column A full with 252 entries. The formula I apply between cells A2 and A1 is: ln(A2/A1) and I get a result. I want to copy this formula but in a way that the Excel itself to perform the following calculation: ln(A3/A2) ln(A4/A4) ln(A5/A4) etc. I would be pleased if someone could tell me if I can achieve that. -- antonis Click on the first cell with a formula in it. A small black square should be at the bottom right corner of the outline of the cell. Click and drag this cell down; it should copy the formula the way you want. Szalapski -- TommySzalapski ------------------...

M2004 Deluxe-TIRA to Roth Conversion Question
Hi, I am using MS Money 2004 Deluxe. I did a Traditonal IRA conversion to a Roth back on Nov 24th. The conversion was with the same mutual fund, ticker symbol. How do I do the transaction within Money to effectively close the TIRA and have the Roth Start on 11/24/08? I want the converted amount, for tax purposes, to show up on the Money Home page. Thanks! Transfer Out investment activity? "Mike" <Mike@nothere.com> wrote in message news:%23UAtIoDaJHA.3908@TK2MSFTNGP06.phx.gbl... > I am using MS Money 2004 Deluxe. I did a Traditonal IRA conversion to a > Roth b...

Ho wto display a list of appointments in outlook 2003
HI I'd like to find a way of displaying a list of my appointments similar to the task list option. Is there any way? cheers DW ...

Excel Protection
I have set up an excel spread sheet and have used the data group an outline function to group rows together. .However when I choose sheet protection I am unable to use the grou and outline function. I also need to protect certain cells within the document, whil allowing users to edit pther ranges. Any suggestions gratefully recieve -- Message posted from http://www.ExcelForum.com Hi james Right click on the Sheet Name Tab and select "View Code" and paste in the code below Private Sub Worksheet_Activate() Me.Protect Password:="Secret", UserInterfaceOnly:=True ...

excel organizational chart subordinate goes left not down
Trying to create an excel organizational chart but the subordinate selection goes to the left as though it were an assistant choice and not underneath as the diagram suggests. How do I get the subordinate underneath and not to the left or right? ...

Conversations
I have searched for and got a list of 70 items in my inbox, which I now view as conversations, bbut the count at the bottom of the screen still shows '70 items'. Is there a quick and easy way to count the number of conversations, rather than the number of items? Thanks, G No. <george.walsh@doeni.gov.uk> wrote in message news:6798cc53-de91-4772-be4e-9de69dc45289@w40g2000hsb.googlegroups.com... >I have searched for and got a list of 70 items in my inbox, which I > now view as conversations, bbut the count at the bottom of the screen > still shows '70 items'. ...

Problem with Excel Help
WIN XO HE, XL 2002 SP3 Hi, every time I hit F1 within Excel, I am getting the following error message: "The window name "langrep" passed to HH_GET_WIN_TYPE has not been specified." Any idea how to fix that? Tx, S I have no idea, but I'd start with: Help|Detect and Repair (or maybe reinstall excel/office) (I have no idea what "WIN XO HE" is either--winXP Home???) saturnin02 wrote: > > WIN XO HE, XL 2002 SP3 > Hi, every time I hit F1 within Excel, I am getting the following error > message: > "The window name "langrep" passed...