Herbert,
I don't understant this syntax
=1/nbval([name])

Should I understand
1 divided by the number of items having this name ?
It's not working for me in Excel 2007.

Anyway, my data is not in an XL spreadsheet, its in a text file.
I think I will have to get the percent result (the dividend) in the text
file data before excel can doit's work.
Or, at least, the quotient and the divisor.

Please advise.











"Michel Groff" a écrit dans le message de
news: ...
Excellent.
Thanks.
This does appear to be the solution.
I'm working on it and will let you know, maybe next week.

MG


"Herbert Seidenberg" a écrit dans le message de
news: ...
Excel 2007 Pivot Table
Running % total.
http://www.mediafire.com/file/4hwcwaui2ea/03_26_09.xlsx