Prev: hiden cells copied automatically to another workbook, can I stop .
Next: COUNTIF PROBLEM
From: Manos on 19 Apr 2010 04:21
Dear All

i have a range of coding where some of them are ending in letter I.
There is any way to group all of them?
Or is it possible to create an if function when the code in ending in I
gives true and else false.

Thanks in advance for your valuable time....

From: Roger Govier on 19 Apr 2010 04:24
Hi Manos

=IF(RIGHT(A1,1)="I",True,False)
--
Regards
Roger Govier

Manos wrote:
> Dear All
>
> i have a range of coding where some of them are ending in letter I.
> There is any way to group all of them?
> Or is it possible to create an if function when the code in ending in I
> gives true and else false.
>
> Thanks in advance for your valuable time....
>
From: Mike H on 19 Apr 2010 04:35
Maybe this

=RIGHT(A1,1)="I"
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Manos" wrote:

> Dear All
>
> i have a range of coding where some of them are ending in letter I.
> There is any way to group all of them?
> Or is it possible to create an if function when the code in ending in I
> gives true and else false.
>
> Thanks in advance for your valuable time....
>
 | 
Pages: 1
Prev: hiden cells copied automatically to another workbook, can I stop .
Next: COUNTIF PROBLEM