Re: $$Excel-Macros$$ Re: Guruuuuuuuu URGENT HELP ME
Pls help guru, its most urgent for me. help me On Sat, Aug 27, 2011 at 4:20 PM, kannan excel wrote: > Sorry Guru, > > Not i attached valid SIM NUMBER. You can match that in sim number > > > thanks & regards > Kannan V > Aircel Limited > Chennai > > > > On Sat, Aug 27, 2011 at 4:16 PM, Venkat CV wrote: > >> Hi Kannan, >>> >>> Please provide valid dataData is not matching with 2Nd sheet >>> >>> *Best Regards,* >>> *Venkat * >>> *Chennai* >>> * >>> * >>> >>> On Sat, Aug 27, 2011 at 4:10 PM, kannan excel wrote: >>> Dear Guru, Pls find the attachment and help me. and i want vloopkup formulas. Your's kannan.V Aircel Limited Chennai >>> >>> >>> >>> -- >>> * >>> * >>> * >>> * >>> >>> >>> >> >> >> -- >> *Best Regards,* >> *Venkat * >> *Chennai* >> * >> * >> * >> * >> >> >> -- >> >> -- >> 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 tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re: Guruuuuuuuu URGENT HELP ME
Hi Kannan, You are Welcome... *Best Regards,* *Venkat * *Chennai* * * On Sat, Aug 27, 2011 at 5:51 PM, kannan excel wrote: > Thanks Guru. > > i am really happy. > > Regards > > Kannan V > Aircel Limited. > Chennai > > On Sat, Aug 27, 2011 at 5:03 PM, Venkat CV wrote: > >> Hi Kannan.. >> >> Look attached... >> >> On Sat, Aug 27, 2011 at 4:37 PM, kannan excel >> wrote: >> >>> Pls help guru, its most urgent for me. >>> >>> help me >>> >>> On Sat, Aug 27, 2011 at 4:20 PM, kannan excel >>> wrote: >>> Sorry Guru, Not i attached valid SIM NUMBER. You can match that in sim number thanks & regards Kannan V Aircel Limited Chennai On Sat, Aug 27, 2011 at 4:16 PM, Venkat CV wrote: > Hi Kannan, >> >> Please provide valid dataData is not matching with 2Nd sheet >> >> *Best Regards,* >> *Venkat * >> *Chennai* >> * >> * >> >> On Sat, Aug 27, 2011 at 4:10 PM, kannan excel > > wrote: >> >>> Dear Guru, >>> >>> >>> Pls find the attachment and help me. >>> and i want vloopkup formulas. >>> >>> Your's >>> >>> kannan.V >>> Aircel Limited >>> Chennai >>> >>> >> >> >> >> -- >> * >> * >> * >> * >> >> >> > > > -- > *Best Regards,* > *Venkat * > *Chennai* > * > * > * > * > > > -- > > -- > 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 tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > >>> >> >> >> -- >> *Best Regards,* >> *Venkat * >> *Chennai* >> * >> * >> * >> * >> >> >> > -- * * * * -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re: Guruuuuuuuu URGENT HELP ME
Thanks Guru. i am really happy. Regards Kannan V Aircel Limited. Chennai On Sat, Aug 27, 2011 at 5:03 PM, Venkat CV wrote: > Hi Kannan.. > > Look attached... > > On Sat, Aug 27, 2011 at 4:37 PM, kannan excel wrote: > >> Pls help guru, its most urgent for me. >> >> help me >> >> On Sat, Aug 27, 2011 at 4:20 PM, kannan excel >> wrote: >> >>> Sorry Guru, >>> >>> Not i attached valid SIM NUMBER. You can match that in sim number >>> >>> >>> thanks & regards >>> Kannan V >>> Aircel Limited >>> Chennai >>> >>> >>> >>> On Sat, Aug 27, 2011 at 4:16 PM, Venkat CV wrote: >>> Hi Kannan, > > Please provide valid dataData is not matching with 2Nd sheet > > *Best Regards,* > *Venkat * > *Chennai* > * > * > > On Sat, Aug 27, 2011 at 4:10 PM, kannan excel > wrote: > >> Dear Guru, >> >> >> Pls find the attachment and help me. >> and i want vloopkup formulas. >> >> Your's >> >> kannan.V >> Aircel Limited >> Chennai >> >> > > > > -- > * > * > * > * > > > -- *Best Regards,* *Venkat * *Chennai* * * * * -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel >>> >>> >> > > > -- > *Best Regards,* > *Venkat * > *Chennai* > * > * > * > * > > > -- -- 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 tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re: Guruuuuuuuu URGENT HELP ME
Dear Noorain,
Good solution array formula...
*Best Regards,*
*Venkat *
*Chennai*
On Sat, Aug 27, 2011 at 8:48 AM, NOORAIN ANSARI wrote:
> Dear Kannan,
>
> Venkat solution is great but you can use one Vlookup Instead of Three
> Vlookup.
>
> Press ctrl+shift+Enter
>
> {=VLOOKUP(B2,'Aug 11'!$C:$J,{4,3,8},0)}
> See attached sheet...
> On Sat, Aug 27, 2011 at 4:16 PM, Venkat CV wrote:
>
>> Hi Kannan,
>>>
>>> Please provide valid dataData is not matching with 2Nd sheet
>>>
>>> *Best Regards,*
>>> *Venkat *
>>> *Chennai*
>>> *
>>> *
>>>
>>> On Sat, Aug 27, 2011 at 4:10 PM, kannan excel wrote:
>>>
Dear Guru,
Pls find the attachment and help me.
and i want vloopkup formulas.
Your's
kannan.V
Aircel Limited
Chennai
>>>
>>>
>>>
>>> --
>>> *
>>> *
>>> *
>>> *
>>>
>>>
>>>
>>
>>
>> --
>> *Best Regards,*
>> *Venkat *
>> *Chennai*
>> *
>> *
>> *
>> *
>>
>>
>> --
>>
>> --
>> 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 tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://noorain-ansari.blogspot.com/*
RE: $$Excel-Macros$$ Re: Guruuuuuuuu URGENT HELP ME
Also I wanted understand, the benefit of Array in excel.
Based on your example, I got the idea on how to use this??? But what if I use 3
Vlookup or 1 Array is that making significant change or what is the benefit of
it,
The drawback which I could see here of Array is "We can't change the formula
and we have to delete all the formula and apply it again"
So instead why can't we use normal formula and change it accordingly as per our
requirement.
Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of NOORAIN ANSARI
Sent: Saturday, August 27, 2011 09:18 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Guruuuu URGENT HELP ME
Dear Kannan,
Venkat solution is great but you can use one Vlookup Instead of Three Vlookup.
Press ctrl+shift+Enter
{=VLOOKUP(B2,'Aug 11'!$C:$J,{4,3,8},0)}
See attached sheet...
On Sat, Aug 27, 2011 at 4:16 PM, Venkat CV
mailto:venkat1@gmail.com>> wrote:
Hi Kannan,
Please provide valid dataData is not matching with 2Nd sheet
Best Regards,
Venkat
Chennai
On Sat, Aug 27, 2011 at 4:10 PM, kannan excel
mailto:kannan.ex...@gmail.com>> wrote:
Dear Guru,
Pls find the attachment and help me.
and i want vloopkup formulas.
Your's
kannan.V
Aircel Limited
Chennai
--
--
Best Regards,
Venkat
Chennai
--
--
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 tutorials at
http://www.excel-macros.blogspot.com<http://www.excel-macros.blogspot.com/>
4. Learn VBA Macros at
http://www.quickvba.blogspot.com<http://www.quickvba.blogspot.com/>
5. Excel Tips and Tricks at
http://exceldailytip.blogspot.com<http://exceldailytip.blogspot.com/>
To post to this group, send email to
excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
Thanks & regards,
Noorain Ansari
http://noorain-ansari.blogspot.com/
--
--
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 tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to
excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
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 tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re: Guruuuuuuuu URGENT HELP ME
Dear Anil,
Benefit of Array Function.
If you've done even a little programming, you've probably run across the
term *array*. For our purposes, an array is just a collection of items. In
Excel, those items can reside in a single row (called a* one-dimensional
horizontal* array), a column (a *one-dimensional vertical* array), or
multiple rows and columns (a *two-dimensional *array). You can't create
three-dimensional arrays or array formulas in Excel.
An *array formula* is a formula that can perform multiple calculations on
one or more of the items in an array. Array formulas can return either
multiple results or a single result. For example, you can place an array
formula in a range of cells and calculate a column or row of subtotals. You
can also place a formula in a single cell and calculate a single amount. An
array formula that resides in multiple cells is called (logically enough) a
*multi-cell* formula, and an array formula that resides in a single cell is
called a *single-cell* formula.
For more u can click on below given link..
http://www.cpearson.com/excel/ArrayFormulas.aspx
http://office.microsoft.com/en-us/excel-help/introducing-array-formulas-in-excel-HA001087290.aspx
On Sun, Aug 28, 2011 at 9:17 PM, Anil Bhange <
anil.bha...@tatacommunications.com> wrote:
> Also I wanted understand, the benefit of Array in excel.
>
> ** **
>
> Based on your example, I got the idea on how to use this??? But what if I
> use 3 Vlookup or 1 Array is that making significant change or what is the
> benefit of it,
>
> ** **
>
> The drawback which I could see here of Array is “We can’t change the
> formula and we have to delete all the formula and apply it again”
>
> So instead why can’t we use normal formula and change it accordingly as per
> our requirement.
>
> ** **
>
> Regards,Anil Bhange
>
> IP Phone - 512320 | Mobile - 90290 32123
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
> *Sent:* Saturday, August 27, 2011 09:18 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Re: Gur URGENT HELP ME
>
> ** **
>
> Dear Kannan,
>
>
>
> Venkat solution is great but you can use one Vlookup Instead of Three
> Vlookup.
>
>
>
> Press ctrl+shift+Enter
>
>
>
> {=VLOOKUP(B2,'Aug 11'!$C:$J,{4,3,8},0)}
>
> See attached sheet...
>
> On Sat, Aug 27, 2011 at 4:16 PM, Venkat CV wrote:*
> ***
>
> Hi Kannan,
>
> ** **
>
> Please provide valid dataData is not matching with 2Nd sheet
>
> ** **
>
> *Best Regards,*
>
> *Venkat *
>
> *Chennai*
>
> ** **
>
> ** **
>
> On Sat, Aug 27, 2011 at 4:10 PM, kannan excel
> wrote:
>
> Dear Guru,
>
>
>
>
>
> Pls find the attachment and help me.
>
> and i want vloopkup formulas.
>
>
>
> Your's
>
>
>
> kannan.V
>
> Aircel Limited
>
> Chennai
>
>
>
>
>
>
>
> ** **
>
> --
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
>
>
>
>
> ** **
>
> --
>
> *Best Regards,*
>
> *Venkat *
>
> *Chennai*
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
> --
>
> --
> 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 tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>
>
>
> --
>
> Thanks & regards,
>
> Noorain Ansari
>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
>
> ** **
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedI
RE: $$Excel-Macros$$ Re: Guruuuuuuuu URGENT HELP ME
Oh that's great... thank you very much
Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of NOORAIN ANSARI
Sent: Monday, August 29, 2011 04:38 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Guruuuu URGENT HELP ME
Dear Anil,
Benefit of Array Function.
If you've done even a little programming, you've probably run across the term
array. For our purposes, an array is just a collection of items. In Excel,
those items can reside in a single row (called a one-dimensional horizontal
array), a column (a one-dimensional vertical array), or multiple rows and
columns (a two-dimensional array). You can't create three-dimensional arrays or
array formulas in Excel.
An array formula is a formula that can perform multiple calculations on one or
more of the items in an array. Array formulas can return either multiple
results or a single result. For example, you can place an array formula in a
range of cells and calculate a column or row of subtotals. You can also place a
formula in a single cell and calculate a single amount. An array formula that
resides in multiple cells is called (logically enough) a multi-cell formula,
and an array formula that resides in a single cell is called a single-cell
formula.
For more u can click on below given link..
http://www.cpearson.com/excel/ArrayFormulas.aspx
http://office.microsoft.com/en-us/excel-help/introducing-array-formulas-in-excel-HA001087290.aspx
On Sun, Aug 28, 2011 at 9:17 PM, Anil Bhange
mailto:anil.bha...@tatacommunications.com>>
wrote:
Also I wanted understand, the benefit of Array in excel.
Based on your example, I got the idea on how to use this??? But what if I use 3
Vlookup or 1 Array is that making significant change or what is the benefit of
it,
The drawback which I could see here of Array is "We can't change the formula
and we have to delete all the formula and apply it again"
So instead why can't we use normal formula and change it accordingly as per our
requirement.
Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123
From: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
[mailto:excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>] On
Behalf Of NOORAIN ANSARI
Sent: Saturday, August 27, 2011 09:18 PM
To: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
Subject: Re: $$Excel-Macros$$ Re: Gur URGENT HELP ME
Dear Kannan,
Venkat solution is great but you can use one Vlookup Instead of Three Vlookup.
Press ctrl+shift+Enter
{=VLOOKUP(B2,'Aug 11'!$C:$J,{4,3,8},0)}
See attached sheet...
On Sat, Aug 27, 2011 at 4:16 PM, Venkat CV
mailto:venkat1@gmail.com>> wrote:
Hi Kannan,
Please provide valid dataData is not matching with 2Nd sheet
Best Regards,
Venkat
Chennai
On Sat, Aug 27, 2011 at 4:10 PM, kannan excel
mailto:kannan.ex...@gmail.com>> wrote:
Dear Guru,
Pls find the attachment and help me.
and i want vloopkup formulas.
Your's
kannan.V
Aircel Limited
Chennai
--
--
Best Regards,
Venkat
Chennai
--
--
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 tutorials at
http://www.excel-macros.blogspot.com<http://www.excel-macros.blogspot.com/>
4. Learn VBA Macros at
http://www.quickvba.blogspot.com<http://www.quickvba.blogspot.com/>
5. Excel Tips and Tricks at
http://exceldailytip.blogspot.com<http://exceldailytip.blogspot.com/>
To post to this group, send email to
excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
Thanks & regards,
Noorain Ansari
http://noorain-ansari.blogspot.com/
--
--
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 tutorials at
http://www.excel-macros.blogspot.com<http://www.excel-macros.blogspot.com/>
4. Learn VBA Macros at
http://www.quickvba.blogspot.com<http://www.quickvba.blogspot.com/>
5. Excel Tips and Tricks at
http://exceldailytip.blogspot.com<http://exceldailytip.blogspot.com/>
To post to this group, send email to
excel-macros@googlegroups.com<mailto:excel-macros@googl
