Results 1 to 2 of 2

Removing Blank values from a column

Threaded View

PaulWalkden Removing Blank values from a... 06-01-2010, 05:04 AM
NBVC Re: Removing Blank values... 06-01-2010, 08:36 AM
  1. 06-01-2010, 05:04 AM #1
    PaulWalkden is offline
    Registered User
    Join Date
    06-01-2010
    Location
    Manchester
    MS-Off Ver
    Excel 2003
    Posts
    1

    Removing Blank values from a column

    I know this is probably rididiuclously simple but I cnat find out how to do it, I have a column which has some fields populated, calculated by a formula (time in dnd is calculated by the time they Logged in minus the time went in Busy N/A). for example

    Agent Status
    Hunt Group
    Time in DND
    Logged in
    2027
    Busy N/A
    00:00
    Logged in
    2445
    Busy N/A
    00:00
    Logged in
    2444
    Busy N/A
    00:04
    Logged in
    2888
    Busy N/A
    00:00
    Free
    Busy (Call)
    Free

    What I wnat to do is, through a formula have a fourth column which returns everything in the third column, in the order they are shown but with no blanks. It has to be totally automated upon new data being put into the sheet on a daily basis. Literally no one has to click anything at all.

    Can anyone help?

    also no VBA as employees are not allowed to enable macros on there PC's
    Last edited by PaulWalkden; 06-01-2010 at 05:09 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1