Thanks DP Sir, the code is now working perfectly.
Regards,
Mukesh Kumar
On Wed, Jul 17, 2013 at 6:40 AM, De Premor wrote:
> ignore my last email, i've made some change in variable declaration
> PFA
>
>
> On 17/07/2013 7:32, De Premor wrote:
>
> Hi, Mukesh Try to change this code:
>
> *For
Hi, Mukesh Try to change this code:
*For Each Rng In Data**
**If RangeCriteria.Cells(Rng.Row, 1) = Criteria Then Buf.Add
Rng.Value, Rng.Value**
**Next**
*
to
*For Each Rng In Data**
**i = i + 1**
**If RangeCriteria.Cells(i, 1) = Criteria Then Buf.Add
Rng.Va
Thanks Ashwin,
That was an interesting one.
I never came across any such alternative.
Thanks Again !
On Wed, Jul 17, 2013 at 12:21 AM, ashwani agnihotri <
ashwani.agniho...@gmail.com> wrote:
> hey plz go through this link for better understanding of using choose with
> vlookup..
>
> http://www.m
hey plz go through this link for better understanding of using choose with
vlookup..
http://www.myonlinetraininghub.com/excel-vlookup-to-the-left-using-choose
On Tue, Jul 16, 2013 at 5:20 PM, Ashish Kumar wrote:
>
>
> Dear Seniors,
>
> kindly find attached vlookup query, I want get output thru
excel 2003 and the last 4 would be the bottom
On Tuesday, July 16, 2013 9:36:13 AM UTC-4, ashish wrote:
> which version of excel are you using and last 4 do you mean from top or
> bottom of column ?
>
>
> On Tue, Jul 16, 2013 at 7:33 AM, > wrote:
>
>>
>>
>> Hello,
>>
>> I am using Excel 2003.
On Monday, July 15, 2013 10:03:35 PM UTC-4, bobsc...@yahoo.com wrote:
>
>
>
> Hello,
>
> I am using Excel 2003. I have attached a simple workbook which has two
> worksheets. One worksheet is titled "Scores" and the other is "Team Info".
> On the team info worksheet, I have all the nfl teams li
Hi,
How to know how many ranges are there in the attached workbook and how to
select last range using Area function.
Thanks in advance.
Regards,
Chandra
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this foru
So In nutshell Choose Function was used here as per choice of the person
and not out of any compulsion or requirement !
On Tue, Jul 16, 2013 at 8:12 PM, wrote:
> **
> Thanks Noorain Bhai and Kuldeep Bhai for the explanation.
>
>
> Sandeep Chhajer.
> Sent on my BlackBerry® from Vodafone
> ---
Thanks Noorain Bhai and Kuldeep Bhai for the explanation.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: NOORAIN ANSARI
Sender: excel-macros@googlegroups.com
Date: Tue, 16 Jul 2013 20:08:00
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googleg
Dear Sandeep,
Your question is correct, why we are using choose function, because it is
possible through only vlookup Function, no need to using choose Function.
But As per Question of Mr. Ashish Kumar, He want to use Choose function
with Vlookup.
We often use Choose function with vlookup to extr
Dear All,
My question is also the same why we are using choose funtion here! If any one
please explain the same then will be very thankful.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Kanwaljit Singh Dhunna
Sender: excel-macros@googlegroups.com
Date:
Specially thanks for Noorain Sir (Guru Dev).
Regards,
Kuldeep Singh
Assistant Manager Quality
Game Zone India Limited
Phone.: +91-9716615535
|| naukrikuld...@gmail.com ||
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
On Tue, Jul 16, 2013 at 7:40 PM
Dear Ashish,
Still Curious to know why do you use Choose here ?
On Tue, Jul 16, 2013 at 7:40 PM, Ashish Kumar wrote:
> Dear Seniors,
>
> Formula is working fine.
> Thanks for your help and support specially Noorain Sir, Kuldeep Sir and
> kanwaljit sir.
>
> Thanks
> Ashish
>
>
> On Tuesday, July
Dear Seniors,
Formula is working fine.
Thanks for your help and support specially Noorain Sir, Kuldeep Sir and
kanwaljit sir.
Thanks
Ashish
On Tuesday, July 16, 2013 7:26:49 PM UTC+5:30, kanwal_no1 wrote:
>
> As told by Kuldeep Ji with a small change, which might be causing trouble
> for you.
Dear Ashish,
I couldn't make out why you chose to use Choose function here. Am I missing
something ?
On Tue, Jul 16, 2013 at 7:35 PM, Kuldeep Singh wrote:
> Your Welcome Ashish.
>
> Regards,
> Kuldeep Singh
> Assistant Manager Quality
> Game Zone India Limited
> Phone.: +91-9716615535
> || naukr
Your Welcome Ashish.
Regards,
Kuldeep Singh
Assistant Manager Quality
Game Zone India Limited
Phone.: +91-9716615535
|| naukrikuld...@gmail.com ||
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
On Tue, Jul 16, 2013 at 7:33 PM, Ashish Kumar wrote:
As told by Kuldeep Ji with a small change, which might be causing trouble
for you.
First : Select 4 Rows like : J, K, L, M & Paste this formula
*=VLOOKUP(**$**I2,CHOOSE({1,2,3,4,5,6},$A$2:$A$7,$B$2:$B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7),{2,4,5,3,6},0)
& Press Ctrl + Shift + Enter then select J2:M20 &
Hi Ashish,
First : Select 4 Rows like : J, K, L, M & Paste this formula
*=VLOOKUP(I2,CHOOSE({1,2,3,4,5,6},$A$2:$A$7,$B$2:$B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7),{2,4,5,3,6},0)
& Press Ctrl + Shift + Enter then select J2:M20 & **Drag formula like Ctrl
+ D. It's working fine.*
Regards,
Kuldeep Singh
As
Dear Seniors,
Thanks for your help, but again i'hve geting same error. querry attached
please find. and help me to crack the query.
I'hve getting wrigh output when i put the formula in Name Column, but when
i paste the same formula in rest of fields like address, process,
salary...!! the form
Hi experts,
Does anyone know how to write a macro to create a skyline chart very basic.
Based on date.
Thanks,
Godiva
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discuss
which version of excel are you using and last 4 do you mean from top or
bottom of column ?
On Tue, Jul 16, 2013 at 7:33 AM, wrote:
>
>
> Hello,
>
> I am using Excel 2003. I have attached a simple workbook which has two
> worksheets. One worksheet is titled "Scores" and the other is "Team Info".
Hi Ashish,
Formula is working fine. Please find the attachment.
*Use formula with Ctrl + Shift + Enter (Select All Rows & Press Ctrl +
Shift + Enter).*
Regards,
Kuldeep Singh
Assistant Manager Quality
Game Zone India Limited
Phone.: +91-9716615535
|| naukrikuld...@gmail.com ||
*Please* *Consider
Dear Seniors,
Data Getting Error..please find the attached sheet for refrence.
Thanks
Ashish
On Tuesday, July 16, 2013 5:37:03 PM UTC+5:30, NOORAIN ANSARI wrote:
>
> Dear Ashish,
>
> Please try it..
>
> =VLOOKUP(I2,CHOOSE(*{1,2,3,4,5,6}*
> ,$A$2:$A$7,$B$2:$B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7)
Dear Sir,
Data geeting Error. please find attached sheet for refrence.
Thanks
Ashish
On Tuesday, July 16, 2013 5:48:14 PM UTC+5:30, sandeep chhajer wrote:
>
> Dear Noorain,
>
> Can you please elaborate the funtion!
> Thanks in advance.
>
> Sandeep Chhajer.
> Sent on my BlackBerry® from Vodaf
Dear Noorain,
Can you please elaborate the funtion!
Thanks in advance.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: NOORAIN ANSARI
Sender: excel-macros@googlegroups.com
Date: Tue, 16 Jul 2013 17:37:03
To: excel-macros@googlegroups.com
Reply-To: excel
Dear Ashish,
Please try it..
=VLOOKUP(I2,CHOOSE(*{1,2,3,4,5,6}*
,$A$2:$A$7,$B$2:$B$7,$C$2:$C$7,$D$2:$D$7,$E$2:$E$7),*{2,4,5,3,6}*,0) with
CSE
Note : Red Color is use for Index No. of Choose Function and green Color is
Columns Index no. of data
On Tue, Jul 16, 2013 at 5:20 PM, Ashish Kumar w
Dear Seniors,
kindly find attached vlookup query, I want get output thru vlookup choose
function. please help me on this query and please explain me why we use
{1,2,3,4,} in formula.
Thanks in advance.
Thanks
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? I
Thanks a Lot Vijay Jee. Good one.
Regards/Pravin.
-- Forwarded message --
From: P.VIJAYKUMAR
Date: Tue, Jul 16, 2013 at 2:41 PM
Subject: Re: $$Excel-Macros$$ Extract the data from one sheet to multiple
sheets
To: "excel-macros@googlegroups.com"
Respected Pravin,
Create a shee
Repected Vijay Kumar and Noorain Ansari.
Both of u and the team Thank u very much.
On 16 July 2013 16:46, P.VIJAYKUMAR wrote:
> Respected Muralidhar,
>
> See the following link and attached File.
> http://chandoo.org/wp/2010/11/02/multi-condition-lookup/
>
> Regards,
> Vijaykumar
>
>
> On Tue,
Dear Vijay Kumar.
Thank u
On 16 July 2013 16:40, Muralidhar E wrote:
> Thank u
>
>
>
> On 16 July 2013 16:34, NOORAIN ANSARI wrote:
>
>> Dear Muralidhar.
>>
>> it's the largest number that Excel can store. This "Big number" is used
>> to look up the last number in a range.
>>
>>
>> On Tue,
Thank u
On 16 July 2013 16:34, NOORAIN ANSARI wrote:
> Dear Muralidhar.
>
> it's the largest number that Excel can store. This "Big number" is used to
> look up the last number in a range.
>
>
> On Tue, Jul 16, 2013 at 4:09 PM, Muralidhar E wrote:
>
>>
>> Thanks mr, Ansari,
>>
>> I cant under
Respected Muralidhar,
You can see the following links for Examples
http://exceluser.com/blog/465/excels-best-lookup-method-index-match.html
http://www.youtube.com/watch?v=IX2TZ3OlOlA
http://www.randomwok.com/excel/how-to-use-index-match/
Regards,
Vijaykumar
On Tue, Jul 16, 2013 at 3:37 PM, Mura
Dear Muralidhar.
it's the largest number that Excel can store. This "Big number" is used to
look up the last number in a range.
On Tue, Jul 16, 2013 at 4:09 PM, Muralidhar E wrote:
>
> Thanks mr, Ansari,
>
> I cant understand the 9E+307 in the below formula
>
> =LOOKUP(9E+307,1/(C3:C9=E9),B3:B
Thanks mr, Ansari,
I cant understand the 9E+307 in the below formula
=LOOKUP(9E+307,1/(C3:C9=E9),B3:B9)
plz, help me on this with an example,it is help me more.
Thanks in advance
Warm Regards,
Muralidhar
On 16 July 2013 15:37, Muralidhar E wrote:
> Hi,
>
> ThanksVijay. can u present me w
Hi,
ThanksVijay. can u present me with an example,it is better to understand me.
Thanks in advance.
On 16 July 2013 15:07, P.VIJAYKUMAR wrote:
> Respected Muralidhar,
>
> You can use Index,Match,Indirect functions for accomplishing some look up
> tasks which are not possible by VLookup.
>
> R
PFA
On 16/07/2013 11:56, yas wrote:
Ill add my spreadsheet to help.
Its meant to work as a submit button, then transfer over data, then
clear Form 2 for someone else to add information.
On Tuesday, 16 July 2013 13:20:14 UTC+10, yas wrote:
Hi,
Im chasing help. I have two spreadsheets
Respected Muralidhar,
You can use Index,Match,Indirect functions for accomplishing some look up
tasks which are not possible by VLookup.
Regards,
VijayKumar
On Tue, Jul 16, 2013 at 3:02 PM, NOORAIN ANSARI wrote:
> Dear Murlidhar,
>
> Please visit here..
>
> http://www.excelvbaclinic.com/2011/0
Dear Murlidhar,
Please visit here..
http://www.excelvbaclinic.com/2011/08/reverse-vlookup-example.html
On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E wrote:
>
> Dear Friends good afternoon,
>
> I need help reg. lookup values
>
> 1.It is possible to vlookup the values for the left side
> 2.Vlo
PFA
On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E wrote:
>
> Dear Friends good afternoon,
>
> I need help reg. lookup values
>
> 1.It is possible to vlookup the values for the left side
> 2.Vlookup for the second value(occurence), third value
> Is their any other ways or functions to get th
Dear All,
I have some data which is in 2 columns A & B.
A column contains actual number of different type of bottles
B contains maximum number of bottles that can be placed in the row.
I want the output in C column which gives the number of bottles that can be
placed with help of formulae such t
Ups sorry, my mistake
i've attached new file for revision
Rgds,
[dp]
On 16/07/2013 15:27, Mukesh Kumar wrote:
Thanks a lot Sir, but duplicate entries are also coming twice eg Alwar
is coming twice in result. Can it also come single time.
Regards,
Mukesh Kumar
On Tue, Jul 16, 2013 at 1:48 P
Respected Pravin,
Create a sheet and remove the Totals rows.This you can selecting and
deleting them using filter.Then Create a Pivot table with Head quarter in
the Report Filter Field and all your required fields as per your required
layout.Now go to the Pivot table Options and select the Create
Dear Friends good afternoon,
I need help reg. lookup values
1.It is possible to vlookup the values for the left side
2.Vlookup for the second value(occurence), third value
Is their any other ways or functions to get the results.?
Thanks in advance.
--
*Thanks & Regards,*
**
*Muralidhar E
Thanks a lot Sir, but duplicate entries are also coming twice eg Alwar is
coming twice in result. Can it also come single time.
Regards,
Mukesh Kumar
On Tue, Jul 16, 2013 at 1:48 PM, De Premor wrote:
> Solution Attached
>
>
> On 16/07/2013 14:10, Mukesh Kumar wrote:
>
>> Hi Experts,
>>
>> I n
Solution Attached
On 16/07/2013 14:10, Mukesh Kumar wrote:
Hi Experts,
I need macro /formula for query given in attached file. The result
should come based on values given in column A.
Regards,
Mukesh Kumar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
It’s =TIME(
Hello Guys,
Please help Me how to write this :(
Thanks In Advance
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread
Hi Team,
Expecting replay on this mail as It will very helpful for me
Regards
On Thu, Jul 11, 2013 at 1:43 PM, vikas khen wrote:
> Hi Experts,
>
> I have found below attached Excel tracker on group it's Fantastic it's
> amazing! but i need to understand how it's Attendance calculate is
>
Hi Experts,
I need macro /formula for query given in attached file. The result should
come based on values given in column A.
Regards,
Mukesh Kumar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
h
48 matches
Mail list logo