1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL.MI

  • Re: Autofilter to filter out non-numeric rows

    From Parag Agrawal@21:1/5 to All on Sun Jan 15 19:00:49 2023
    On Thursday, February 7, 2008 at 6:39:45 PM UTC+5:30, ashish128 wrote:
    Hi all,
    Greetings,
    Could you please tell me if it is possible to filter out a range by
    removing/ filtering that rows in which the cell value is a text and
    not number.
    Say,
    1. Autofilter on Range A1 to C10
    2. Select Criteria on Column A (Cell A1) to show only those rows which contain numbers.
    I tried Autofilter but there was no such option (Select only Numbers).
    Please help.
    Regards
    Ashish Sharma


    =FILTER(A1:C10,ISERROR(VALUE(A1:A)))

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Bayram Can@21:1/5 to All on Sun Jan 22 09:22:24 2023
    Bayan escortlar ile görüşmek için ey iyi site olan Denizli escort sitesinin adresini buradan veriyoruz.
    Site: https://www.aradene.com

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)