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.
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 direct2as...@gmail.com 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
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 direct2as...@gmail.com wrote:
Dear Seniors,
Please help. how can i get data from sheet 1
Ashu Kenith
On Wed,
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,
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 direct2as...@gmail.com 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
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 direct2as...@gmail.com wrote:
Dear Sir,
Thanks for your support. I dont want
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
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 @
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 @
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
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 kumar.ashish...@gmail.com
wrote:
Hi Ashu,
Check this!!
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
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,
Dear Sir,
Can we do it by vba.
please help.
Thanks
Ashu Kenith.
On Wed, Dec 17, 2014 at 9:21 PM, Ashish Kumar kumar.ashish...@gmail.com
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
13 matches
Mail list logo