+ Reply to Thread
Results 1 to 67 of 67

LOOKUP and Filter Based on Combined Condition

Hybrid View

  1. #1
    Registered User
    Join Date
    12-10-2019
    Location
    Delhi, India
    MS-Off Ver
    2016
    Posts
    34

    Re: LOOKUP and Filter Based on Combined Condition

    Hi,

    I'm facing following issues in attached sheets. could any one help.

    there is some error in these sheet. i couldnt able correct it. raw data has data of 1st nov to 5th nov. following things need to be correct

    1. when i enter date in A2, same Lin. reg.equation is coming in b3, b4, b5, b6 . this need to correct. that is b3, b4, b5, b6 should has equation of 2nd nov, 3rd nov, 4th nov, 5th nov.
    2. lin.reg day 2, Lin reg day 3, Lin reg day 4, Lin reg day 5 is not filtering data when i enter respective date(2-nov-19, 3-nov-19, 4-nov-19, 5-nov-19) in a3, a4, a5, a6.

    Thanks for support
    Attached Files Attached Files

+ 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. [SOLVED] How to highlight or filter values in a table based on another condition
    By stevemalekano in forum Excel General
    Replies: 3
    Last Post: 05-31-2018, 04:39 AM
  2. [SOLVED] Lookup based on certain condition
    By jw01 in forum Excel General
    Replies: 5
    Last Post: 05-30-2018, 02:00 PM
  3. [SOLVED] Filter and Copy Visible cells based on condition
    By kittu55 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-06-2017, 09:31 PM
  4. Filter down spreadsheet into another sheet based on a condition
    By tyson187 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-23-2015, 08:06 AM
  5. [SOLVED] VBA to Lookup value based on two condition.
    By shiva_reshs in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-03-2014, 12:30 PM
  6. [SOLVED] Filter based on multiple or condition
    By mangesh in forum Excel General
    Replies: 5
    Last Post: 11-06-2013, 03:30 AM
  7. Replies: 13
    Last Post: 05-31-2006, 04:30 AM

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