Thank you Ashish and Viswanathan very much. Problem solved.
John
On Sun, Mar 27, 2011 at 2:28 AM, ashish koul wrote:
> check the attachment see if it helps
>
>
> On Sun, Mar 27, 2011 at 11:18 AM, ashish koul wrote:
>
>>
>>
>> On Sun, Mar 27, 2011 at 5:51 AM, Viswanathan M wrote:
>>
>>> Dear
Dear Mr. John,
=SUM(NOT(B2=""),NOT(D2=""),NOT(F2=""))
The above formula will help you for finding out the Total Deliveries
*With warm regards*
*Viswanathan M*
DE(Tech)
RGM TTC Chennai-600027
*Vande* *Mataram*
On Sat, Mar 26, 2011 at 9:57 PM, John A. Smith wrote:
> I have an excel database
I have an excel database where each line represents an entity and it's data
over about 70 columns. There are multiple occurrences of delivery
information in these columns that I need to summarize in a pivot table.
Some lines may have only one occurrence of this delivery while some others
may have
here you go
http://www.mediafire.com/download.php?nvt1ymtzjdy
thanks for your help!
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2
Guru,
I actually want to see both of those line items as percentages of
sales which is to say, take gross margin $ and divide it by sales.
Same for operating income.
Thanks!
--
--
Some important links for excel user
Hi,
Just see the attached file and confirm If this is what you are looking for.
Best Regards,
Guru
On Tue, May 4, 2010 at 8:57 PM, dza7 wrote:
> Hello,
>
> I have a challenging pivot table issue that I hope I can get some help
> on.
>
> Here is the spreadsheet I'm working with:
> https://www.y
Dvpetta,
Can you upload a 2003 version, i may be able to give a thought on it
CC me in, so that i know that you have uploaded the sheet
Cheers
Harry
On May 4, 8:27 pm, dza7 wrote:
> Hello,
>
> I have a challenging pivot table issue that I hope I can get some help
> on.
>
> Here is the spreads
Hello,
I have a challenging pivot table issue that I hope I can get some help
on.
Here is the spreadsheet I'm working with:
https://www.yousendit.com/download/OHo0N3RSSU90d0UwTVE9PQ
I'm having problems with showing percentages in my pivot table such as
gross margin and operational profit. Here
Hello Dear,
I have already viewed your problem.
please respond that what you want in pivot column and in pivot row.
Please reply so that we can prepare exact pivot.
Hope It Will Help
Happy To Help
:)
Shyam
On Fri, Mar 12, 2010 at 5:25 PM, satya narayana wrote:
>
>
> -- Forwarde
Hi Subhash,
i hope this will solve your problem.
Rgds,
Mahesh Bisht
On Wed, Nov 25, 2009 at 11:50 AM, subhash tambe wrote:
> Dear all,
>
>
> How to compile to excel pivot table ,
> ( B Column Count 5 to 15 )
>
> A B C D E F G H
> 1
> 2 10
> 3 25
Pls clear your question & make excel sheet with your data & query and attach
with this mail.
Vir
2009/11/25 subhash tambe
> Dear all,
>
>
> How to compile to excel pivot table ,
> ( B Column Count 5 to 15 )
>
> A B C D E F G H
> 1
> 2 10
> 3 25
>
Dear all,
How to compile to excel pivot table ,
( B Column Count 5 to 15 )
A B C D E F G H
1
2 10
3 25
4 27
5 15
6 13
7 12
8 7
9 9
& tell me other formula & trick
Thanx
Please reply me
-
hi everyone
i've a task to prepare an attendance register of 10 candidates at my office..
i'm stuck in pivot table formation.. I'm attaching the sheet for your perusal..
I want name of candidates in rows.. present / leave / comp off / holiday being
the column header and count of prese
13 matches
Mail list logo
