Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Thread: sequence

    by snjpverma
    Replies
    7
    Views
    480

    Re: sequence

    Hi Marcela,
    Your formula works great but I would like to kow why you used the part highlighted in Red at the end.
    ...
  2. Thread: sequence

    by snjpverma
    Replies
    7
    Views
    480

    Re: sequence

    Thanks Marcelo. That's exactly what I needed.
  3. Thread: sequence

    by snjpverma
    Replies
    7
    Views
    480

    Re: sequence

    thanks Demento for your support. the output is not numeric. It is an alphanumeric combination. Could you help me with the Index Match suggestion?

    Thanks MickG for your support. But I am not much...
  4. Thread: sequence

    by snjpverma
    Replies
    7
    Views
    480

    sequence

    assuming there is a team of 3 employees named a, b and c who have to be assigned a task as shown below.
    They have to be assigned task in the same sequence as it comes. i.e. First task to a, second...
  5. Replies
    7
    Views
    271

    Re: how to get Nearest higher value

    I tried the below but it doesn't work either. it seems to work only in Descending order. but my data is in ascending.

    =INDEX(G:G,MATCH(A2,G:G,-1))
  6. Replies
    7
    Views
    271

    Re: how to get Nearest higher value

    Hi Caleeco,
    I tried Your formula and it gives me the nearest lower value instead of the higher one
  7. Replies
    7
    Views
    271

    how to get Nearest higher value

    the data in Column G is in ascending order and I want the number from Column G which is closest to the value in A2 as my return value.

    the below lookup function gives me the closest lower value...
  8. Replies
    0
    Views
    149

    Advanced Filter

    If I put "East" Under the shops in my Output sheet, then all the rows which contains "East' in the Reference sheet should get pulled up. The problem is that Shops column contains input like this...
  9. Thread: If function?

    by snjpverma
    Replies
    6
    Views
    188

    Re: If function?

    try this

    =IF(A1>0,"a1 Loss","a1 Profit")
  10. Re: Not sure if nested IF, with AND, in addition to OR, unless there's a better way?

    could you give a sample data? I am not sure what you are looking for
  11. Replies
    4
    Views
    223

    Re: Formula not finding answer

    try this
    =IF(ISERROR(VLOOKUP(C2,A:B,2,FALSE)),"No match",VLOOKUP(C2,A:B,2,FALSE))
  12. Replies
    3
    Views
    2,205

    Re: Need help with IF(MATCH formula

    Welcome to the forum Zazybang,

    Try this

    =IF(COUNTIF(B6:B41,J6),"Yes","No")
  13. Replies
    19
    Views
    670

    Re: IF, with more than 1 result option.

    fintail, your formula is getting cut everytime i guess. so if your formula contains < or > symbol, then keep a space around these symbols to avoid the formula from getting cut.
  14. Replies
    12
    Views
    733

    Re: Vlookup with non specific value

    Caleeco, when you big a BigNum like this, the Lookup gives you the last value in the result array.
  15. Replies
    3
    Views
    202

    Re: ISBLANK or IF statements

    thanks for the update. glad it worked
  16. Re: Conditional formating specific number of cells based on another cell value

    Glad to have helped
  17. Re: Conditional formating specific number of cells based on another cell value

    select cell B1 and go to Conditional Formatting. Go to new rule> use a formula
    and put this formula.

    =COLUMN()<$A1+2

    Then copy B1 and paste the format to other cells where you want the same...
  18. Replies
    3
    Views
    202

    Re: ISBLANK or IF statements

    Try this

    =IF(B1,B1-A1,TODAY()-A1)
  19. how to fix the Grid lines missing in Excel

    The Grid lines just not visible on a PC. following things I have tried.
    1. The Gridlines are check-marked
    2. I selected the whole sheet and gave "No fill" to Fill colour.
    3. I went to Excel...
  20. Replies
    8
    Views
    404

    Re: Array Formulas

    This should work in such cases

    =SUM(COUNTIFS(A2:A4,D2:D3,B2:B4,TRANSPOSE(E2:E3)))
  21. Replies
    4
    Views
    280

    Re: Date Calculation

    wow that's brilliant Aladin. I was trying this for so long.
    This forum is full of genius people. Whenever I come here, I learn something new.
  22. Replies
    4
    Views
    280

    Re: Date Calculation

    any formula for this one? The only thing I want is: get the average of networkdays without the helper column C.
    Column C is the networkdays from Date in column B to Yesterday.

    This is basically...
  23. Replies
    4
    Views
    280

    Re: Date Calculation

    Just to highlight that the formula used column C has been mentioned at the bottom in Post #1 . It is a networkdays function which I use to find the difference from yesterday to the Date in Column B.
  24. Replies
    4
    Views
    280

    Date Calculation

    Hi Experts,

    My data is as below. is the output in Column G possible without helper column C?


    <colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col...
  25. Replies
    4
    Views
    94

    Re: Match/index look up for text

    I think the name of your sheet 2 is "Payment", so you need to make the necessary changes. Also, you have made changes to your sheet 1 in post 1 above..

    I made the below changes accordingly,
    ...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4