Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel help please

  • 26-01-2012 9:37am
    #1
    hamsterboy
    Registered Users, Registered Users 2 Posts: 1,536 ✭✭✭


    Hi All
    I have an Excel sheet with a column of numbers in column A.
    I need to remove any rows that contain a certain value.
    Is there an easy formula to do this... don't wanna go mucking about with macros

    Cheers

    HB


Comments

  • #2
    ANXIOUS
    Registered Users, Registered Users 2 Posts: 3,095 ✭✭✭ANXIOUS


    WOuld control f help, then filter rows with out a value and delete them in one go?


  • #3
    beazee
    Registered Users, Registered Users 2 Posts: 1,343 ✭✭✭beazee


    Ctrl+H (Find & Replace)
    Find: <enter "certain value">
    Replace: <leave blank>
    Press OK to all


  • #4
    hamsterboy
    Registered Users, Registered Users 2 Posts: 1,536 ✭✭✭hamsterboy


    beazee wrote: »
    Ctrl+H (Find & Replace)
    Find: <enter "certain value">
    Replace: <leave blank>
    Press OK to all

    Actually that will not delete the row, only the contents of the cell.
    Found a way though. Filters!!
    Stripped out the unwanted data with filter.... copy and paste... Simples

    HB


Advertisement