Re: $$Excel-Macros$$ Help required for Match DATA

2014-12-17 Thread Ashu k
Dear Sir, Can we do it by vba. please help. Thanks Ashu Kenith. On Wed, Dec 17, 2014 at 9:21 PM, Ashish Kumar wrote: > > Welcome Ashu. > > -- > 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

Re: $$Excel-Macros$$ Help required for Match DATA

2014-12-17 Thread Ashish Kumar
Welcome Ashu. -- 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 titles. Poor thread titles, like Please Help, Urgent,

Re: $$Excel-Macros$$ Help required for Match DATA

2014-12-17 Thread Ashu k
Dear Vaibhav/Ashish Sir, Thanks for your help. I am looking for this only. Thanks Ashu Kenith On Wed, Dec 17, 2014 at 9:10 PM, Ashish Kumar wrote: > > Hi Ashu, > > Check this!! > > > Regards > Ashish > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(

Re: $$Excel-Macros$$ Help required for Match DATA

2014-12-17 Thread Ashish Kumar
Hi Ashu, Check this!! Regards Ashish -- 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 titles. Poor thread titl

Re: $$Excel-Macros$$ Help required for Match DATA

2014-12-17 Thread Ashu k
Dear Sir, I want only single formula. I have some blank Cells in A and B column in sheet 2. Query is attached please check again. -- 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.

Re: $$Excel-Macros$$ Help required for Match DATA

2014-12-17 Thread Ashish Kumar
Hi Ashu, Use Simple Vlookup function which is suggested by Vaibhav Sir. and Delete NA# with help of filter. It's simple. Regards Ashish -- 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.

Re: $$Excel-Macros$$ Help required for Match DATA

2014-12-17 Thread Ashu k
Dear Sir, I have some Blank cells in A column and Some Blank Cells in B Column in sheet 2. I want to match the C column data from Sheet 1. only single formula required. If we don't want to put any formula in A and B column but some cells are blank in both columns. It is possible. Thanks Ashu K

Re: $$Excel-Macros$$ Help required for Match DATA

2014-12-17 Thread Ashu k
Dear Sir, I have huge data, So i want only single formula. or can it done by vba help. Thanks Ashu Kenith On Wed, Dec 17, 2014 at 8:35 PM, Ashu k wrote: > > Dear Sir, > > Thanks for your support. I dont want to get data in A and B column, I want > to get data in C column only. Don't want to pu

Re: $$Excel-Macros$$ Help required for Match DATA

2014-12-17 Thread Vaibhav Joshi
Yes, only if class no. is also unique the same way Name. Check this cell with blue color. Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Dec 17, 2014 at 8:35 PM, Ashu k wrote: > > Dear Sir, > > Thanks for your support. I dont want to get data in A a

Re: $$Excel-Macros$$ Help required for Match DATA

2014-12-17 Thread Ashu k
Dear Sir, Thanks for your support. I dont want to get data in A and B column, I want to get data in C column only. Don't want to put formula in A and B column. It is possible. to get data from Sheet 1 without put any formula in A and B column in Sheet 2. pls help. Thanks Ashu Kenith On Wed, De

Re: $$Excel-Macros$$ Help required for Match DATA

2014-12-17 Thread Vaibhav Joshi
Hi Check this..cell with yellow colour has formula. Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Dec 17, 2014 at 8:21 PM, Ashu k wrote: > > Dear Seniors, > > Please help. how can i get data from sheet 1 > > Ashu Kenith > > > On Wed, Dec 17, 2014 at

Re: $$Excel-Macros$$ Help required for Match DATA

2014-12-17 Thread Ashu k
Dear Seniors, Please help. how can i get data from sheet 1 Ashu Kenith On Wed, Dec 17, 2014 at 6:30 PM, Ashu k wrote: > > Dear Seniors, > > I have data in sheet 1 > > Name Class Roll NO. Exam Date > > > and, > > I have data in Sheet 2 > > Name Class Roll No. Exam Date > > > But some Name

$$Excel-Macros$$ Help required for Match DATA

2014-12-17 Thread Ashu k
Dear Seniors, I have data in sheet 1 Name Class Roll NO. Exam Date and, I have data in Sheet 2 Name Class Roll No. Exam Date But some Names are not in Name Column and Some Class are not in Class Column, I want to get all Roll No. in Sheet 2 from Sheet 1. Example data attached. Pleas