Ask Experts Questions for FREE Help !
Ask

Search:

Type: Posts; User: Kevin-Radstock

Search: Search took 0.00 seconds.

  1. Answers
    6
    Views
    2,122

    Where is the error! See the attached

    Where is the error! See the attached
  2. Answers
    6
    Views
    2,122

    May be something along these lines. ...

    May be something along these lines.

    =IF(COUNTIF($C$2:C2,C2)>1,"",MIN(IF($C$2:$C$21=C2,$I$2:$I$21))). This is an array formula, CTRL + SHIFT+ ENTER to commit and copy down. You can also format the...
  3. Answers
    5
    Views
    2,238

    Hi How about a sample spread sheet with dummy...

    Hi

    How about a sample spread sheet with dummy data and your expected result instead of typing all that.
  4. Hi Try formatting the cells, as " General"*" "...

    Hi

    Try formatting the cells, as " General"*" " with out the double quotes.
  5. Answers
    3
    Views
    1,559

    Hi You can use the ROUND function, for...

    Hi

    You can use the ROUND function, for example.
    =ROUND(A1/A2,2) which will round to 2 decimal places.
  6. Answers
    2
    Views
    654

    Not seeing what your data is like. If for...

    Not seeing what your data is like. If for instance you want 6 digits then format the cells as "000000" (without the quotes), this will display leading zero's ie: 123: 000123. Otherwise text.
  7. Hi Hi varadhu Conditional formatting, select...

    Hi Hi varadhu

    Conditional formatting, select cells B2:G11

    Then apply the rules. For Excel 2007 +. On the Home Tab > Conditional formatting > new rule. Or keyboard shortcut: ALT + H L N
  8. Hi varadhu Conditional Formatting Rules. ...

    Hi varadhu

    Conditional Formatting Rules.

    For the MAX on each row:
    =B2=MAX($B2:$G2)

    For the MIN on each row:
    =B2=MIN($B2:$G2)
Results 1 to 8 of 8