Search:

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

Search: Search took 0.00 seconds.

  1. Re: Apply formula to cells without relative cell referencing in VBA

    It’s not possible to lock cells with “$” on VBA.
  2. Apply formula to cells without relative cell referencing in VBA

    Hi,

    How do I prevent relative cell referencing with this formula?


    Dim LastRow As Long

    LastRow = Worksheets("data").Cells(Rows.Count, "I").End(xlUp).Row
  3. Replies
    3
    Views
    203

    Re: Calculate Median from Frequency Table

    That is calculating median from a range. My question is asking about calculating median from a frequency table, NOT a string.
  4. Re: Having the same date Format set for all cell with date even if typed differently

    Hello!

    you can create additional columns and then create a formula:
    =TEXT(your_cell_with_date_here,"DD/MM/YYYY").

    Hope this helps!
  5. Replies
    3
    Views
    203

    Calculate Median from Frequency Table

    Hello, does anyone know of a formula to calculate the median from this frequency table? (assuming the list goes on, way beyond row 10)


    <colgroup><col><col></colgroup><tbody>
    number
    frequencies...
  6. Change activesheet name and sheets added dynamically

    How do I create a code for changing my ActiveSheet to a name and subsequent added sheets with name +1 ?

    E.g. WS1, WS2, WS3
  7. Re: Run a VBA code to remove blank cells and return first non-blank cell with multiple criterias

    Thank you Micki! This worked perfectly! :)
  8. Run a VBA code to remove blank cells and return first non-blank cell with multiple criterias

    Hi, I require a VBA code to help me remove blank cells across different column labels to reflect the first non-blank cell in each column across unique row labels.

    This:
    ...
  9. Run a VBA code to remove blank cells and return first non-blank cell with multiple criterias

    Hi everyone,

    This is the sample text.
    What I require is to remove all the blank cells and lookup the first non-blank cell value as each category for each Name has ONLY one unique value.

    So...
Results 1 to 9 of 9