+ Reply to Thread
Results 1 to 2 of 2

I need to delete rows with decimals

Hybrid View

  1. #1
    Registered User
    Join Date
    12-17-2012
    Location
    Vancouver, BC
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question I need to delete rows with decimals

    Hi all. I am having a probelm. I have created a worksheet to figure out (in this case) how many sets of Buckyballs i need in order to get both a square number and a cube number. There are 216 balls per set. My worksheet so far has:

    Sets Number of balls Square Cube
    (Number of sets) (Sets*216) (Number of balls ^0.5) (Number of balls ^(1/3))

    The problem is that I am looking for the number of sets required to produce an integer in both Square and Cube columns. I have figured out that I can circle all values that are not integers. I am looking for a way to delete all rows with a decimal value or at least all cells with a decimal value and I can delete the rows from there.

    Thank you in advance.

    PS. I know that the first answer is 216, but I am looking for the ones after that. So there are 100,000 lines so far. Meaning I want to have the process as automated as possable. Thank you again.

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: I need to delete rows with decimals

    I assume you have the 10000 rows already created and now you just want to search for the two intergers.

    Assuming your 'Square' cells are in column C starting in row 2 and your 'Cube' cells are in column D...

    Click on cell A1 (this should be your header of 'Number of sets')
    Hit Ctrl-T to make a table
    In cell E1, make a header called Tester (this should add a new column to the table)
    In cell E2, use this equation:
    =and(int(C2)=C2,int(D2)=D2)

    That equation should auto-fill down every row in the table.

    Now click on the drop down arrow in the Tester header and remove the checkmark by FALSE.

    Should be a list of your answers
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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