windknife
Valued Forum Contributor

Hi can you please help me out in solving my problem

Hi again WindKnife,

Is there any way to convert it from reading columns to reading rows? I posted an update on my thread.

If you don't want to work on it anymore, it's okay. I appreciate all of your help!

Hi WindKnife,

Thank you so much for helping me on my last thread. It was locked for a not so much legitimate reason, but oh well.

Your code worked perfectly,with 1 small exception. I wanted the numbers to be added if they didn't appear previously, is that possible? Here's the code:

=IF(ROWS($A$3:A4)=MATCH(LOOKUP(A4,{0,250.1,500.1,1000.1},{0,25,50,100}),LOOKUP($A$3:$A$100,{0,250.1, 500.1,1000.1},{0,25,50,100}),0),LOOKUP(A4,{0,250.1,500.1,1000.1},{0,25,50,100}),0)

If no previous cells are from 250-500 and the next cell is 600, I want the cell to be given the value of 75 (50[due to being over 500]+25[due to being over 250]). The same goes for being over 1000.

If there is one previous cell that is between 250-500 and the next cell is 600, I want the cell to be given the value of 50 (50[due to being over 500]+0[due to previous cells being over 250]). The same goes for being over 1000.

I wanted to let you know that I appreciated your help regardless.

Thanks again!

Thank you very much ... it really helped to learn ....

I tried to explain it in the same thread. Hope you can understand.

Hi,

Me too here to enhance my skill and still learning & trying to solve other problems .... will you be kind enough to elaborate below formula which you send in above link ???

http://www.excelforum.com/excel-gene...onditions.html



={SUM(PF2*(MATCH(IF(PF2,ENAME),IF(PF2,ENAME),0)=(ROW(ENAME))-2))}

Please define how it works exactly ...... especially Match & Row(ename)-2 .....

You are wellcome.I came here yesterday.
Originally, I want to enhance my ability to Excel.
I found your question is very interesting, so I try to slove it.
Very happy to help you ^_^

Regards,
Windknife

Hi,

I want to special thanks as your formula really helped me and right now i had to make another list with multiple project in which projects were repeating and i have to count then only once. I created EPROJECT & PJ2 array just like your previous trick and succeeded.
cheers