I have never seen this problem (sorry)
But it looks strange
On 31 août, 21:28, Prabhu 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 rectify the same.
> 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.
--
-
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 wrote:
> Hi Experts,
>
> I am very new to this forum.
>
> Atta
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 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
> workbook as per the
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
ind 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 wrote:
>
>
>
> > Use the function LOOKU
Use the function LOOKUP(9^9,A:A)
9^9 = 387420489
Because this value is not in your range A:A, Excel return the last
value of your range.
Then, you copy/paste this formula 40 times and you just have to change
the column's reference.
And if the hearder of your report worksheet is equal to the
works
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 ve
