Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Excel Formula Excel Formula
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 12-05-2016, 11:44 AM
ctruggles ctruggles is offline Excel Formula Windows 8 Excel Formula Office 2010 64bit
Novice
Excel Formula 		 
Join Date: Dec 2016
Posts: 1
ctruggles is on a distinguished road
Default Excel Formula
I have a column in a spreadsheet that reads True or False. I would like to make a formula that would take the false statements in that column and put them into another table. Also, if it would be possible for excel to tell me which rows that the false statement is present.

Any help is greatly appreciated.

Thanks,
Reply With Quote
  #2  
Old 12-05-2016, 12:12 PM
xor xor is offline Excel Formula Windows 10 Excel Formula Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Take a look at the attached.
Attached Files
File Type: xlsx FalseStatements.xlsx (10.6 KB, 13 views)
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Formula Help?? Jainam_Excel Excel 1 10-03-2016 03:43 PM
Excel Formula Excel Formula help dmcg9760 Excel 3 05-02-2016 11:50 PM
Excel Formula Excel formula help please! dreamer1963 Excel 2 03-16-2014 03:59 AM
Excel Formula ** Excel Formula djreyrey Excel 8 04-15-2011 03:55 PM
Excel Formula Help masoom84 Excel 1 03-07-2009 09:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:21 AM.

Contact Us - Privacy Statement - Top

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