Formula as text

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - =if(and(a2>100,a2<200),....if Only.... Hi, I'm trying to give a cell a value based on the number in another cell with =IF(AND(A2>100,A2<200),"This is between 100 and 200","No it's not between 100 and 200") this works fine, I just don't understand how to nest other OR or AND functions in there as well to give a different value if the number is between 200 and 300 and so on. This is what I've got and keep getting errors....Hope someone can help. cheers, =IF(AND(A2>100,A2<200),"This is between 100 and 200","No it's not between 100 and 200",IF(AND(A2>200,A2<300,"This is between 200 and 300","No it's not between 200 and 300"))) -- nui1 ------------------------------------------------------------------------ nui1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30046 View this thread: http://www.excelforum.com/showthread.php?threadid=497285 Tag: Formula as text Tag: 81216
  - 2
    - Integration/area under a curve VBA code? Hi I have built a spreadsheet that can calculate the area under a curve of a set of data but I would like to have this in VBA for Excel, in say Integral(C1,C2) format or a button on the toolbar. Can anyone point me in the right direction for acquiring the code? Cheers WayneL Tag: Formula as text Tag: 81210
  - 3
    - COUNTBLANK function Happy New Year Everyone, Using Excel XP. I have 3 columns of data, A1:C10. I want to count the blanks in C1:C10 ONLY if there is data in A1:A10. Example: A B C ---------------------------------------------- 1 20 6 5 2 4 1 3 8 6 2 4 4 2 5 8 1 1 6 7 2 7 3 2 2 8 9 10 In the above example I need a formula that counts the blanks in C1:C10 but only if there is data in A1:A10, so that I get a total of 3 (C2,C4 & C6 are blank). When I use the countblank function it counts all the blanks in C1:C10 (6). Thanks in advance, Mike Tag: Formula as text Tag: 81194
  - 4
    - Excel in Office 12 In Excel 12, if text in cell is very long, and you build a pivot table, it works, BUT if you and save the file in Excel 03 format (*.xls), it destroys the pivot table on opening the new .xls file. Why? Workaround? Tag: Formula as text Tag: 81191
  - 5
    - Help with Weekly Personel Schedule Hey everyone, I've been using Excel to create the weekly schedule for my department at work (roughly 8-10 people), as well as daily assignment sheets that list the people on, hours working, and an hour-by-hour breakdown of their job responsibilities. Because the hours available to my department, as well as the tasks required for completion, vary week to week, I create my schedule from the daily assignment sheets, and then transfer my work over to a weekly schedule grid (consisting of simply the name, date, and time of their shift) for posting in our back office. Example 1/1 1/2 1/3 1/4 1/5 1/6 1/7 TOTAL John 9-5 8:30-4 10-6 off off 9-5 9-5 39.5 hours Bob off off 11-4 11-4 9-5 off off 18 hours I have two questions: 1) Can I automatically import someone's time from the daily assignment worksheet and have it go into the correct cell for that persons name and day. 2) Can I have excel then add those shifts up into the total hours that person is working for the week? Could I also have excel subtract lunch breaks from that time automatically? Thanks for any help, John Tag: Formula as text Tag: 81190
  - 6
    - Cell Name Dear all, How can I retrieve the cell reference? I want to write a function MyFunction which gives the string "B3" when MyFunction() is input in B3 of a worksheet. Thanks in advance! Best Regards, Andy Tag: Formula as text Tag: 81188
  - 7
    - Work around Conditional Formatting Dear all, There are 2 worksheets (Sheet1, Sheet2) containing similar data in my workbook. I want to underline the text in a cell in Sheet2 if the text in that cell is the same as the cell in the same place in Sheet1. (For example, if Sheet1!A1 = Sheet2!A1, then Sheet2!A1 is underlined.) Can I write a user-defined function to check whether the contents in two cells are equal? Thanks in advance. Best Regards, Andy Tag: Formula as text Tag: 81185
  - 8
    - Urgent help needed PLEASE Excel 2003 - HELP ASAP PLEASE - I need Excel working ASAP. I know this sounds like a hardware problem but all other programs (inc. other spreadsheets) work fine. Whenever I start Excel (new or existing file) it is as if the 1st place I select (tab or cell) is as if I am holding down the left mouse button. If my 1st click is on a cell when I move the mouse it is highlighting a group of cells as if I am clicking & dragging to highlight a cell area. If my 1st click is on a worksheet tab at the bottom I get that little page icon as if I am holding the left mouse button to drag the position of the tab. No matter which case I cannot de-select this, I am stuck in this position an Excel is effectively useless. I can't chose a pull down menu or even click the X in the upper right to exit the program. The only way to get out is to ctl-alt-del & choose end program from the task manager (even then an error message comes up that says Excel cannot be shut down) thank goodness when I click okay to that box it does close. Again, no problems with any other programs. When Excel is locked up I can click on the window of any other program and run it normally. -- Thanks in advance... Bob Tag: Formula as text Tag: 81177
  - 9
    - Find/Replace Date Question Using Excel 2003. Problem replacing a series of dates having a date format of dd/mm/yy. I want to replace all dates ending with /05 with /06. I enter in the Find box /05 and in the Replace box /06 Error is "Microsoft Office cannot find a match" I never had this problem with earlier versions of Excel. TIA Jim Tag: Formula as text Tag: 81170
  - 10
    - Excel question with if statements Hi Everyone: I have a monthly financial projection model and I am trying to build the following functionality. One assumption is that there will be an acquisition in any given month. For this I have set it up so when a person enters the month on the assumptions chart there is an if statement in the projections sheet that enters the amount in the proper month. However as soon as the acquisition takes place I have a series of 12 (one each month) capital expenditures that take place below in the expenditures row. How do I build the functionality so that as soon as the acquisition date is entered in the capital expenditures line there is a series of 12 payments immediately following the month of the acquisition. Thanks very much in advance for your help on this and HAPPY NEW YEAR!!!!:) -- kidflip ------------------------------------------------------------------------ kidflip's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30033 View this thread: http://www.excelforum.com/showthread.php?threadid=497193 Tag: Formula as text Tag: 81168
  - 11
    - Run a Help file (.CHM) from VBA in an XL application The Shell command doesn't seem to work with a help file. What command will run a help file and then return to the XL app? Thanks, Fred Tag: Formula as text Tag: 81167
  - 12
    - Secure one Worksheet only but not the Workbook This is a multi-part message in MIME format. ------=_NextPart_000_018C_01C60E01.EA0155B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is there a way to make one worksheet protected so that it can't even be = opened without a password. Employees will have access to several = worksheets in a workbook, but the results will be summarized on a = separate worksheet that will be accessible only to management. How best = can I accomplish this? I see that there is a way to make a worksheet = invisible, but don't know how to control this. I presume there's some = VBA code that could hide and unhide a worksheet protected by a = password??? Thanks Mack ------=_NextPart_000_018C_01C60E01.EA0155B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2802" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Is there a way to make one worksheet = protected so=20 that it can't even be opened without a password.  Employees will = have=20 access to several worksheets in a workbook, but the results will be = summarized=20 on a separate worksheet that will be accessible only to management. How = best can=20 I accomplish this?  I see that there is a way to make a worksheet=20 invisible, but don't know how to control this. I presume there's some = VBA code=20 that could hide and unhide a worksheet protected by a = password???</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Mack</FONT></DIV></BODY></HTML> ------=_NextPart_000_018C_01C60E01.EA0155B0-- Tag: Formula as text Tag: 81165
  - 13
    - Button faces - background colour problems Hi, Does anyone know how I can: 1. Copy a stock button face from MS Excel 2. Modify this slightly for my own purposes 3. Save this modified button face in an xla file 4. Use this modified button face for my own custom button The above problem can be solved in part by: 1 & 2 & 3 - in menu customisation mode use Excel's built in button face editor to edit the button face and 'copy' the button face and paste as an image on to an excel worksheet. 4 - Use the .copy and .pasteface methods to take the image from the worksheet and use as the button face. However there is one problem with the above method: The transparent background colour of the button face is lost (i.e. if someone changes the default windows colour scheme so that light gray is no longer used as the menu background colour the button face will stick out like a sore thumb). This is the problem I wish to overcome (i.e. how do I create a transaprent colour on the button face, just like the standard excel button faces). Any suggestions would be gratefully accepted. I have already tried using the various faceid viewers as the source of the button images but again the background transparent colour is lost. Many thanks, John Tag: Formula as text Tag: 81164
  - 14
    - HAPPY NEW YEAR !!! HAPPY NEW YEAR !!! Hello friends, I´m Happy !!! I ordered the programm and it really functions. I EARNED OVER 850 DOLLAR IN ONE WEEK !!!! READ THIS: For everyone, who needs really money. Are you on the search for a lucrative source of income? Would you like to work of at home out of, without yourself you someone makes directions? Would you yourself like to determine, when, how much and like often you salary? Work for yourself ? Then you should take yourself a couple minutes time. You happily will be that you did that and think gratefully at the day , at which you discovered these information. I have this program found in the Internet, and after I read it, I found it somehow interesting. I became curiously on the further and participated. That it functions, noticed I at me even because I myself participated. And that of all through a simple special business plan. No anxiety - no university study need you to have graduated no education and no lengthy training, in order to be with this draft successful. It passes the will to the success. Everything very simply is explained and can start you immediately. If you are ready to carry out simple directions, will be GUARANTEED successful you! Do I ask you: if you earn no money with a simple draft, with what then then? After my experience, only manageable drafts can be really successful. The program is: 1) perfectly and ready for you to the money 2) earn like to can use.. absolutely no arrangement costs 3) as often repeatable as you want 4) everyone with internet access and e-mail-address can use it 5) absolutely no risk 6) You start in 5 minutes! It takes at most 15 minutes of your time 7) no website need 8) required.. no special knowledge 9) required.. no monthly costs 10) no checks - the money comes Online .. no calls, no sale 11) no failures 12) 100% legal. 13) 100% fool neutralizing 14) the money comes purely, also if you sleep or are on vacation 15) lifelong usefully 16) NO CHAIN-LETTER I did the first steps shortly after I received the information. I followed the simple directions that were announced per email to me. The execution lasted less than 15 minutes and I had earned really money. The sequences were spectacular! I was able to spend with my family finally a beautiful vacation in the south - the first for some time - and I could a brand-new car buy myself. And the best was that I owed no one also only a single cent! As you know, all GOOD Concepts costs money, but that concept you get is very cheap and at all >> it functions !!!. In order to receive the businesses - plan quickly, follow the lower directions. What we first require, is a fast and simple possibility to transfer money, in order to received the business-plan quickly. We need an "internet bank". It gives many internets - payments - systems. You can, for example, use Paypal, if you want, because payments are presently free of cost over Paypal. Paypal has presently over 78 million customers and offers the certain transfer of money into 56 countries simply per e-mail address. If you use yet no internet - payment - system, open now a cost-free BASIS - PREMIUMS -ACCOUNT in PayPal. click up: https://www.paypal.com , and look for your country (should that link not active, copy it please into your browser) >> Send to the following e-mail address per PayPal 4,- Euro, 4,- US-Dollar >> or 3,- British Pounds : geldkonzept@gmx.net (in -use-purpose- write / select you: - SERVICE -, in - E-MAIL - reference - write you: - moneydraft -) Paypal automatically sends the receiver and your a mail that you paid a payment. You get after short time that - money draft - and can start immediately. IT IS SO EASY TO EARN MONEY, YOU WILL SEE AFTER ORDERING THANKS Tag: Formula as text Tag: 81158
  - 15
    - Data Entry We are into BPO and Software development business for past six and half years. We are looking for the following any kind of business from your end. Back Office Process Data Entry, Large Volume Data Processing, Data Conversion, Forms Processing, Process flow & Quality Data Entry Text, Numeric or Alphanumeric entry, Printed or Handwritten matter, Hardcopies or Scanned Images, Some typical examples include, Mortgage Documents, Abstract records, Index cards, Market Research Tabulations, Various different forms, Guest/Customer comment cards, Property tax records, Accounting and Book keeping, Extracting data from Catalog, Payroll Services, Dictionaries, Manuals, Encyclopedia etc,Surveys,Questionnaires,Company reports, Material Safety Data Sheets (MSDS) forms, Airway Bill entries Large Volume Data Processing Formatting of Data like mailing list, Database creation and updation,Data Conversion,OCR Clean up, ICR, OMR,Scanning from hardcopies, microfilms, microfiche,Indexing,Archiving,PDF conversion: PDF to text, HTML etc,HTML conversion, XML tagging, Document conversion Forms Processing Credit Card Processing, Insurance Claims Processing, Market Research forms entry, Survey Forms Processing, Order Processing Financial Services Accounts Payable Management, Accounts Receivable Management, Account Setup, Account Reconciliation, Bank Reconciliation, Bookkeeping, Financial Statements Financial/Operational Budget, Payroll Services, Prepare and File Tax Returns, US GAAP Reporting Drafts Contact COMPUTER CONSULTANCY SERVICES INC, URL: www.ccsgroupindia.com Email: jobs@ccsgroupindia.com, (24 x 7 online support) Chat MSN : rajamanickam73@hotmail.com Chat Yahoo: rajamanickam73@hotmail.com Tel: +91 44 42037794, 42037795 -- bpo_ccs ------------------------------------------------------------------------ bpo_ccs's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30022 View this thread: http://www.excelforum.com/showthread.php?threadid=497124 Tag: Formula as text Tag: 81152
  - 16
    - AutoFilter Question Is there a way to remove the automatically displayed filter options? In other words: I have a spreadsheet with Apples, Bananas, and Cherries. I want to filter by the particular fruit, but I dont want to see Top 10, Blank, Non-Blank, Custom, etc. I just want to see Apples, Bananas, or Cherries. TIA ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- Tag: Formula as text Tag: 81148
  - 17
    - Find and Replace against set of rules in 2nd table/worksheet Looking for a tool, or code that does the following. Edit [partial cell data] in Sheet1, if [partial cell data] meets criteria in Sheet2, COL1. Sheet2, COL2 has the REPLACE WITH information. Presently there are 59 criteria on Sheet 2, and I have to perform this against 19 sites. So doing this manual via Find and Replace takes forever. VBA code, or something similar would be great. (Wanted to write an Update Query Access, but Access sent me here.) Thanks in Advance Tag: Formula as text Tag: 81146
  - 18
    - condition format based on lapsed dates I want to format a group of cell based on days old. The days is based on the "value" in cell I8 =Now() and cell J10 (j11,j12...) on is the submission date. Therefore number of days that has passed is in cell I10 (i11,i12...) =$I$8-J10" in the cell, this is the number of days that has lapsed. So if 90 days has passed I want to grey out cells k5,l5,m5, and n5. I am unable to get this to work, what do I need to do to make this work? I am assuming that the value is not showing correctly in the formula portion of the conditional format: if cell(I10)>= 90 then [grey out cells k5,l5,m5,n5] Hopefully, someone can show me the way. Thanks ahead for the help. dave Tag: Formula as text Tag: 81144
  - 19
    - Add filename in a new column Is it possible to add the actual name of the file in a new column when I open each file with Excel. I have multiple files that I need to have the file name included with each row within the file. So, I'd like to be able to just open each file and it automatically inserts a new column and includes the file name in each cell for every row. Is this possible? Thanks, Mike -- OnlineWealth ------------------------------------------------------------------------ OnlineWealth's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30017 View this thread: http://www.excelforum.com/showthread.php?threadid=497075 Tag: Formula as text Tag: 81135
  - 20
    - random number generator hi there i don't know if this is the right section, however I was wondering is there some vba or formulae to generate random numbers in a certain range I would be very greatful if you can help me Thanks Owen -- manclad ------------------------------------------------------------------------ manclad's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30016 View this thread: http://www.excelforum.com/showthread.php?threadid=497074 Tag: Formula as text Tag: 81132
  - 21
    - HTML Help files I'm using MS HTML Help Workshop to write a help file for an XL application that I finished. All goes good through compiling, etc. The TOC and Index work good as long as I view the CHM file through the HTML Help Workshop. The individual data sheets appear as expected. If I double click on the CHM file, however, the help dialog appears but ALL of the data sheets have disappeared. In their place is a blank screen that says: Action canceled Internet Explorer was unable to link to the Web page you requested. The page might be temporarily unavailable. -------------------------------------------------------------------------- Please try the following: a.. Click the Refresh button, or try again later. b.. If you have visited this page previously and you want to view what has been stored on your computer, click File, and then click Work Offline. c.. For information about offline browsing with Internet Explorer, click the Help menu, and then click Contents and Index. Internet Explorer It's gotta be simple but ?? Best regards, Fred Tag: Formula as text Tag: 81131
  - 22
    - Please Help I'm trying to filter contacts by state. I know how to use auto filter to list all contacts in one state but I want to list contacts in 5 different states. can auto filter do this and how? Thanks -- dzeitler ------------------------------------------------------------------------ dzeitler's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24019 View this thread: http://www.excelforum.com/showthread.php?threadid=497053 Tag: Formula as text Tag: 81127
  - 23
    - HELP! Simple (?) Data Counting I am having a LOT of trouble with what seems to me should be a fairly simple function. I am setting up a sort of database for our sales department. It contains 16 criteria headings. At the end of each day, the manager will go in and enter the information for each sale (1 sale will occupy one row in the list). Most of the fields have pull-down menus for consistency of information. I consider this the raw data. Next, I have 7 worksheets, each dedicated to an individual salesman. These sheets are identical in format. Each individual product is listed down the left-hand side (there are 49 different products). The months are listed across the top. In the end, I want to be able to look at Salesman Steve's sheet and see a simple count of how many units of Product A he sold in November, for example. This seems like it should be simple. I want to see how many rows in the database meet three specifications: Salesman Steve, Product A, and November. (Salesman, Product, and Month ARE three of the criteria headings on the data page.) I would greatly appreciate any help anybody could give me. If you need any more information/details I would be glad to provide it. Pat Tag: Formula as text Tag: 81126
  - 24
    - strange problem Hi, If I don't have the correct Newsgroup for this problem please let me know where to look for this following advice. I'm having a strange problem. I have a floppy disk on which I keep my addresses. I also have other spreadsheets on the same floppy disk. The other spreadsheets are all opening just fine but when I go to open my addresses spreadsheet I get this error reading. EXCEL caused an invalid page fault in module EXCEL.EXE at 017f:300d6c1f. Registers: EAX=000000e0 CS=017f EIP=300d6c1f EFLGS=00010202 EBX=00000000 SS=0187 ESP=0062bda8 EBP=0062c64c ECX=0000c0c0 DS=0187 ESI=0062c670 FS=50df EDX=00000006 ES=0187 EDI=00000014 GS=0000 Bytes at CS:EIP: 0f b6 9c 0d 68 f9 ff ff 80 fb ff 0f 84 1a 82 0d Stack dump: 00000000 0062eef4 00000000 005f0031 002a0028 00230020 0023002c 00300023 0030002e 005f0030 00220029 0028005f 0020002a 0028005c 002c0023 00230023 What can I do? This spreadsheet is 5 pages and I would miss it terribly. Thanks in advance, Nutty Tag: Formula as text Tag: 81116
  - 25
    - Use the value of one cell to return another Hello all, I am trying to list the top 4 people based on a score. For hypothetical lets just say that this is my table: Two columns A and B A B Frank 7 Cindy 12 John 6 Sam 3 Now, I would like column C to return the NAME of the people(all o them) with the person having the highest score listed first(C1 would b first place, C2 second, etc). How would this be done? Thank you fo your time -- Thada ----------------------------------------------------------------------- Thadar's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2250 View this thread: http://www.excelforum.com/showthread.php?threadid=49700 Tag: Formula as text Tag: 81115
