Use Pivot table on unique value, It could be on Code or Distributor
Name
On Aug 17, 10:51 am, Kal xcel kalx...@gmail.com wrote:
Dear experts,
I have SAP sales data, how to get top 10 distributor frm that huge data. One
distributor billed many times. Is there any mechanism??
Thanks in
Hi excel gurus,
I need to summarize items appearing in a column. I have attached a
sheet for your reference.
Thanks,
Abeer
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and
Hi
You can use pivot for that.
Regards
Rajender Soni
On Aug 17, 10:51 am, Kal xcel kalx...@gmail.com wrote:
Dear experts,
I have SAP sales data, how to get top 10 distributor frm that huge data. One
distributor billed many times. Is there any mechanism??
Thanks in advance
Kalyan
--
Dear Dave,
Thanks a lot
Best Regards,
*
Venkat
*
On Wed, Aug 18, 2010 at 10:17 AM, Dave Bonallack
davebonall...@hotmail.comwrote:
Hi,
Have a look at the attached to se if it does what you need.
Regards - Dave.
--
Date: Tue, 17 Aug 2010 22:06:40 +0530
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel
Hi all I was wondering if you could help. I have a sheet with entrys into a
cell that looks like this:
AAECHO::DELTA (422|279) K24
AALPHA::HOTEL (447|319) K34
ALPHA::FOXTROT (445|320) K34
ALPHA::GOLF (446|319) K34
ALPHA::INDIGO (448|320) K34
ALPHA::JULLIET (449|319) K34
Kalyan
I think Pivot table is your required solution using BP Group as your
Pivot Table Report Filter.
On Aug 18, 6:18 am, Kal xcel kalx...@gmail.com wrote:
Dear Experts,
I am attaching a file where I have raw data of Depot, Customer group, Month
and Sales data. There are 16 types of
Alex,
This a Text to Columns function. Select the column, use the Text to
Columns/ delimited function with space as an indicator.
In Excel 2007 Text to Columns can be found on the Data tab.
On Aug 18, 4:51 am, Alexander Cargill zanderman1...@googlemail.com
wrote:
Hi all I was wondering if you
https://sites.google.com/site/e90e50/vba/rimuoverepasswordexcel
2010/8/18 viju mobile vijumob...@gmail.com
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
check the attachment
Regards
Ashish
akoul.blogspot.com
On Wed, Aug 18, 2010 at 5:21 PM, Alexander Cargill
zanderman1...@googlemail.com wrote:
Hi all I was wondering if you could help. I have a sheet with entrys into
a cell that looks like this:
AAECHO::DELTA (422|279) K24
Hi group
I have piece of XML for example below which i need to repeat it for 1
times
May I request one of expert to develop a simple macro which will use Paste
command and paste piece of lines for 1 times.
Cheers
Kamal
P.S
Sample XML
TRACONCO1
NamCO17KARV G./NamCO17
I have a file that has 2 columns. The first contains an alpha numeric id and
the
second contains the name. Is there a way to find out if the id is associated
to
more than one name? Thank you.
--
--
Hi Viju
Please let me know how to use this addin.
Thanks in advance
With Regards
P.V. Ravi Kumar
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Dear Cargill,
I have prepared formule based on your file
Regards
Ramkesh
On Wed, Aug 18, 2010 at 5:21 PM, Alexander Cargill
zanderman1...@googlemail.com wrote:
Hi all I was wondering if you could help. I have a sheet with entrys into
a cell that looks like this:
AAECHO::DELTA
I am trying to create a formula:
For a given range which most values are NA, I want the cell to
return the value of the cell that is above the first cell that
contains value 0 (not NA).
--
--
Some important links for
Hi,
You can use COUNTIF, which will return 1 if the id has been used only once, or
greater than 1 if used multiple times.
Regards - Dave.
Date: Wed, 18 Aug 2010 15:54:49 -0700
From: n8dine4ma...@yahoo.com
Subject: $$Excel-Macros$$ Unique id to name
To: excel-macros@googlegroups.com
I
You're welcome
Regards - Dave.
Date: Wed, 18 Aug 2010 15:54:25 -0700
From: n8dine4ma...@yahoo.com
Subject: Re: $$Excel-Macros$$ Need to remove Alt + Enter
To: excel-macros@googlegroups.com
Dave,
This worked beautifully. Thanks so much!
From: Dave Bonallack
Hi
I would suggest you to use pivot for this type of data analysis. You
can take the count of name in pivot which is what you want.
Regards
Rajender Soni | 750 322 55 50
On Aug 19, 7:34 am, Dave Bonallack davebonall...@hotmail.com wrote:
Hi,
You can use COUNTIF, which will return 1 if the id
Hi
The best and the easiest way.
Regards
Rajender Soni | 750 322 55 50
On Aug 19, 12:12 am, Umesh Dev umesh.d...@gmail.com wrote:
Hi Sundervelan,
I have enclosed a file which will automatically update the moment you make a
change in the Master sheet.
Regards
Umesh
On Wed, Aug 18,
Thanks experts.
But I need the sale data of Distributor+super stockist only. not the
whole. I have done for one customer group=Distributor, by Sumifs function,
but when its matter of more than one customer group..sumifs not working
properly.
Please help.
Thanks in advance
Kalyan
On Wed,
Hi Becky,
If XL has put NA in a cell, you must already have a formula there. You'll need
to send a sample workbook so we can see get the whole picture.
Regards - Dave.
Date: Wed, 18 Aug 2010 12:15:30 -0700
Subject: $$Excel-Macros$$ Need help with a formula
From: rebecca.math...@kraft.com
21 matches
Mail list logo