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 IamaSherpa 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
  • Order by date
  1. CFNB

    adding multiple rows

    I would insert the first one as usual then CTR-Y after that (it would re-do the last command)
  2. CFNB

    if with color

    perfect!
  3. 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.
  4. 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'...
  5. 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.
  6. CFNB

    adding a line break in a cell

    right on! Thanks.
  7. 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.
  8. CFNB

    excel print not right

    thanks. this what i did.
  9. CFNB

    excel print not right

    well this is the problem. Everything is ok in Page Break Preview but it not when printed! thanks again.
  10. CFNB

    excel print not right

    thanks macropod. where do i look for hard-coded page breaks ?
  11. 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.
  12. CFNB

    How to forward an email automatically

    thanks a lot. I finally found how to do it.
  13. 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.
  14. CFNB

    using IF with LIKE

    Thanks a lot
  15. CFNB

    using IF with LIKE

    thanks KenWright but it did not work! I get #value! error I even tried : =IF(SEARCH(A1,"Snow"),"Snow") =IF(SEARCH("Snow",A1),"Snow","")
  16. 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.
  17. CFNB

    if and or statements

    thanks.
  18. 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.
  19. CFNB

    Format Disk

    Thank. I will consider all options.
  20. CFNB

    Format Disk

    I am sorry, but I did not specify my system. DELL pentium Inspiron 8200 with Windows XP Professional v.2002. Thanks.

Part and Inventory Search

Back
Top