- Next
  - 1
    - read protpetry of user from a distribution list.. i use this to import iser but i would want to import all propetry of user : Adress, Name, Email, ecc.... how i can..? Sub ELENCO() Range("A2:B50000").ClearContents Set myOlApp = CreateObject("Outlook.Application") Set myNameSpace = myOlApp.GetNamespace("MAPI") Set myGAddressList = myNameSpace.AddressLists("Elenco Indirizzi Globale") Set myGEntries = myGAddressList.AddressEntries RIGA = 2 For Each lista In myGEntries If lista = "A.T.C.B. - Utenti" Then Range("A" + RIGA) = lista For Each NOM In lista.Members Range("B" + RIGA) = UCase(NOM) RIGA = RIGA + 1 Next NOM Exit For End If Next lista Range("A2").Select 'Call Worksheet_SelectionChange MsgBox ("IMPORT TERMINATO!") End Sub Tag: Formula as text Tag: 81111
  - 2
    - How to output an array in Excel with a user-defined function? Dear all, I want to write a user-defined function to output an array. But I don't know its codes. For example, if I want to define a function MyFunction(A,B) where A, B are positive integers which generates an array such that the entry in the x-th row, y-th column is x+y, what codes should I write? Should it be like this: Function MyFunction (A As Integer, B As Integer) As Range dim R As Range dim X As Integer dim Y As Integer redim R(A,B) For X = 1 to A For Y = 1 to B R.Cells(X,Y)=X+Y Next Y Next X MyFunction = R End Function Thanks in advance. Best Regards, Andy Tag: Formula as text Tag: 81108
  - 3
    - Find value in table based on two inputs Given A1: Name B1: Dept C1: Age A2: Henry B2: 501 C2: 28 A3: Stan B3: 201 C3: 19 A4: Mary B4: 101 C4: 22 A5: Larry B5: 301 C5: 29 how would write a formula to find the age of 'Mary' in dept '101'? vlookup doesn't seem to support multiple compares. Thanks Tag: Formula as text Tag: 81101
  - 4
    - Turn off Zero values at the end of the chart Please can someone tell me how to stop my charts plotting zero values at the end in cases where the chart runs for a longer period than my data? For example, my chart total date range is say Jan 05 to Dec 05, and I have several lines to plot, the longest one extending for the whole 12 month period, but others for shorter periods from say Jan to Jun 05, and Feb to Nov 05 etc. At the moment the way the source data is set up, is that for the line item that ends in June, there are zero values in the column for Jul to Dec 05 and my chart is plotting these zero values, however I want my line to just end in June 05 otherwise my chart looks odd. The easy answer might be to delete the zero values from my source data, but that will take a lot of fiddling around if I need to do that every time I want to update my charts. I am sure I remember turning off zero values once before, but I cant remember how! Thanks in advance Laura Tag: Formula as text Tag: 81100
  - 5
    - Formatting largest cells Hi, In a row of 6 numbers I want to highlight the 3 largest numbers. If the row contains 7 or 8 numbers, I want to highlight the 4 largest of those numbers. If the row contains 9 or 10 numbers, I want to highlight the 5 largest of those numbers. Any suggestions on how to make this work? Thanks in advance, Barney Tag: Formula as text Tag: 81087
  - 6
    - Pasting Values Hi, I have developed a quoting tool which creates an output sheet detailing all the info, What I would like to be able to do is take a copy of this and paste the values (and Format to a new workbook). I'm currently doing this manually and I unsure how to automate it! I have never used VB which I'm guessing is the only way of doing it, so please be gentle!! Thanks, Sam. -- sammy2x ------------------------------------------------------------------------ sammy2x's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29674 View this thread: http://www.excelforum.com/showthread.php?threadid=496906 Tag: Formula as text Tag: 81086
  - 7
    - Pasting Values Hi, I have developed a quoting tool which creates an output sheet detailing all the info, What I would like to be able to do is take a copy of this and paste the values (and Format to a new workbook). I'm currently doing this manually and I unsure how to automate it! I have never used VB which I'm guessing is the only way of doing it, so please be gentle!! Thanks, Sam. -- sammy2x ------------------------------------------------------------------------ sammy2x's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29674 View this thread: http://www.excelforum.com/showthread.php?threadid=496906 Tag: Formula as text Tag: 81085
  - 8
    - How to move scroller bar? I have an excel Spreadsheet with the vertical scroller bar stuck in the middle of the page. How do I move this back to the side? -- scottsman78 ------------------------------------------------------------------------ scottsman78's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27789 View this thread: http://www.excelforum.com/showthread.php?threadid=496903 Tag: Formula as text Tag: 81084
  - 9
    - Conditional formatting Hi, In a row of 6 numbers I want to highlight the 3 largest numbers. If the row contains 7 or 8 numbers, I want to highlight the 4 largest of those numbers. If the row contains 9 or 10 numbers, I want to highlight the 5 largest of those numbers. Any suggestions on how to make this work? Thanks in advance, Barney Tag: Formula as text Tag: 81080
  - 10
    - How to Auto duplicate cell contents? Suppose if I type 'ABC' in 'A3' & 'DEF' in 'C4' on worksheet1 cells an I wish them to automatically show in certain cells in other worksheet (and also may be other workbooks. I tried to enter =Sheet2!D19 in sheet1 A1 cell. It works fine if had contents in sheet2 d19. But if I changed the contents in Sheet2 D19 The content in sheet1 A1 doesn't change to new content. It still show the old content! It also only show me '0' if I enter the formula befor I type in any content. And it also just remain '0' even after I entere text in sheet1 A1. Can someone pls help -- mlton ----------------------------------------------------------------------- mltong's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3000 View this thread: http://www.excelforum.com/showthread.php?threadid=49689 Tag: Formula as text Tag: 81079
  - 11
    - workbooks.open function fails to open an existing excel file when used in ASP, but works in VB. Hi all, The following script (asp code) works like a charm on my workstation IIS Dim objExcel Dim objWorkBook Set objExcel = CreateObject("EXCEL.APPLICATION") Set objWorkBook = objExcel.Workbooks.Open("C:\test\test.xls") objWorkBook.SaveAs ("C:\test\test2.xls") objWorkBook.Close True Set objWorkBook = Nothing Set objExcel = Nothing The code above is just a sample, the actual app is ASP and involves DB access, reading/writing excel files, ... Trying to narrow the scope I found out that the simple script above does not work on the server, rather works fine on my workstation IIS. (Note: My workstation also has IIS) The test.xls file is the most simple XL file ever, and the path is OK The NT account I use definitely has write permissions on the target directory, and test2.xls does not exist when I run the script. Excel is installed on the server and works normally when used as a client app. But it seems to fail miserabily when used as an activeX object. The script above says it can't find the file, but both the directory and the fiel definitely exist on the server. Any ideas what could break / alter the way excel works when used as an activeX object from another App/Script ? Any comments welcome Tag: Formula as text Tag: 81076
  - 12
    - Copy paste in excel dont work properly. Hi all I am facing very very wired probelm related to cell of excel sheet. Maximum character limt of cell is 32767. I have some text of 32767 characters. Whe i try to copy paste that text into excel sheet it is copying pnly 31767 caracters and not ending 100 characters. And if then i try to append ending 100 characters to string it is accepting those characters in that cell. But i don't know why at a tome of copy pasting it is not woring . Can someone help me why this is happening. Any help will be truely appreciated as this is very very important for me. Thanks in advance. Tag: Formula as text Tag: 81074
  - 13
    - Excel Hyperlink to Page Break Preview 1. Enter an Excel worksheet and set via pull-down menu, Windows > Freeze Panes at Row 1. 2. Set Print Area and hence Page Break Preview ; then, the worksheet shows multiple pages. 3. Enter a Hyperlink into Cell A1 and click to scroll to Page 2 thereof (such that the worksheet scrolls down and the first row of Page 2 is butting snuggly against Row 1 - which is frozen, remember ?) 4. After reaching Page 2 and then scroll down further ; say, page 3 and beyond. 5. Click the Hyperlink in Cell A1 again. On the return flight, the worksheet does not scroll into the position of Page 2 (despite that the worksheet scrolls up and yet it does NOT show that the first row of Page 2 is butting snuggly against Row 1 - and there, far from expectation, it is out-of-view this time). 6. Please devise a Hyperlink such that when the worksheet is subject to scroll from the upper and lower sides of Page 2, a Click will always take the worksheet to home in at Page 2 (such that the worksheet scrolls up or down and promptly, the first row of Page 2 is ALWAYS butting snuggly against Row 1 of the worksheet). 7. Regards. Tag: Formula as text Tag: 81069
  - 14
    - Custom view problem I had a custom view name "partial function" added which include autofilter. after using the selected custom, I set autofilter to display all again, saved the file. Next opening of the file, freeze panes automatically activated at half the current view of the spreadsheet! Is this a bug? Tag: Formula as text Tag: 81065
  - 15
    - Fill series I want to set up a table. The instructions say to use Edit>Fill>eries, but my Series is grayed out. -- Stephen G. Esrati Tag: Formula as text Tag: 81062
  - 16
    - Excel 2003 won't let me change Xlabels from scientific notation For some reason, when I type in bin bounderies for a histogram as: 0.0000 , 0.025, 0.050...... 0.175, 0.200 excel keeps changing them to exponential/scientific format, which not only takes up a lot of space, but just looks dumb. How can I force excel to show the labels the way I want? Tag: Formula as text Tag: 81049
  - 17
    - copy and match data from one worksheet into another via script? Hi all I have two worksheets 2 columns each The first sheet has ID and Name Column for example: Code ------------------- ID[/B] NAM 193948 Michael 684588 John 535279 Luke 098734 Matthe ------------------- my 2nd sheet Code ------------------- ID [B]NAM Michael John Luke Matthe ------------------- How do i use the first sheet to match up the names on the 2nd sheet and ultimately copy the ID numbers onto the 2nd sheet? This is just a simplified example. There are thousands of entries. Thank you if you have any idea -- Dev4m ----------------------------------------------------------------------- Dev4me's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2970 View this thread: http://www.excelforum.com/showthread.php?threadid=49680 Tag: Formula as text Tag: 81047
  - 18
    - Aurgh, need help I have 3 spreadsheets all which contain the similar data in this one single column. The three spreadsheets are being used by 3 different users. Each one is filling out different rows to that one column. What I need now is a formula to combine the information in that one column from their spreadsheets into a master column. I just want to keep the unique records though. Hope someone can help. regards, Spiro -- spirosu ------------------------------------------------------------------------ spirosu's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=7442 View this thread: http://www.excelforum.com/showthread.php?threadid=496797 Tag: Formula as text Tag: 81041
  - 19
    - In VB macro how do I select range from active cell Hey guys and gals, Thanks for lookin at this problemmmmm??? When I am writing a macro using visual basic, how do I select a range which includes 2 rows down and 8 rows across (selects the range not just the single cell) from the currently selected/active cell then copy it: All this starts from the cell the user starts from. Example...... PuzzeledProgramer -- spydor ------------------------------------------------------------------------ spydor's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28438 View this thread: http://www.excelforum.com/showthread.php?threadid=496798 Tag: Formula as text Tag: 81040
  - 20
    - Text version of formula I Have Been Asked To Enter The Text Version Of The Formulas Below. Usin No Equals Or $ Signs. Can Anyone Help??? =subtotal (9,b17:b29) =subtotal (1,d15:d25 -- stura ----------------------------------------------------------------------- sturae's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2998 View this thread: http://www.excelforum.com/showthread.php?threadid=49679 Tag: Formula as text Tag: 81038
  - 21
    - templates for excel xp Where can I get additional templates for my excel program. Thanks Raymond Tag: Formula as text Tag: 81037
  - 22
    - Find differenced between two columns... Currently we are sorting these lists by hand and this should be something that MS Excel could do... How can we acomplish this? We have two text columns containing similar data. We want to identify which values exist in one column but not the other. Currently we sort each column in ascending order. Then manual check the value in column 1 against the value in column 2. If column 1 is bigger than 2 we insert a blank cell in column 1. If column 2 is bigger than column 1 we insert a blank cell in column 2. Once we are complete, we can see what values are in each column because there is a value in column 1 and column 2. We delete these rows. This leaves us with only the unique values for each column... E.g. We start with these columns: #1 #2 A1 A3 DA A2 B4 B3 C1 D9 A2 B5 B9 ..after sorting... #1 #2 A1 A2 A2 A3 B4 B3 B9 B5 C1 B9 DA ...after comparing columns... #1 #2 A1 A2 A2 A3 B3 B4 B5 B9 B9 C1 DA ...after deleting duplicates... #1 #2 A1 A3 B3 B4 B5 C1 DA The final list are all the unique values found in each column. Tag: Formula as text Tag: 81036
  - 23
    - changing formats I know you can open an .exp file in excell, but if i have a .txt file can I change it an exp? -- bustanutti21 ------------------------------------------------------------------------ bustanutti21's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25542 View this thread: http://www.excelforum.com/showthread.php?threadid=496776 Tag: Formula as text Tag: 81032
  - 24
    - max of non adjacent columns I have 12 columns with numbers,these numbers change very rapidly as they are fed into the sheet from a website. I need a formula to calculate the max of the numbers in every second column,for the first row this would be the numbers in cells B1,d1,f1,h1,j1,l1. The answer will be stored in another cell,and of course will be constantly changing as the contents of these cells change. -- pytelium ------------------------------------------------------------------------ pytelium's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25521 View this thread: http://www.excelforum.com/showthread.php?threadid=496773 Tag: Formula as text Tag: 81028
  - 25
    - Convert random numbers to text.. HAPPY EVERYTHING!! I have a problem and after searching for an answer for at least 3 hours I am stumped. I have a spreadsheet formatted as follows: Row B2 --> DT2 is the name of Regions. ColumnA3 down to A50 are products. In the cells to the left os A3.. and beneath each Region there are numbers ranging from 1--> 70000(sample). I need to replace all cells which have a value and are not empty with an 'X'. I then have a SQL script to extract that data in to a db. I have found many macros, scripts for converting to monetary values to text in just about any language, various vlookup and other conversion scripts but can not figure out how to do the above.. I would really appreciate any assistance!!!! TIA!! Raymond Tag: Formula as text Tag: 81024

Happy new year..

Why C2 cell as the result of VLOOKUP which contains "APPLE" can be rea
by D2 as formula which cause D2 becomes "RED" unless in cell C2 type
"APPLE"?

Rgds

Y

--
Yanto hendrawa
-----------------------------------------------------------------------
Yanto hendrawan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2781
View this thread: http://www.excelforum.com/showthread.php?threadid=49730

Top

Re: Formula as text by Bob

Bob
Mon Jan 02 05:01:43 CST 2006

Use Conditional Formatting

Select column A
Menu Format>Conditional Formatting
Change Condition 1 to Formula Is
Add a formula of =$C$2="APPLE"
Click the Format button
Select the Pattern Tab
Select the red colour
OK
OK

--

HTH

RP
(remove nothere from the email address if mailing direct)

"Yanto hendrawan"
<Yanto.hendrawan.20zuna_1136182800.3272@excelforum-nospam.com> wrote in
message news:Yanto.hendrawan.20zuna_1136182800.3272@excelforum-nospam.com...
>
> Happy new year..
>
> Why C2 cell as the result of VLOOKUP which contains "APPLE" can be read
> by D2 as formula which cause D2 becomes "RED" unless in cell C2 typed
> "APPLE"?
>
> Rgds
>
> YH
>
>
> --
> Yanto hendrawan
> ------------------------------------------------------------------------
> Yanto hendrawan's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=27818
> View this thread: http://www.excelforum.com/showthread.php?threadid=497303
>

Top