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.co
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
The best and the easiest way.
Regards
Rajender Soni | 750 322 55 50
On Aug 19, 12:12 am, Umesh Dev 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, 2010 at 12:06
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 wrote:
> Hi,
>
> You can use COUNTIF, which will return 1 if the id has been used only onc
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
To: "excel-macros@googl
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
Dave,
This worked beautifully. Thanks so much!
From: Dave Bonallack
To: "excel-macros@googlegroups.com"
Sent: Mon, August 16, 2010 2:56:11 AM
Subject: RE: $$Excel-Macros$$ Need to remove Alt + Enter
Hi Nadine,
Your original sample data had no spaces in it, s
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 f
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:
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 :
http://twitter.com/ex
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.
--
--
Some
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
KARV G.
DU PONT
65487
ROME
IT
IT
--
--
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
https://sites.google.com/site/e90e50/vba/rimuoverepasswordexcel
2010/8/18 viju mobile
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.c
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
wrote:
> Hi all I was wondering if you could help. I have a
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 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 customer group. I nee
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
ALPHA::KILO
--
--
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 tutor
Dear Dave,
Thanks a lot
Best Regards,
*
Venkat
*
On Wed, Aug 18, 2010 at 10:17 AM, Dave Bonallack
wrote:
> 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
> Subject: Re: $$Excel-Ma
Hi
You can use pivot for that.
Regards
Rajender Soni
On Aug 17, 10:51 am, Kal xcel 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
--
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 li
Use Pivot table on unique value, It could be on Code or Distributor
Name
On Aug 17, 10:51 am, Kal xcel 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
>
> Kalya
22 matches
Mail list logo
