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 @
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 vikk...@gmail.com 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
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
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
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 d...@premor.net wrote:
Solution Attached
On 16/07/2013 14:10, Mukesh Kumar wrote:
Hi Experts,
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
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
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
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
PFA
On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E emuralidha...@gmail.comwrote:
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
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 emuralidha...@gmail.comwrote:
Dear Friends good afternoon,
I need help reg. lookup values
1.It is possible to vlookup the values for the
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 noorain.ans...@gmail.comwrote:
Dear Murlidhar,
Please visit here..
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
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 vijay.4...@gmail.com wrote:
Respected Muralidhar,
You can use Index,Match,Indirect functions for accomplishing some look up
tasks which are not possible
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 emuralidha...@gmail.com wrote:
Hi,
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 emuralidha...@gmail.comwrote:
Thanks mr, Ansari,
I cant understand the 9E+307 in the below formula
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,
Thank u
On 16 July 2013 16:34, NOORAIN ANSARI noorain.ans...@gmail.com 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 emuralidha...@gmail.comwrote:
Dear Vijay Kumar.
Thank u
On 16 July 2013 16:40, Muralidhar E emuralidha...@gmail.com wrote:
Thank u
On 16 July 2013 16:34, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Muralidhar.
it's the largest number that Excel can store. This Big number is used
to look up the last
Repected Vijay Kumar and Noorain Ansari.
Both of u and the team Thank u very much.
On 16 July 2013 16:46, P.VIJAYKUMAR vijay.4...@gmail.com wrote:
Respected Muralidhar,
See the following link and attached File.
http://chandoo.org/wp/2010/11/02/multi-condition-lookup/
Regards,
Vijaykumar
Thanks a Lot Vijay Jee. Good one.
Regards/Pravin.
-- Forwarded message --
From: P.VIJAYKUMAR vijay.4...@gmail.com
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
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?
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
Dear Noorain,
Can you please elaborate the funtion!
Thanks in advance.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: NOORAIN ANSARI noorain.ans...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Tue, 16 Jul 2013 17:37:03
To:
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 Vodafone
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}*
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
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, bobscore...@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
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 @
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
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 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
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
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 naukrikuld...@gmail.comwrote:
Your Welcome Ashish.
Regards,
Kuldeep Singh
Assistant Manager Quality
Game Zone India Limited
Phone.:
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,
Still Curious to know why do you use Choose here ?
On Tue, Jul 16, 2013 at 7:40 PM, Ashish Kumar kumar.ashish...@gmail.comwrote:
Dear Seniors,
Formula is working fine.
Thanks for your help and support specially Noorain Sir, Kuldeep Sir and
kanwaljit sir.
Thanks
Ashish
On
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
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 kanwal...@gmail.com
Sender:
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
Thanks Noorain Bhai and Kuldeep Bhai for the explanation.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: NOORAIN ANSARI noorain.ans...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Tue, 16 Jul 2013 20:08:00
To:
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, chhajersand...@gmail.com wrote:
**
Thanks Noorain Bhai and Kuldeep Bhai for the explanation.
Sandeep Chhajer.
Sent on my BlackBerry® from
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
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 listed in
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, bobsc...@yahoo.com javascript: wrote:
Hello,
I am
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 kumar.ashish...@gmail.comwrote:
Dear Seniors,
kindly find attached vlookup query, I
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
Thanks DP Sir, the code is now working perfectly.
Regards,
Mukesh Kumar
On Wed, Jul 17, 2013 at 6:40 AM, De Premor d...@premor.net 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:
*
47 matches
Mail list logo
