Thank you Ashish and Viswanathan very much. Problem solved.
John
On Sun, Mar 27, 2011 at 2:28 AM, ashish koul koul.ash...@gmail.com wrote:
check the attachment see if it helps
On Sun, Mar 27, 2011 at 11:18 AM, ashish koul koul.ash...@gmail.comwrote:
On Sun, Mar 27, 2011 at 5:51 AM,
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
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 johnasmit...@gmail.comwrote:
I have an
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
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
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 dvpe...@gmail.com 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:
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 dvpe...@gmail.com wrote:
Hello,
I have a challenging pivot table issue that I hope I can get some help
on.
Here is
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 snarayana@gmail.comwrote:
Hi Subhash,
i hope this will solve your problem.
Rgds,
Mahesh Bisht
On Wed, Nov 25, 2009 at 11:50 AM, subhash tambe subhash.ta...@gmail.comwrote:
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
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
--
Pls clear your question make excel sheet with your data query and attach
with this mail.
Vir
2009/11/25 subhash tambe subhash.ta...@gmail.com
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
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
13 matches
Mail list logo