thank you all
On Thu, Mar 3, 2011 at 9:49 AM, Jenie wrote:
> Congratulation Ashish... keep it up
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of DILIPandey
> Sent: Wednesday, March 02, 2011 3:07 PM
> To: MS EXCEL AND VBA
Hi dharmesh
simply it will convert text (which numbers in text formats) to values.
equivalent to (value) function.
--
*Thanks & Regards
Thamu
*
On Fri, Mar 4, 2011 at 10:52 AM, Dharmesh Shah wrote:
> Thank you very much to group and specially to people who helped me
> In this formula you have
Hi Friends,
I have row data in the sheet1, which contains multiple data entries for the
same customer.
I am trying to extract each customer data in separate sheet (Extract_Data)
and at the same time calculating the average price & sum of the total
quantity shipped to the particular customer.
Whe
See attached file if it helps
--
--
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/grou
with conditional formatting
you just have to change% for conditions 1,2,3
chilexcel
2011/3/4 pawel lupinski
> Hi All,
> I realy need your help with formating of the cells. see inside.
> Thanks
> Pawel
>
> --
>
> ---
hey Mate, let me know what are you looking for (position), so maybe I can help
you. In the attachement you have sample of media supervisor. I don't know if
this help, so on Monday I'll find something.
Pawel
From: sudhir kumar
To: Excel Group
Sent: Fri, Marc
Thanks Mate, its great
From: STDEV(i)
To: excel-macros@googlegroups.com
Cc: pawel lupinski
Sent: Fri, March 4, 2011 6:31:35 PM
Subject: Re: $$Excel-Macros$$ help with formating
see inside if it help
On Fri, Mar 4, 2011 at 8:33 PM, pawel lupinski wrote:
H
Ahh perfect it condenses the 4 conditions to at least 2, it´s still a little
confusing for me to put formula into formulas and organize them. 1001 thanks
Paul, Excellent as usual :)
2011/3/3 Paul Schreiner
> I would use:
> =IF(IF(P3>T3,1,0)+IF(Q3>U3,1,0)+IF(R3>V3,1,0)+IF(S3>W3,1,0)>=2,true,false
when B15 contains *"CE 5900"*
=LEFT(B$15,2) resulting * "CE**"*
=RIGHT(B$15,4) resulting *"5900"* (data type = string / text)
we need *5900* ( a number), not *"5900"* ( a text / string* * )
so we *convert * *"5900"* into *5900* by this way *=--("5900")*
in the form of =--RIGHT(B$15,4
And also the can we show the amt in difference column itself instead of 'NA'
if it is as not found in report also.
Regards,
Kurikkal.
On Fri, Mar 4, 2011 at 6:59 PM, kurikkal padinjarappalla <
padinjarappa...@gmail.com> wrote:
> Dear Saurabh,
>
> Thank u very much!!
>
> It works
Hi All,
I realy need your help with formating of the cells. see inside.
Thanks
Pawel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceld
Hi
find the attachment and revert if it is not what you want.
--
*Thanks & Regards
Thamu
*
On Wed, Mar 2, 2011 at 11:54 AM, naresh v wrote:
> Hi Rambabu,
>
> please find the solution..
>
>
> Regards,
> Naresh V,
> Analyst
> Hyderabad.
>
> On Wed, Mar 2, 2011 at 3:08 AM, Vino
Sometimes that also does not work
then with the macro we need to create a copy of the file and relocate the
path to new file
On Mon, Feb 28, 2011 at 1:54 PM, §»VIPER«§ wrote:
> Sajid
>
> Tools > Share Workbook
>
>
> --
> *Thanks & Regards
>
> Thamu
> *
>
>
>
> On Sun, Feb 27, 2011 at 10:38 P
Will that behave as number?
that will behave as text then
On Sat, Feb 26, 2011 at 8:57 PM, Anil Bhange <
anil.bha...@tatacommunications.com> wrote:
> XL has a specification limit of 15 decimal digits of precision (see
> Help, "Specifications"). There's nothing you can to in XL itself to
> ext
Hi Friends
Can any one send me sample of CV(regarding Media service).
thanking u
--
<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
Sudhir Verma
Asstt. Mngr. A/c's
9818479722
*
P think Before you print
*
*
**
Life is Very beautiful !!!
*
*
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`
I you hide the data columns , Excel Will not show those columns in the chart
Excel Only shows the chart of visible columns and the filtered data
On Sun, Feb 27, 2011 at 10:33 PM, Dilip Pandey wrote:
> Hi Gaurav,
>
> I hv tried opening the attached file but it appears to be corrupted,
> please
This is really great.
And we need to know the options for %2 %3 also in the open parameters
On Sun, Feb 27, 2011 at 10:18 PM, Dilip Pandey wrote:
> Hi Susan,
>
> Seems to be interesting issue:-
> Two workarounds:-
>
> 1) Try closing the other Excel by key combination Ctrl + W. Also
> check wh
Thanks all for solution.
Nemi Gandhi
On Mar 3, 3:10 pm, §»VIPER«§ wrote:
> Hi
>
> Ignore my previous mail. Now check the attachment and revert if it is not
> helpful.
>
> --
> *Thanks & Regards
>
> Thamu
> *
>
>
>
> On Wed, Mar 2, 2011 at 10:45 AM, Nemi Gandhi wrote:
> > attached again with exp
thanx
and if you will find it's update version please sent me.
On 3 March 2011 08:31, Nemi Gandhi wrote:
> Sudhir vermaji,
>
> Attaached herewith income tax calculator in excel format. See if its
> useful?
>
> --
> Nemi Gandhi
> 98204 92963
>
> --
>
>
Thank you Nemi
On Thu, Mar 3, 2011 at 12:01 PM, Nemi Gandhi wrote:
> Sudhir vermaji,
>
> Attaached herewith income tax calculator in excel format. See if its
> useful?
>
> --
> Nemi Gandhi
> 98204 92963
>
> --
>
>
Thank you very much to group and specially to people who helped me
In this formula you have used Right & Left function but in Right function u
have used 2 times minus sign can u explain this please.
Thanks & Regards
Dharmesh Shah
On Fri, Mar 4, 2011 at 4:18 AM, siti Vi wrote:
> for your info o
21 matches
Mail list logo
