| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Result based on Multiple Columns
I have 3 conditions defined across 3 columns of data, each with 0's or 1's
depending on partnership status of an account. If all three conditions / columns are 0, then it is a company direct account. I want to consolidate the date into 1 column (Company Direct, Partnered on Brand Y, Partnered on Brand X, Partner Direct). Would someone please suggest a formula for this, I rarely work with Excel and it is a Friday . . . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup for a value in multiple columns and return a result | Excel Discussion (Misc queries) | |||
| Conditional Format based on forumula result | Excel Discussion (Misc queries) | |||
| how can I have a formula result based on multiple criteria/columns | New Users to Excel | |||
| Automatically resize columns based on new formula result | Excel Discussion (Misc queries) | |||
| conditional formatting based on another cells formula result | Excel Discussion (Misc queries) | |||
Threaded Mode
