Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-17-2020, 09:38 AM
wheddingsjr wheddingsjr is offline True/False formula Windows 7 64bit True/False formula Office 2016
Advanced Beginner
True/False formula
 
Join Date: Mar 2017
Posts: 76
wheddingsjr is on a distinguished road
Default True/False formula

Hi all


I used to have a formula that I would use to determine if a number in a column was the same as the one above it and each time the number changed the cell with the formula in it would populate with TRUE or FALSE (Obviously the first row in the formula column had to be manually written in). But I started a new job and left my list of formulas behind. I am attaching an example as a reference.




Thanks
Attached Files
File Type: xlsx Book1.xlsx (10.7 KB, 10 views)
Reply With Quote
  #2  
Old 01-17-2020, 11:11 AM
Logit Logit is offline True/False formula Windows 10 True/False formula Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

Paste in B3 : =IF(A3=A2,"True","False")

Then drag down column.
Reply With Quote
  #3  
Old 01-17-2020, 11:35 AM
wheddingsjr wheddingsjr is offline True/False formula Windows 7 64bit True/False formula Office 2016
Advanced Beginner
True/False formula
 
Join Date: Mar 2017
Posts: 76
wheddingsjr is on a distinguished road
Default

Hi Logit


Thanks for the feedback. The formula you suggested didn't look quite like the formula I was using before. Plus it didn't give me the desired outcome. The formula I used was something like this:


=IF(AM3=AM2,B3=B2)


And it would group all the numbers as TRUE (if you manually entered TRUE in B1 or if you manually entered FALSE in B1 than all the numbers that were the same would say FALSE). Only when the new set of numbers appear does it switch to the opposite of whatever you used first. That way, when I wanted to shade the groupings I could use the TRUE and FALSE narrative to differentiate the groupings. I hope that didn't sound as bad as it did in my mind as I was typing.
Reply With Quote
  #4  
Old 01-18-2020, 08:50 AM
p45cal's Avatar
p45cal p45cal is online now True/False formula Windows 10 True/False formula Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

in B3:
=IF(A2=A3,B2,NOT(B2))
seed B2 with TRUE or FALSE


Note that in your file, cells A9 and A10 are different.
Reply With Quote
  #5  
Old 01-19-2020, 11:53 PM
ArviLaanemets ArviLaanemets is offline True/False formula Windows 8 True/False formula Office 2016
Expert
 
Join Date: May 2017
Posts: 869
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

Code:
=IF($A2=$A1,$B1,IF($B1="xxx",TRUE,NOT($B1)))
Reply With Quote
  #6  
Old 01-20-2020, 07:47 PM
wheddingsjr wheddingsjr is offline True/False formula Windows 7 64bit True/False formula Office 2016
Advanced Beginner
True/False formula
 
Join Date: Mar 2017
Posts: 76
wheddingsjr is on a distinguished road
Default

Thanks P45Cal

That worked perfectly. And you right, A9 and A10 should have been the same.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
True/False Error DonBerg68 Excel 2 08-30-2019 08:51 PM
True/False formula Converting a 1 or 0 into TRUE or FALSE? ayupchap Mail Merge 1 04-25-2017 02:45 PM
True/False formula Can you do True or False equations in Excel? WisCowboy Excel 1 02-05-2016 04:53 PM
True/False formula Task Indicator - All predecessors complete true/false, y/n jdove78 Project 2 10-10-2012 05:53 PM
True/False formula Mail Merge Function not Noticing 'True' vs. 'False' Statement danellekent Mail Merge 1 04-27-2012 02:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:41 AM.


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