Exact match with value

jiteshrohira

New Member
Joined
Jan 26, 2013
Messages
13
Check
Value 1Value 2Value 3Value 4Value 5Value 6Value 7
Value 8Value 9Value 10
223
2
2222222
22222222222

<colgroup><col><col span="10"></colgroup><tbody>
</tbody>

i have the information

Basically the check column should match all the values. So if Check is 2 and the corresponding values are as above it should give me exact match

so the in the first instance value 2 =3 does not match the check column which is 2 so the first line is a fail
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Puertorekinsam

Active Member
Joined
Oct 8, 2005
Messages
287
What is it you want it to do when it fails? Are we changing the color? are we putting a 'fail' in the third row?
 

jiteshrohira

New Member
Joined
Jan 26, 2013
Messages
13
i will add a row after the last check ie after value 10 and populate Fails if the value attribues are not matching
 

Weazel

Well-known Member
Joined
Dec 24, 2011
Messages
3,155
maybe something like...

=COUNTIF(B2:K2,A2)=10

which would return TRUE or FALSE.

Assuming that your data starts in A1
 

Puertorekinsam

Active Member
Joined
Oct 8, 2005
Messages
287
... Row or Column? Row's a horizontal. Columns are vertical....

So if I understand what you are saying, the entire first row will fail because there is a 3 in the row. But the entire second row will pass since there are only 2s?

So assuming your table is in Cells A1 through K3
Put this formula in L2:

=IF(COUNTIF(B2:K2,A2)/COUNT(B2:K2)<>1,"Fail","Pass")
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,122,193
Messages
5,594,774
Members
413,934
Latest member
austinb

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top