Forum Discussion

Stephen Jon's avatar
Stephen Jon
Copper Contributor
Feb 23, 2018

Excel 2007 Problem with an IF statement . Help

Hi Folks, I'd appreciate any help and many thanks in advance for taking the time.   I've excel 2007 and I'm trying to built a table .  column A will contain a number of random figures from -1 t...
Formulas & Functions
IF statement excel 2007
Stephen Jon's avatar
Stephen Jon
Copper Contributor
Feb 24, 2018

Hi Willy thank you I really appreciate the help .

 

For Column C  nothing appears with that code

 

For the other columns hashtag value! appears . sorry I don't have a hashtag symbol

 

Regards 

 

Stephen

Willy Lau's avatar
Willy Lau
Iron Contributor
Feb 24, 2018

Select C1, Create a name in name manager, Header

=IFERROR(LEFT(C$1, FIND(" ", C$1) - 1), C$1)

 Column C

=IF($A2 = VALUE(Header), $A2, "")

 

Column D to last column

=IF(AND($A2>VALUE(LEFT(Header, FIND("-", Header)-1)), $A2<=VALUE(MID(Header, FIND("-", Header)+1, 10))), $A2, "")

 

  • Stephen Jon's avatar
    Stephen Jon
    Copper Contributor
    Mar 21, 2018

    Hi Willy, 

     Sorry to get back to you at such late notice, I've been working away from home, and not had the time to take a look at this formula.

     

    I've tried to insert where I think you  want me place each code . but It doesn't seem to working. I think may be Its me being a  novice. 

     

    So I wander if you where able to screen shot each step that would help me get it right. 

    I'm not sure if you can post them here, or send to my email. St3ph3n31@hotmail.com

     I'd be eternally grateful and maybe, be able to return favour the one day. 

     

    Regards 

    Stephen 

Resources