View Single Post
 
Old 08-28-2017, 10:36 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

=AND($A2=$C2,$B2<>$D2)
or when you have your datarange defined as table (and column headers are without spaces)
=AND([@ID1]=[@ID2],[@Course1]<>[@Course2])
entered into ERROR column and copied down, returns TRUE/FALSE in ERROR column. It is enough to use ERROR column for filtering/order, but of-course you can use this formula as condition in IF() function to return anything different like "error"/"".
Reply With Quote