I have also created thousands of functions, and PivotTables
Good :)
you're asking or you're selling web site?
I'm am sharing ;)
As Excel MVP, I have to share my knowledge for free on the web.
So when a question is in relation with one of the page of my website,
I post the related page.
--
I have never seen this problem (sorry)
But it looks strange
On 31 août, 21:28, Prabhu prabhugate...@gmail.com wrote:
Hi Friends,
When i double click my Pivot table value a new sheet is appearing with the
details. But all the amount columns are showing in date format.
Can anybody help how to
Why don't you use a pivot table with the table option to split your
document by Division and Regional lead ?
On 30 août, 06:52, anu gomathi anugomathi.d...@gmail.com wrote:
Hi Experts,
I am very new to this forum.
Attached the details report the out put file. I need a macro to split the
Hi
I have written today a page about the way to create a worksheet
function of a criteria
http://www.excel-exercice.com/en/2074/creation-of-worksheets-by-criteria
I'm sure that this tip will help you ;)
On 30 août, 06:52, anu gomathi anugomathi.d...@gmail.com wrote:
Hi Experts,
I am very new
I have solve your worksheet but you must changed the presentation of
your data.
You must present your data like this
Invoice#YearCat Dollar
123456 2006Cat15
234567 2006Cat15
345678 2006Cat15
123456 2006Cat24
234567 2006Cat24
345678 2006
I'm not sure that it's possible with xl 2003 because the conditionnal
formating must be the same as the range of apply.
In xl 2007 and 2010, you can make a test to a range of cell (O2:AS2 in
your example) and apply the result to O3:AS11.
The conditionnal formating has changed a lot with the new
to find Adject Output, it is showing #N/A error..
--
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
On Thu, Aug 25, 2011 at 2:36 PM, Frederic LE GUEN fleg...@gmail.com wrote:
Use the function LOOKUP(9^9,A:A)
9^9 = 387420489
