View Single Post
 
Old 08-28-2017, 10:36 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
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