| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro that displays function from 2 columns
I have 2 columns in my spreadsheet that contain either True or False entries.
I'm looking to create a macro that will display the True entries from either column. If my sheet looks like this, A B 1 True False 2 True False 3 False False 4 False True 5 False True Then I want the macro to display only rows 1,2,4 & 5. The colums are never both True so I don't have to worry about that. I'm stuck with coming up with a function that will work, any help would be appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If, Or function or macro to compare 3 columns of numbers | Excel Worksheet Functions | |||
| Function displays but not the result - cause????? | Excel Worksheet Functions | |||
| The way the date displays in columns | New Users to Excel | |||
| Combo box in Excel that displays 2 columns | New Users to Excel | |||
| Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions | |||
Threaded Mode
