Forum Discussion
Excel 2007 Problem with an IF statement . Help
Column A blank B. 1 C. 1-5 D . 5-10 E. 10-20 F. 20-30 G. 30-40 H.
3.5 3.5
1 1
10.7 10.7
2.4 2.4
22.3 22.3
35.6 35.6
Above is how I want it to look .
Column A are random numbers anything from -1 up to 100
As the random numbers are inputted to column A , it automatically appears in the table under the right category and in line with the relevant data input on the same line .
I hope that helps
Column C
=IF($A2 = $C$1, $A2, "")
Column D to last Column
=IF(AND($A2>VALUE(LEFT(D$1, FIND("-", D$1)-1)), $A2<=VALUE(MID(D$1, FIND("-", D$1)+1, 255))), $A2, "")
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
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, "")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