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

[Guest]

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.

 

[Dav]

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

 

[Guest]

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]

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