Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: CFNB
  • Content: Threads
  • Order by date
  1. CFNB

    if with color

    hello. I have this following peace of code which works fine. =IF(OR(A13={"UNITED STATES","JAPAN"}),A13,"") I would like JAPAN to be printed in red and UNITED STATES in bleue. How would I add this restriction in the code, if it is possible? Thanks.
  2. CFNB

    models

    Dear all. this is the first time I am using SAS to model. I have data from a fish study and would like to use SAS to build a model. As a first step, I looked in the SAS help and found this interesting example. I need to understand few things in this example: 1. are the key words 'endogenous'...
  3. CFNB

    looking for a software to compare files

    Hello all. I am looking for a free software to compare two excel files. I downloaded ExamDiff but it does not work properly. Do you have any suggestions? Thanks.
  4. CFNB

    adding a line break in a cell

    Hello. I forgot how to add a line break in a cell. I tried shift+enter, ctr+enter but to no avail. Would you please refresh my memory? Thanks.
  5. CFNB

    excel print not right

    Hello all. When i specify rows to repeat at top when printing,i get page breaks in the middle of the page. If i print without this feature, there is no problem! thanks for any hint.
  6. CFNB

    How to forward an email automatically

    Hello. I receive a publication by email regularly. I would like to forward it automatically to someone else. Could give me a hint on how to do this? Thanks.
  7. CFNB

    using IF with LIKE

    Hello, if column 1 contains the word 'snow', i would like column 3 to show the word 'snow'. if column 1 were made of only one word, it would have been easy: IF(A1="SNOW", "SNOW","") How do I do it when column 1 contains any string that might include the word 'snow'? Thanks.
  8. CFNB

    if and or statements

    Hello. I would like to use OR in a IF statement. The one I have right now is : =IF(A13="UNITED STATES ",A13,"") what I would like to do is : =IF((A13="UNITED STATES " OR A13="JAPAN"),A13,"") but I get an error. The search function is not working on this website. Thanks.
  9. CFNB

    Format Disk

    Hello. After 4 years, my laptop is getting extremely slow. I would like to format my disk. I would like to know if the 2 sites I found are OK in their instructions. 1. http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/win_format.mspx?mfr=true 2...
  10. CFNB

    reverse data

    Hello. I have data from 2007 to 1980. Is it possible to chart the data from 1980 to 2007 (reverse the axis or something similar) Thanks
  11. CFNB

    string to number

    Hello. I copied a column of numbers from another sheet. Now, the numbers are stored as strings. I used "Data", "Text to Columns" but it still does not work! Is there anything I could use? Thanks.
  12. CFNB

    statistical tools

    Hello. I would like to learn to use the Excel statistical tools (ANOVE, Regression...) Would you mind to suggest a good tutorial. I am also looking at Analyse-it add-in. Any feedback on this software ? Thanks.
  13. CFNB

    import excel chart to powerpoint

    Hello. I have charts in excel sheets. I am trying to insert these charts as pictures but they are inserted as excel files (when I double click the chart in powerpoint, the whole excel sheet opens). At home, I do not have this problem. I copy the chart then right click in powerpoint and choose...
  14. CFNB

    totals on column chart

    Hello again. I have a column chart. Each rectangle represents represents several categories. I would like to show the total for each rectangle. example: year cat.1 cat.2 total 1990 2 3 5 1991 6 3 9 If I draw a column chart of cat.1 and cat.2...
  15. CFNB

    chart title-

    Hello. I would like to frame my chart titles (put a box around). Is it possible to do it in excel? Thanks.
  16. CFNB

    how to show column titles when scolling down

    Hello. I have a very long excel document. When I scroll down (or go to the last record), I lose my column titles. I know there is a way to always show them on the screen, but I cannot find it. Thanks in advance.
  17. CFNB

    replace *.* by 0

    Hello. I have an excel file that comes with strange characters: *.* I would like to replace these characters by the number 0. I tried with the IF function but it did not work. I guess I did not use it right. Thanks.

Part and Inventory Search

Back
Top