Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Select only numeric values in a column

  1. #1
    Join Date
    15th August 2012
    Posts
    3

    Select only numeric values in a column

    Hi guys, noobie here... I am stuck and would love some input!

    What I have is a column that has several rows of string data, followed by rows of numeric data. The number of rows of numeric and string data may vary from sheet to sheet so I need to be able to find where the string data starts/ends and where the numeric data starts/ends. Any ideas?

    <something along the lines of>

    VB:
    Dim FirstNumeric, i As Integer 
    i = 0 
    For i = i + 1 
        If A_i = String 
        Then Next 
        If A_i = Integer 'or long, whichever works better
        Then A_i = FirstNumeric 'exit loop somehow
        End 
         
         'Then take that data and use the first numeric entry in a range and copy it to a new sheet
         
        Range(Range("FirstNumeric").End(xlToRight), Range("A9999").End(xlUp)).Select 
        Selection.Copy 
        Sheets("New_Sheet").Select 
        Range("A1").Select 
        ActiveSheet.Paste 
        Sheets("Original_Sheet").Select 
    
    
    Sorry everything is so messy <total noob>

    Thank you so much for your help.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    29th February 2008
    Posts
    5

    Re: Select only numeric values in a column

    Hey, try the IsNumeric function

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    15th August 2012
    Posts
    3

    Re: Select only numeric values in a column

    Thanks! I'll give it a shot

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 6
    Last Post: May 3rd, 2011, 00:26
  2. Randomly select remaining values from alpha-numeric set
    By rakuen in forum Excel and/or SQL Help
    Replies: 1
    Last Post: October 20th, 2010, 16:20
  3. Replies: 6
    Last Post: October 14th, 2005, 09:27
  4. Select range w/ values in a column
    By jasongrr in forum EXCEL HELP
    Replies: 4
    Last Post: March 24th, 2005, 02:07
  5. Replies: 13
    Last Post: July 14th, 2004, 04:38

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
  •  
porno