Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.04 seconds.

  1. Thread: 4 IFs

    by hsandeep
    Replies
    3
    Views
    43

    Re: 4 IFs

    A polymath & brain box....it works:)
  2. Thread: 4 IFs

    by hsandeep
    Replies
    3
    Views
    43

    4 IFs

    I want to fill D2 as per below criteria’s

    D2=1 if B2>0
    D2=0 if B2<0
    D2=null if B2=zero 0 or null

    How to accomplish please?
  3. Thread: Simple IF

    by hsandeep
    Replies
    15
    Views
    245

    Re: Simple IF

    A different situation for D2

    D2=1 if B2>0
    D2=0 if B2<0
    D2=null if B2=zero 0 or null

    How to accomplish please?
  4. Re: largest, smallest, 2nd largest & 2nd smallest

    jasonb75, appreciate you for getting this solution so quickly so that I was able to implement it properly. Appreciate the time you took to share your experience and insights.
    I changed 31 to 3 in...
  5. Re: largest, smallest, 2nd largest & 2nd smallest

    Answers are correct on onedrive....but when I put the formulas in Excel Workbook, I am getting blanks in all cells. Definitely some mistake I am doing....but unable to solve. Please help. Attached...
  6. Re: largest, smallest, 2nd largest & 2nd smallest

    Yes this is the correct answers which I am looking for the 4 formulas. The sheet was read only...........I am trying to figure out the formulas in the cells, jasonb75
  7. Re: largest, smallest, 2nd largest & 2nd smallest

    I am very thankful to you for helping me to get the solution with your ideas / formulas / presentation. The help offered in it is a huge obligation. jasonb75, I am going to read the link, which I...
  8. Re: largest, smallest, 2nd largest & 2nd smallest

    Hi Akuini
    Which formula is giving correct results?
    Consider row #5 : N5 should be 600 (formula gives ""). Is it giving 600? If yes, what is the formula?
    O5 should be 500...
  9. Re: largest, smallest, 2nd largest & 2nd smallest

    sample data:correctly modified:



    <colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 34px"><col style="WIDTH: 34px"><col style="WIDTH: 34px"><col style="WIDTH: 34px"><col...
  10. Re: largest, smallest, 2nd largest & 2nd smallest

    Answer in rows 5 you have duplicate values You are correct. Correct answer is: N5=600, O5=500, P5=””, Q5=”” (largest & 2nd largest cannot be same, similarly smallest & 2nd smallest cannot be same,...
  11. Re: largest, smallest, 2nd largest & 2nd smallest

    the 4 formulas are not working..
    largest: For B3=500 & C3:L3=600; N3 should be 600 (formula gives answer as "");
    smallest: For B3=500 & C3:L3=600; O3 should be 500 (formula gives answer as "")...
  12. Re: largest, smallest, 2nd largest & 2nd smallest

    Why P9 = 50 (Should it be 80?)P9 should be 50 & not 80 since non duplicate is required
    Why Q9 = 10 (Should it be -9?)Q9 should be 10 & not -9 since non duplicate is required
    Why Q8 = -8 (Should it...
  13. largest, smallest, 2nd largest & 2nd smallest

    Posted on https://www.excelforum.com/excel-general/1294641-largest-smallest-2nd-largest-and-2nd-smallest-2.html#post5221789

    but could not got complete answer

    I need 4 formulae for: largest,...
  14. Replies
    36
    Views
    1,184

    Re: Code needed for Max & Min Values

    Hope I am not making you tired. Unfortunately, I would suffer more if I do not communicate you & get some desired solution how to speed up the code.

    Currently, every time VBA writes data to the...
  15. Replies
    36
    Views
    1,184

    Re: Code needed for Max & Min Values

    See if those code update fixes your blank issue:

    Private Sub Worksheet_Calculate()

    Dim cell As Range

    ' Exit if A1 not equal to 1
    If Range("A1") <> 1 Then Exit Sub

    ...
  16. Thread: Simple IF

    by hsandeep
    Replies
    15
    Views
    245

    Re: Simple IF

    You are CORRECT. I was WRONG. IT WORKS & as desired. Thanks Fluff
  17. Thread: Simple IF

    by hsandeep
    Replies
    15
    Views
    245

    Re: Simple IF

    NO it is giving wrong answer as 0. It should be giving 'formula' =F3 in cell G2 for B2 containing text 'd2'
  18. Thread: Simple IF

    by hsandeep
    Replies
    15
    Views
    245

    Re: Simple IF

    I want to ‘fill’ G2:G11 with FORMULAS ‘matching’ the text in B2

    IF B2=”d2” THEN G2:G11 should be ‘filled’ with FORMULAS ‘=F3’, ‘=F4’ & so on till ‘=F12’

    Similarly, IF B2=”d3” THEN G2:G11...
  19. Re: Time value to contain Months/Date/Year Hour:Minutes:Seconds AM/PM

    Thats it..IT WORKS. Thanks Scott R
  20. Re: Time value to contain Months/Date/Year Hour:Minutes:Seconds AM/PM

    Not getting..may be because of a2!!
  21. Time value to contain Months/Date/Year Hour:Minutes:Seconds AM/PM

    I need time containing Months/Date/Year Hour:Minutes:Seconds AM/PM as shown in I2 with input cells being B2:G2
    How to accomplish?
    I am using Excel 2007
    Sheet1


    <colgroup><col...
  22. Thread: Simple IF

    by hsandeep
    Replies
    15
    Views
    245

    Re: Simple IF

    Yes ACCEPTED & your formula has solved my another problem..Thanks for that
  23. Replies
    36
    Views
    1,184

    Re: Code needed for Max & Min Values

    Please EXTEND the existing code to perform the following 3 ADDITIONAL actions:

    EARLIER action:
    The code makes E2:F10 ‘grab’ MAXIMUM & MINIMUM (from B2:B10 when A1=1)

    ADDITIONAL:
    1. ...
  24. Thread: Simple IF

    by hsandeep
    Replies
    15
    Views
    245

    Re: Simple IF

    Yes .........its another way .......but I may need "k300" also......so can't figure out how to use your formula. The FIRST alphabet is "k" followed by POSITIVE INTEGER.........which depends on...
  25. Thread: Simple IF

    by hsandeep
    Replies
    15
    Views
    245

    Re: Simple IF

    Nice. IT WORKS....Thanks shg
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4