Results 1 to 12 of 12
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    AC.....#N/D (2000 sr-1)

    I have this formula:
    =SE(PIVOT_RATE!B17>0;CERCA.VERT(A14;PIVOT_RATE!$A$ 5:$H$40;2;0);"")
    i would want to insert this control if the vaklue not is found

    VAL.NON.DISP

    WHERE?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: AC.....#N/D (2000 sr-1)

    Does this do what you want?

    =SE(VAL.NON.DISP(CERCA.VERT(A14;PIVOT_RATE!$A$5:$H $40;2;0));SE(PIVOT_RATE!B17>0;CERCA.VERT(A14;PIVOT _RATE!$A$5:$H$40;2;0);"");"")

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: AC.....#N/D (2000 sr-1)

    .... no good result..
    In effect i wopuld want to update (via link or macro) the sheet STATISTICA...
    Sure you understand me.
    Sorry for dim of file.
    http://www6.rapidupload.com/d.php?file=dl&filepath=9169

  4. #4
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: AC.....#N/D (2000 sr-1)

    How about this?

    =SE(PIVOT_RATE!B17>0;SE(VAL.NON.DISP(CERCA.VERT(A1 4;PIVOT_RATE!$A$5:$H$40;2;0));"";CERCA.VERT(A14;PI VOT_RATE!$A$5:$H$40;2;0));"")

  5. #5
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: AC.....#N/D (2000 sr-1)

    Hi Tony... Work fine, but not all ammount are finded, infact the general total and variuos total not are the same about PIVOT_RATE, why?

  6. #6
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: AC.....#N/D (2000 sr-1)

    Try this version, it seems to copy all of the values from the pivot table.

    =SE(VAL.NON.DISP(CERCA.VERT($A14;PIVOT_RATE!$A$5:$ H$40;2;0));"";CERCA.VERT($A14;PIVOT_RATE!$A$5:$H$4 0;2;0))

  7. #7
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: AC.....#N/D (2000 sr-1)

    now work, many tks!
    If i would want to insert in B48, C48, D48 ecc. the percentage of B47, C47, D47 ecc. respect the Gran Total in I47, how can?

  8. #8
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: AC.....#N/D (2000 sr-1)

    For example in B48 enter the following formula and format the cell as percentage.

    =B47/$I$47

  9. #9
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: AC.....#N/D (2000 sr-1)

    ... to make the same vlookup with a macro? is possible?

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: AC.....#N/D (2000 sr-1)

    Why would you want to use a macro? A formula is much easier.

  11. #11
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: AC.....#N/D (2000 sr-1)

    Sure this is my work( <img src=/S/angel.gif border=0 alt=angel width=15 height=21> <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23> (remember Manuali.net...)

    During the import value is possible insert for each line the summ in cloumn I and in line 47...

  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: AC.....#N/D (2000 sr-1)

    You don't need code for that. You can place SUM formulas in B47:I47.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •