1. ## 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. ## 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. ## 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.

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

=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. ## 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. ## 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. ## 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. ## 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. ## Re: AC.....#N/D (2000 sr-1)

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

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

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

11. ## 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. ## 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
•