Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Copy range of cells to other sheet

    assume we have this setup in sheet1:

    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color:...
  2. Replies
    7
    Views
    318

    Re: Countif

    another solution would be using the CHOOSE Function.

    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse;...
  3. Replies
    7
    Views
    318

    Re: Countif

    another solution:

    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col...
  4. Re: Removing Duplicate Dates Keeping Column With Name

    the VBA solution would be:


    Option Explicit

    Sub removedubs()


    Dim Rng As Range: Set Rng = Sheet2.Range("b3:c12")
  5. Re: Removing Duplicate Dates Keeping Column With Name

    I have a formula solution however it is not the best in term of performance as this formula is known to slow the processing speed on your workbook:

    <b>Excel 2010</b><table cellpadding="2.5px"...
  6. Re: Associate a picture with a random number

    bro

    i already have posted additional stuff last week at your original thread where you requested that.

    i showed in length how can you associate the pics with the random number generated by the...
  7. Re: Macro to randomly choose numbers

    Slot1=OFFSET(Sheet2!$B$2,Sheet1!$C$7-1,1)
    Slot2=OFFSET(Sheet2!$B$2,Sheet1!$D$7-1,1)
    Slot3=OFFSET(Sheet2!$B$2,Sheet1!$E$7-1,1)
    Slot4=OFFSET(Sheet2!$B$2,Sheet1!$F$7-1,1)...
  8. Re: Macro to randomly choose numbers

    I think Howard is right.

    this is do-able with formulas; i tried expanding the macro i gave you copy paste images into positions based on the random number generated but i failed.

    the formula...
  9. Re: Macro to randomly choose numbers

    you know what ?

    i guess i can do it; maybe. so stay tuned for an update.

    well, if two days passed and you did not see any update; know that my brain went into freeze mode. only by then, open a...
  10. Re: Macro to randomly choose numbers

    that is interesting.

    but i am still a noob that is beyond my skills

    i guess you will have to wait for the geeks, scientists, nerds , Excel gods to visit your thread and shows us how this can be...
  11. Re: Macro to randomly choose numbers

    bro there was some error in my previous code :stickouttounge:

    i fixed it

    check it again please


    Sub randomgen()

    Range(Range("c7"), Range("c7").End(xlToRight)).Clear
  12. Re: Macro to randomly choose numbers

    another take with macros on the same sheet structure i presented above:


    Sub randomgen()

    Range(Range("c7"), Range("c7").End(xlToRight)).Clear


    Dim F As Integer: F = Range("d2").Value
    Dim...
  13. Re: Macro to randomly choose numbers

    without a macro i guess this works :

    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color:...
  14. Re: Return Distinct Value based on Criteria in two other columns

    Dr. Aladin

    Your solution as always very fascinating for newbies like me :) took me an hour to crunch it.

    one thing i still cannot comprehended is this:



    when i analyze it in Evaluate...
  15. Re: add number to the middle of an existing number

    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px"...
  16. Re: Need VBA to eliminate specific characters in cells

    Sub REMOVESTUFF()

    Dim tempstring As String
    For Each cell In Sheets("sheet1").UsedRange

    tempstring = cell.Value
    If Left(cell, 1) = ":" Or Left(cell, 1) = " " Or Left(cell, 1) = 0...
  17. Re: Conditional formatting on specifica date ranges

    rule 1: highlight with yellow


    =AND((D$3-TODAY())<=28,(D$3-TODAY())>=0)

    https://cdn.pbrd.co/images/2w7v02u0.png


    rule 2 : - i did not understand it
  18. Re: Find the Last Row and Column with contents

    if this is my sheet content:

    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color:...
  19. Replies
    11
    Views
    462

    Re: formula help

    why the "--" ? can you explain why we need the numeric conversion here ?

    thanks
  20. Replies
    11
    Views
    462

    Re: formula help

    hi .

    is this shorter ? seems to work with me: (FRI - SAT = OFFDAYS)

    @ E7

    =SUMPRODUCT((WEEKDAY(E3:T3)<6)*(E4:T4="SICK"))


    <b>Excel 2010</b><table cellpadding="2.5px" rules="all"...
  21. Re: Unsure how to set up Data validation, dependent on value from list

    data validation is set on E3
  22. Re: Unsure how to set up Data validation, dependent on value from list

    dunno i cant understand your problem; can you formulate it on a sheet with the expected behavior and paste here using Mr.Excel HTML maker?

    what i understood looks quiet simple and straight...
  23. Replies
    9
    Views
    1,225

    Re: Thank You to the Regulars

    yup the forum is really helping a lot of people, and fresh daily with questions and challenges.

    i wish if there is some kind of a compensation and retention mechanism for the effort of the guys...
  24. Re: Selecting items only once in a list until that item is returned.

    Ahaa

    I am not copying and pasting with paste special, am just copying and pasting normally that explains it.

    I will try the paste special with validation.
  25. Re: Selecting items only once in a list until that item is returned.

    I really liked your solution peter :biggrin: especially that it avoids VBA which is a real plus.

    I wish you think about distilling your strategies and thinking model into a book or some organized...
Results 1 to 25 of 139
Page 1 of 6 1 2 3 4