+ Reply to Thread
Results 1 to 2 of 2

Table that calculates F2 from all filled cells but not empty cells.

  1. #1
    Registered User
    Join Date
    11-10-2015
    Location
    Baltimore, MD
    MS-Off Ver
    2010
    Posts
    5

    Smile Table that calculates F2 from all filled cells but not empty cells.

    Hello!
    I'll try my best to describe my issue.
    My boss told me to create Excell Spreadshit that calculates statistics (F2, rsd, etc.) from filled cells but not empty ones.
    E.g. you can enter any amount of data but calculation will use only cells with info.
    If you use simple formula, you have to specify range to be used. I want to eliminate this so range is infinite but empty spaces are not counted.

    Do you recommend to stop macro at last filled cell or before first empty cell? And how to make it calculate stuff from those filled cells?

    Please, help, I'm new to VBA

    Thank you

  2. #2
    Registered User
    Join Date
    11-10-2015
    Location
    Baltimore, MD
    MS-Off Ver
    2010
    Posts
    5

    Re: Table that calculates F2 from all filled cells but not empty cells.

    One more thing, I'd like it to use only cells with numbers and not words so I can label the column without problems.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Find count of filled cells and empty cells in a column
    By thepinkgeologist in forum Excel General
    Replies: 4
    Last Post: 09-22-2015, 01:03 PM
  2. Count filled and empty cells from the first filled cell in a row
    By mdaoust in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-01-2014, 01:23 PM
  3. Need to find empty filled cells in a column and copy to the empty cell below
    By Grahamfeeley in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-30-2014, 10:09 AM
  4. [SOLVED] How to merge empty with filled cells without deleting?
    By kingi in forum Excel General
    Replies: 2
    Last Post: 09-27-2013, 03:20 AM
  5. Empty Cells needed to be filled using formula
    By ericohansen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-06-2013, 05:15 PM
  6. display filled vs empty cells in a range
    By dr mint in forum Excel General
    Replies: 6
    Last Post: 08-04-2009, 10:38 PM
  7. a formula which calculates empty cells
    By jeff lebowski in forum Excel General
    Replies: 1
    Last Post: 07-14-2006, 07:35 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1