Breaking consecutive figures.. Help

[ch0wie02]

the logic of my problem is very simple.. still i couldn't solve it. i have 3 sets of samples sheet 1 - 3.. if anyone here would like to help i would really appreciate it..

http://www.mediafire.com/?088gue0tg0fm38p

anyone please take a look tnx..

 

[GlennUK]

I can't see that due to security settings at work. Can you describe your problem?

 

[ch0wie02]

I can't see that due to security settings at work. Can you describe your problem?

HERE'S MY SAMPLE SETS..

 

[ch0wie02]

help

 

[ch0wie02]

 

[Peter_SSs]

Welcome to the MrExcel board!

A couple of tips to help you get the most from MrExcel:

Firstly, during weekends there are usually not many mambers on the forum so answers often do not come as fast.

Secondly, many helpers here will not download actual files and do not want to have to type out sample data to test solutions. So your linked file and images are not that much use to many of the potential helpers here.

You will get many more potential helpers if you could post that sample data directly here in your thread where we can copy it to our own sheets to work on a suggestion for you.

My signature block below contains 3 methods for posting small screen shots. Test them in the Test Here forum. That way, if something goes wrong, you won’t be messing up a main forum.

 

[ch0wie02]

thank you sir peter.. i have read the rules and tried the mrexcelhtml but i couldn't simplify my work for better illustration..

I already have 3 tests that applies on different inputs, if only i could merge them all or make a better condition that should be my "G4" it would really be a big help for me :D

test 1 --> =IF(D5>1,A5-1)
test 2 --> =IF(A5=1,C5)
test 3 --> =IF(A5="",0,C5-1)

D5 and so on --> =IF(C5="",0,C5-A5+1)

 

[GlennUK]

Why do you need a Tally block? What are you going to be doing with it exactly?

 

[ch0wie02]

problem solve.. :D lots of trial and error at last i've done it hehehe..

new problem.. =IF(A5=WORD,1) ..does excel has an option recognizing words? so when i write "word" on a5 it will result to 1..?

 

[GlennUK]

Put it in double quotes, in the formula.