Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.09 seconds.

  1. Re: In the formula get cell value as a row number

    Brilliant Fluff, Your formula has solved my problem. It worked fine. Thank you very much for your help</SPAN></SPAN>

    Kind Regards,</SPAN></SPAN>
    Moti :)</SPAN></SPAN>
  2. Re: In the formula get cell value as a row number

    Bump...If formula is not workable may be VBA solution please </SPAN></SPAN>
  3. Re: In the formula get cell value as a row number

    I tried to modified using INDIRECT function in the formula to get cell value of B3 but it does not seems to work please need help </SPAN></SPAN>

    <b></b><table cellpadding="2.5px" rules="all"...
  4. In the formula get cell value as a row number

    Hello,</SPAN></SPAN>

    I am using the formula below, which is FD$6:FD$5006 this has end row number 5006 I need it pick the last row number from the cell value of B3 like "FD$6:FD$"&B3 is it can be...
  5. Replies
    8
    Views
    145

    Re: Need normal formula instead volatile

    FormR, I also consider this one is the best solution of my problem!</SPAN></SPAN>

    I appreciate your help </SPAN></SPAN>

    Kind Regards,</SPAN>
    Moti :)</SPAN>
  6. Replies
    8
    Views
    145

    Re: Need normal formula instead volatile

    jasonb75, really I do not delete any rows, tested your formula rectified $9 it is working well. Thank you for shorting it.</SPAN></SPAN>

    <b></b><table cellpadding="2.5px" rules="all"...
  7. Replies
    8
    Views
    145

    Re: Need normal formula instead volatile

    FormR, tried it is also running fine, I noticed the difference in your formula clicking on formula bar this highlights only the column G instead of all area, thank you so much for your...
  8. Replies
    8
    Views
    145

    Re: Need normal formula instead volatile

    jasonb75, it is running fine thank you very much for your help</SPAN></SPAN>

    Kind Regards,</SPAN>
    Moti</SPAN>
  9. Replies
    8
    Views
    145

    Need normal formula instead volatile

    Hello,</SPAN>

    At present using following volatile formula does it is possible to be converted in the normal formula</SPAN></SPAN>

    <b></b><table cellpadding="2.5px" rules="all"...
  10. Replies
    9
    Views
    311

    Re: VBA get target sum from the grid of 7*9

    Eric, I just ask for list but have given an entire solution with all the ended combinations. Surprised also within a 15 min that is unbelievable. I am very great full to you Eric it has been time...
  11. Replies
    9
    Views
    311

    Re: VBA get target sum from the grid of 7*9

    Wow, I appreciate your kind help Eric . It worked like an appeal. Absolutely Solved!</SPAN></SPAN>

    Good Luck </SPAN></SPAN>

    Kind Regards,</SPAN></SPAN>
    Moti</SPAN></SPAN>

    Eric, I have one...
  12. Replies
    9
    Views
    311

    Re: VBA get target sum from the grid of 7*9

    Eric, thank you very much for your response

    I totally agree with you I did not new it could be so much but now problem is that I cannot list any. And get the error 1004 so far I cannot examine...
  13. Replies
    9
    Views
    311

    Re: VBA get target sum from the grid of 7*9

    Eric, thank you so much for the code it works fine when set are less than 65531 rows in other case it highlights following line "Range("L6").Resize(Dict.Count, c) = Output" and give the error 1004, I...
  14. Replies
    9
    Views
    311

    VBA get target sum from the grid of 7*9

    Hello,

    I need a macro that allow me to create target sum from the grid of 7 columns and 9 rows...using technique picking a one number from each columns and making all possible targets sum can be...
  15. Re: Need to find corresponding row 0 value in the header C2:K2

    DanteAmor, This formula has "IFERROR" function, which is not compatible with excel 2000.


    This regular "SUMPRODUCT" formula worked like a charm no problem if result returns 0 in case there is no...
  16. Re: List of all possible 7 digit numbers between 1 and 20

    Please check under this link may help you
    https://www.ozgrid.com/forum/forum/help-forums/excel-general/18812-permutation-combinations
  17. Need to find corresponding row 0 value in the header C2:K2

    I need a formula or VBA, which can find corresponding row 0 value in the header C2:K2 and result in the column M</SPAN></SPAN>

    For an example... </SPAN></SPAN>
    Of the row 8 cell F8=0 so the value...
  18. Re: Please require a formula modification or a VBA alternatively

    Spot on! DanteAmor, the formula worked like a dream absolutely fantastic! </SPAN></SPAN>

    I appreciate your kind help and time for solving it. :beerchug:</SPAN></SPAN>
    Good Luck </SPAN></SPAN>
    ...
  19. Re: Please require a formula modification or a VBA alternatively

    Hello DanteAmor, if it could work changing the header any instead n1, n2, n3.... and so can be it only number like 1, 2, and 3.... or if formula works you can suggest any.... I can change it no...
  20. Re: Please require a formula modification or a VBA alternatively

    Hello DanteAmor, i am using Excel 2000 which I have mention in the post#1 bottom of the left corner I am getting result #¡VALUE!
    Yes I entered the formula by pressing the </SPAN></SPAN>Shift +...
  21. Re: Please require a formula modification or a VBA alternatively

    Hello DanteAmor, I think "COUNTIFS" function in the formula does not support my version. Please can you take a look? </SPAN></SPAN>

    Thank you for your help</SPAN></SPAN>

    Kind...
  22. Please require a formula modification or a VBA alternatively

    Hello,</SPAN></SPAN>

    Previously I had data as shown in the row 6 and formula in cell AV1 and fill to right and down (this formula extract only unique value in ascending order left to...
  23. Re: Count all values of each row from smaller to larger

    Hello lrobbo314, the "Function JA" results fine. I did not new it about "Google Sheets" every day there are new options thank you for letting me recognize.</SPAN></SPAN>

    I do appreciate your...
  24. Re: Count all values of each row from smaller to larger

    Outstanding! Akuini, much kind of you it worked like magic :-D</SPAN></SPAN>

    I appreciate your help a lot for solving it multiple times

    Have a good weekend</SPAN></SPAN>
    :beerchug:

    Kind...
  25. Re: Count all values of each row from smaller to larger

    Hello lrobbo314, I don't know if I got Power Query available in excel 2000, because i have never used the Power Query. and don't know where to find it. </SPAN></SPAN>

    Thank you for your help and...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4