Search:

Type: Posts; User: Kevin@Radstock

Search: Search took 0.01 seconds.

  1. Replies
    4
    Views
    1,806

    Hi A formula approach and format cells as...

    Hi

    A formula approach and format cells as "hh:mm AM/PM"

    =--MID(E2,FIND(":",E2)-2,8)
  2. HI Maybe try incorporating the LOOKUP function....

    HI
    Maybe try incorporating the LOOKUP function.

    =LOOKUP(MONTH(A1+180),{1,2,3,4,5,6,7,8,9,10,11,12},{"JA","FE","MR","AL","MA","JN","JL","AU","SE","OC","NO","DE"})

    Alternatively the VLOOKUP can...
  3. Post a sample not the whole book!

    Post a sample not the whole book!
  4. Hi rich_cirillo The COUNTA returns the ...

    Hi rich_cirillo

    The COUNTA returns the returns the number of cells that are not empty. Then returning that to the OFFSET function for the Height.

    See the link on the OFFSET function.

    Kevin
  5. Hi rich_cirillo You could use data validation....

    Hi rich_cirillo

    You could use data validation. Create a list in your sheet say in column V, in V1 & copy down:
    =TODAY()+21*ROW()-21

    Data Validation:
    =OFFSET($V$1,0,0,COUNTA($V:$V),1)
  6. Replies
    4
    Views
    1,504

    Hi Stalker The INDEX & MATCH will achieve this...

    Hi Stalker

    The INDEX & MATCH will achieve this for you.

    =INDEX($B$3:$I$3,MATCH(LARGE(B3:I3,1),B3:I3,0)-1)
  7. Replies
    2
    Views
    1,627

    Hi leopaulc The first thing is to convert all...

    Hi leopaulc

    The first thing is to convert all the text numbers to real numbers. Select a blank cell, copy > Select the data C2:AD27 > Paste Special > Tick the Add > Click OK > format cells as...
  8. Hi Orestees May be using the IF & LOOKUP, see...

    Hi Orestees

    May be using the IF & LOOKUP, see the attached file. You need to stay clear of merging cells, they are the work of the devil!
  9. Hi Ryan_Bernal Another solution for the...

    Hi Ryan_Bernal

    Another solution for the formatting might be.
    Rule 1 Green: =COLUMNS($E$3:E3)<=$B$3
    Rule 2 Red: =AND(E$3<>"",COLUMNS($E$3:E3)>$B$3)

    Kevin
  10. Replies
    8
    Views
    2,285

    Hi Or another version: ...

    Hi

    Or another version:
    =SUMIF(C5:C15,J20,D5:D15)+SUMIF(C5:C15,J21,D5:D15)

    Kevin
  11. Hi mag Not quite sure what you mean. See the...

    Hi mag

    Not quite sure what you mean. See the attached, is this what you mean or something along those lines!

    Kevin
  12. Hi mag See the attached file.

    Hi mag

    See the attached file.
  13. Replies
    2
    Views
    19,831

    Hi Excel Fox Thank you for that.

    Hi Excel Fox

    Thank you for that.
  14. Replies
    2
    Views
    19,831

    Smiley's

    Hi with reference to this post http://www.excelfox.com/forum/f2/less-than-greater-than-equal-concatenate-cell-value-form-if-formula-714/. Regarding the smiley's.
    I would also like to know how to...
  15. Hi Howardc Could you not record a macro for...

    Hi Howardc

    Could you not record a macro for something like that.

    Kevin
  16. Hi My first post! Another version for a...

    Hi

    My first post!

    Another version for a formula approach in B2:

    =SUM(OFFSET($B2,0,1,1,LOOKUP(2,1/$C2:$T2,$C2:$T2))) and copy down.

    Also accounts for cells not filled in continuously.
Results 1 to 16 of 16