Conditional Result based on Multiple Columns
Also, there are a couple of conditions that are "Mixed" where some business
units on the account are "Partnered", and some are Partner Direct, such that
both columns G and H have 1, and I need to return to Column I the statement
"Mixed"
"AnnArborBrian" wrote:
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 . . .
|