Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 12-07-2017, 06:02 AM
ArviLaanemets ArviLaanemets is offline Formula needed; I'm helpless Windows 8 Formula needed; I'm helpless Office 2016
Expert
 
Join Date: May 2017
Posts: 960
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

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
 

Tags
complicated, formula, needed



Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula needed; I'm helpless Help needed with IF formula with a Vlookup jonnie_rc Excel 6 08-31-2017 01:27 PM
Formula needed; I'm helpless hard formula needed nfsmith Excel 6 03-19-2016 06:12 PM
Formula needed; I'm helpless Formula help needed Cosmo Excel 1 08-23-2012 11:50 AM
Very simple formula needed! nicholes Excel 4 04-12-2012 08:28 AM
Excel formula needed. Rod Excel 1 08-03-2009 06:55 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:05 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft