+ Reply to Thread
Results 1 to 4 of 4

I want to filter the data basing on the cell value.

  1. #1
    Registered User
    Join Date
    06-12-2021
    Location
    INDIA
    MS-Off Ver
    Microsoft 365
    Posts
    8

    I want to filter the data basing on the cell value.

    Good Morning every one.

    This is my first question in the forum. Please excuse me if i did anything wrong

    I am new to Microsoft 365.

    I want to filter the data basing on the cell value. where i will type >90.12%, <89% likewise. Then the FILTERED data should be extracted.

    Example
    =FILTER($B$7:$F$80,$E$7:$E$80,$A$1)

    When I put >90.12% or <89% so on in A1 cell I want to get the FILTERED data basing on the value in AC1 cell. I am unable to put < or > in the A1 cell.
    But I am getting data if i hardcode < or > in my formula

    like this one
    =FILTER($B$7:$F$80,$E$7:$E$80<A1).

    I hope i will get early reply. Thank you.

  2. #2
    Registered User
    Join Date
    11-13-2018
    Location
    Istanbul
    MS-Off Ver
    Microsoft 365
    Posts
    91

    Re: I want to filter the data basing on the cell value.

    Hello

    Please try

    =FILTER($B$7:$F$80,IF($E$7:$E$80<$A$1,0,$E$7:$E$80))

    This should give you the filtered data based on "smaller" than the value at A1. To get "larger", you might need to edit formula to change "<" into ">", or include another IF. You will need a helper cell for that.

    Assuming you don't have any data at B1 (if you do, you can change it to any other empty cell that is convenient for you)

    =FILTER($B$7:$F$80,IF(IF($B$1="LARGER",$E$7:$E$80>=$A$1,$E$7:$E$80<$A$1),0,$E$7:$E$80))

    This will filter your data based on the "smaller" than the value you will put to A1. But if you type LARGER to B1, it will filter the larger data.

  3. #3
    Registered User
    Join Date
    06-12-2021
    Location
    INDIA
    MS-Off Ver
    Microsoft 365
    Posts
    8

    Re: I want to filter the data basing on the cell value.

    Sir, Good Morning. My real problem is I DONT WANT TO HARDCODE . Please download the attachment Sir.

    Attachment 736467
    Attachment 736467

  4. #4
    Registered User
    Join Date
    11-13-2018
    Location
    Istanbul
    MS-Off Ver
    Microsoft 365
    Posts
    91

    Re: I want to filter the data basing on the cell value.

    Hello Abdul.

    The links aren't working. There are instructions at the top of the page (yellow banners) for how to post a sample file.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how to match filter a sheet basing on a column content?
    By woshichuanqilz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-30-2018, 09:22 PM
  2. Changing the data range basing cell value
    By mahe1188 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-08-2016, 07:33 AM
  3. Basing one cell off first 3 digits of another
    By Mattpg89 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-10-2016, 01:01 PM
  4. Basing one cell off first 3 digits of another
    By Mattpg89 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-10-2016, 11:32 AM
  5. restrict data entry basing on adjacent cell value
    By tkraju in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2014, 01:45 PM
  6. conditional formatting basing on cell above
    By Bishonen in forum Excel General
    Replies: 1
    Last Post: 12-12-2012, 08:13 AM
  7. Auto Formula basing on cell changes
    By jensenleesen in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-23-2009, 02:51 AM

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