Is IF() Conditional the way to do this?
- From: "Lorne Oliver" <lorne.oliver@xxxxxxxxx>
- Date: 4 Jul 2006 20:42:39 -0700
I am trying to collect data from a darts team and these values reflect
the number of points won in a team game (ranging from 0 - 3). This will
probably be simple for the experts here, so I'll let fly:
I have a table with six names across the top. In the rows below there
will always be two cells that have number values ranging from 0 - 3
while the rest will be blank. Those two numbers however, will always be
the same. I am trying to write a formula that will determine which
columns have values and return a single letter value (first initial)
for each name. Since all the names are different that is not an issue.
ex: Rodney Welles Scott Mina Barry Lorne
DBL -01 1 1
DBL -Cr 3 3
The intended results for the first row would be "WS" and "RM" for the
second row. I have been trying IF() constructions but am now stymied.
.
- Follow-Ups:
- Re: Is IF() Conditional the way to do this?
- From: Biff
- Re: Is IF() Conditional the way to do this?
- Prev by Date: Re: Convert Decimal hours and Minutes to minutes please.
- Next by Date: Re: How does Data Validation change with a formula change?
- Previous by thread: RE: Status Bar Configuration area
- Next by thread: Re: Is IF() Conditional the way to do this?
- Index(es):