#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Paste in B3 : =IF(A3=A2,"True","False")
Then drag down column. |
#3
|
|||
|
|||
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. |
#4
|
||||
|
||||
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. |
#5
|
|||
|
|||
Code:
=IF($A2=$A1,$B1,IF($B1="xxx",TRUE,NOT($B1))) |
#6
|
|||
|
|||
Thanks P45Cal
That worked perfectly. And you right, A9 and A10 should have been the same. |
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 |
Converting a 1 or 0 into TRUE or FALSE? | ayupchap | Mail Merge | 1 | 04-25-2017 02:45 PM |
Can you do True or False equations in Excel? | WisCowboy | Excel | 1 | 02-05-2016 04:53 PM |
Task Indicator - All predecessors complete true/false, y/n | jdove78 | Project | 2 | 10-10-2012 05:53 PM |
Mail Merge Function not Noticing 'True' vs. 'False' Statement | danellekent | Mail Merge | 1 | 04-27-2012 02:19 AM |