• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    Long IF formula there has to be a better way

    How do I do it? I can post a few here but it you want the export, then?? Z4S500 MISC. RETURN 08 -982 0.05 -49.1 Landscaper #VALUE! Z4S500 MISC. RETURN 08 -750 0.05 -37.5 Landscaper #VALUE! Z5G999 5G CORN 01 45 9 405 Independent #VALUE! Z5G999 5G PEPPER 01 8 9 72 Independent #VALUE! Z5G999 5G...
  2. A

    Long IF formula there has to be a better way

    =TRIM(IF(NOT(ISERROR(SEARCH("SUPERTUNIA",H2,1))),"SUPERTUNIA",IF(NOT(ISERROR(SEARCH("BEGONIA",H2,1))), "BEGONIA",IF(NOT(ISERROR(SEARCH("ALYSSUM",H2,1))),"ALYSSUM",IF(NOT(ISERROR(SEARCH("DIANTHUS",H2,1)))...
  3. A

    Pivot Table-change percentage by Row label change

    I am using Excel 2007 to view sales history as a percentage of sales and quantity of items sold. I can change the percentage to reflect based on column total and total. I have the year and then customer type as a sub category of year in the Row Labels of the pivot table Field List. Is there a...
View older results
Back
Top