If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Check the lasta character
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.... |
#2
|
|||
|
|||
Check the lasta character
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.... |
#3
|
|||
|
|||
Check the lasta character
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.... |
Thread Tools | |
Display Modes | |
|
|