8 Visitor Messages

  1. View Conversation
    Hi can you please help me out in solving my problem
  2. View Conversation
    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!
  3. View Conversation
    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!
  4. View Conversation
    Thank you very much ... it really helped to learn ....
  5. I tried to explain it in the same thread. Hope you can understand.
  6. View Conversation
    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 .....
  7. 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
  8. View Conversation
    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
Showing Visitor Messages 1 to 8 of 8
About windknife

Basic Information


About windknife
Location:
Taiwan
My Microsoft Office Version:
Excel 2003

Statistics


Total Posts
Total Posts
270
Posts Per Day
0.26
Last Post
How to v lookup & use if statement? 09-03-2010 07:13 AM
Visitor Messages
Total Messages
8
Most Recent Message
08-02-2010 01:44 AM
General Information
Last Activity
01-31-2012 11:44 PM
Join Date
04-14-2009

2 Friends

  1. mubashir aziz mubashir aziz is offline

    Valued Forum Contributor

    mubashir aziz
  2. pike pike is offline

    Forum Moderator

    pike
Showing Friends 1 to 2 of 2

Search Engine Friendly URLs by vBSEO 3.2.0