How do i match simillar data between two different rows in excel?
 

For eg i have two different rows, Row A and Row B. In row A there are nos
from 1 to 100 and row B all even no till 1000. How will i find the simillar
no in both the rows repeating by entering a formula. Eg V-lookup, H-Lookup,
Match etc. same as in text,nos,alphabet.

How do i match simillar data between two different rows in excel?
 

It is not clear exactly what you want to achieve, can you state the
problem more clearly. if you just want to see if a value exists in the
second row. what do you mean by similar? Exactly the same?

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=572551

How do i match simillar data between two different rows in exc
 

Good Afternoon Sir,

Yes sir i want to know the value in Group A is available in group B or not,
and the values of A which are not available in group B. Lets say the no 2 in
group A and the even no 2 in group B are same should be marked as available
and 3 should be marked as not available.

I apologise for mis - leading information and spelling mistakes.


Thanks & Regards
Victory
"Dav" wrote:


It is not clear exactly what you want to achieve, can you state the
problem more clearly. if you just want to see if a value exists in the
second row. what do you mean by similar? Exactly the same?

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=572551

How do i match simillar data between two different rows in excel?
 

well if you just wanted the numbers to be shown as available in row a
try conditional formating assuming the values are on the same sheet

if the first cell in the first group is a2

go to format, conditional formatting

put formula is =countif(range of second grp,a2)0

so perhaps =countif($d$1:$d$1000,a2)0

the format can be copied to the other cells with paste special formats

then choose the format to a colour. all these coloured cells are
available, if the definition of available is appearing in both groups.

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=572551