Search:

Type: Posts; User: Duwin; Keyword(s):

Search: Search took 0.00 seconds.

  1. Thread: Inquiry

    by Duwin
    Replies
    13
    Views
    308

    Re: Inquiry

    Ok i will try this..thank you very much jason for your help
  2. Thread: Inquiry

    by Duwin
    Replies
    13
    Views
    308

    Re: Inquiry

    Yes rick there are zeros between the first non zero cell snd the last cell..i need to tramsfer the first non zero cell up to the last cell in same order
  3. Thread: Inquiry

    by Duwin
    Replies
    13
    Views
    308

    Re: Inquiry

    It copied it in row but still in an inreasing order
  4. Thread: Inquiry

    by Duwin
    Replies
    13
    Views
    1,564

    Re: Inquiry

    Thank you very much peter ��
  5. Thread: Inquiry

    by Duwin
    Replies
    13
    Views
    1,564

    Re: Inquiry

    Sample:

    A1 10
    A2 20
    A3 40
    A4 28
    A5 0
    A6 35
    A7 29
    A8 40
  6. Thread: Inquiry

    by Duwin
    Replies
    13
    Views
    1,564

    Re: Inquiry

    Follow up question

    Given same data

    In a11 the logic must be when there is a cell with greater or equal to 35 and the consecutive cells are not yet zero, it must say "inspect" if not "ok"
  7. Thread: Inquiry

    by Duwin
    Replies
    13
    Views
    308

    Re: Inquiry

    Im so Sorry joe..it will not happen again 😔
  8. Thread: Inquiry

    by Duwin
    Replies
    13
    Views
    308

    Re: Inquiry

    Sorry my bad..for example i have it in sheet 1 row a1 to j1

    How can I transfer it to Sheet 2 and it will:
    *transfered all values to one column
    *it will transfer all values starting with the non...
  9. Thread: Inquiry

    by Duwin
    Replies
    13
    Views
    308

    Inquiry

    Good day guys!

    For example i have a set of data from sheet1 from column 1 to 10
    A1 0
    B1 0
    C1 0
    D1 2
    E1 34
    F1 65
    G1 32
  10. Thread: Inquiry

    by Duwin
    Replies
    13
    Views
    1,564

    Re: Inquiry

    Thanks peter..it is a big help 🙂
  11. Thread: Inquiry

    by Duwin
    Replies
    13
    Views
    1,564

    Re: Inquiry

    Thanks peter..

    For example i have values from cell
    A1 15
    A2 35
    A3 50
    A4 20
    A5 10
    A6 55
    A7 70
  12. Thread: Inquiry

    by Duwin
    Replies
    13
    Views
    1,564

    Re: Inquiry

    Thanks michael..can i do it in if functions?
  13. Thread: Inquiry

    by Duwin
    Replies
    13
    Views
    1,564

    Inquiry

    I have a bank of data that is updated monthly. I need to analyze said data to determine first all values above 35 then I need to look for two consecutive instances of this event. Once found, I would...
Results 1 to 13 of 13