Thread: Formula needed; I'm helpless
View Single Post
 
Old 12-07-2017, 06:02 AM
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
Into C27 enter the formula
Code:
=IF(C$26=1;1;"")
and copy te formula to range C27:C31.

Other 1's (in rows 24:25) aren't essential, as by your setup the value1 in row 26 is always having mathing 2 values in rows 24:25 in same column, or in next one.
Reply With Quote