Search:

Type: Posts; User: analyst

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    14
    Views
    3,875

    @Lalit, Thanks Brother. I did Ctrl+Shift+Enter...

    @Lalit,

    Thanks Brother. I did Ctrl+Shift+Enter to effect formula as Array Formula, but still error persist.
  2. Replies
    14
    Views
    3,875

    I'm closing this thread, as it is. Thanks for all...

    I'm closing this thread, as it is. Thanks for all the support, fellow members. I'm also exiting from this forum, trust no offence.

    Once again thanks for all the support that you all extended to...
  3. Replies
    14
    Views
    3,875

    Thanks Lalit. I did as you suggested, but in...

    Thanks Lalit. I did as you suggested, but in every cell, there is an error - #NAME?.

    Revised book is attached. Please guide/do the needful. Thanks a ton for suggestions.

    No idea, where i've...
  4. Replies
    14
    Views
    3,875

    I think moderators are not around, and few ill...

    I think moderators are not around, and few ill motivated members are spamming the forum creating annoyance.
  5. Replies
    14
    Views
    3,875

    Does above make sense? Is it too difficult? Or...

    Does above make sense? Is it too difficult? Or having seen no answer, should i close this thread?

    Seek, Senior's guidance.
  6. Replies
    14
    Views
    3,875

    Logically what I've done is to filter data table...

    Logically what I've done is to filter data table from row 19. From Column A, select down filtered rows, and copy data and paste special as values from Row A3. Later, using nested formula Index and...
  7. Replies
    14
    Views
    3,875

    @ alansidman, Agree , but doing this again and...

    @ alansidman,
    Agree , but doing this again and again for four tables is cumbersome, with other routine works on daily basis.

    So, using some nested formula, IF each column could bring relevant...
  8. Replies
    14
    Views
    3,875

    Should I modify the query to have VBA macro,...

    Should I modify the query to have VBA macro, instead of having Formula in place, Here only?
  9. Replies
    14
    Views
    3,875

    Any help here :confused:

    Any help here :confused:
  10. Replies
    14
    Views
    3,875

    Custom Formula based on Rank Remarks

    I've sheet1 where Students Name, Marks, Passing Status etc (Pass, Fail, ATKT) are given based on some Ranking system, for current Year (Range A19:F73), and for last 5 years (Range H19:M73).

    Row...
  11. Got the solution, was not properly put the...

    Got the solution, was not properly put the brackets

    the solution is like


    =IF(OR(AND(Z222>=5,(M222>=(M217*5)),(M222>=(M221*2)),K222>=50),AND(((K221>=50)),((K222/K221)>=5))),Z222&" Shock","")
  12. To combine above formula, I am trying following...

    To combine above formula, I am trying following which gives error


    IF(OR(AND(Z222>=5,(M222>=(M217*5)),(M222>=(M221*2)),K222>=50),((K221>=50),((K222/K221)>=5))),Z222&" Shock","")
  13. I have two formula, which I require to merge to...

    I have two formula, which I require to merge to have one single formula:

    Formula 1


    =IF(AND(Z222>=5,(M222>=(M217*5)),(M222>=(M221*2)),K222>=50),Z222&" Shock","")

    Formula 2
  14. Replies
    0
    Views
    740

    Combine two IF AND formula

    Kindly delete this post apology
  15. @p45Cal Thanks Brother, the above code works,...

    @p45Cal

    Thanks Brother, the above code works, except what is sought at Serial No. 5,6,7 in post #1, however is not done properly. I mean where there is no pair of row having data in Column E "YY",...
  16. Replies
    2
    Views
    2,544

    @ Thanks, Admin This could be nice code, when...

    @ Thanks, Admin

    This could be nice code, when someone is running a big procedures, and not sure whats going on except mouse pointer turns as hourglass.

    I guess, the main Macro/Code/Procedure...
  17. Anybody looking at this query, or should I...

    Anybody looking at this query, or should I modify? :(
  18. Sir, I've posted part of the solution, what I...

    Sir,
    I've posted part of the solution, what I was knowing through learning from the Forum.

    I am looking to solve this, kindly give the solution to this query. Thanks
  19. Delete Filtered Result, Sort From Specific Row And Delete Entire Row Having No Pairs

    Row 1 is the header so, it should not be deleted
    Data Range starts from A2 and across column O, and rows could vary from 25000+
    Now Macro should perform as under

    1) First delete all rows where...
  20. Delete Entire row if cell value does not have either two of specific word

    Data range starts from A9:M9, and last row varies on day to day basis.

    Adjacent cells like A1:M8, have data, which should not get disturbed.

    Column B has identifier flag, which in case is not...
  21. I just tried this, I guess this is right!!! ...

    I just tried this, I guess this is right!!!


    =IF(AND(Z6>=2.5,OR(AA6>AA5,AA5>AA4),(AA6>=AA4*0.9)),"New","Ignore")
  22. COMBINE AND OR with IF Function in Single Formula

    My current Formula is as under


    =IF(AND(Z6>=2.5,AA6>AA5,AA5>AA4),"New","Ignore")

    Now, within same formula, if above condition is not met BUT following condition is true, then also, it should...
  23. COrrected, I was calling separate procedure to...

    COrrected, I was calling separate procedure to sort the data, where I made mistkake.

    Correction in code, is as i mentioned in # 7, and as suggested by Brother bakerman #8. Thanks.

    Versatile...
  24. @bakerman, Thanks, I did that also as A:O is...

    @bakerman,

    Thanks, I did that also as A:O is 15 columns, and Column P would be 16th Column.

    Albeit with that also, macro gets executed, data in Column P is not correctly brought in line with...
  25. Dear Admin, Which line should be changed to...

    Dear Admin,

    Which line should be changed to what, (solution given in # 3 above), if i expand one more column upto P (Column P has only numeric value), and data test is now for 6 days, instead of 4...
Results 1 to 25 of 61
Page 1 of 3 1 2 3