+ Reply to Thread
Results 1 to 3 of 3

Show if a row is today

  1. #1
    Registered User
    Join Date
    11-26-2018
    Location
    Toronto, Canada
    MS-Off Ver
    2016
    Posts
    3

    Show if a row is today

    Hello,

    I have a table of transactions based on date. So for example it has the date, price paid, supplier, etc....

    I would like to create a new tab which only shows the transactions from today as a summary, with the transactions for today at the top.

    I tried to do IF(A11:A1000=TODAY(),B11:B1000,"")......but the problem is that the transactions from today are not at the top, they are in the middle of the page.

    Any ideas?

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Show if a row is today

    Maybe
    =IFERROR(INDEX($B$11:$B$1000,SMALL(IF($A$11:$A$1000=TODAY(),ROW($A$11:$A$1000)-ROW(A$10)),ROW(B1))),"")

    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

  3. #3
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: Show if a row is today

    You can use the AGGREGATE () function:

    =IFERROR(INDEX($B:$B,AGGREGATE(15,6,ROW($A$11:$A$1000)/($A$11:$A$1000=TODAY()),ROWS($E$1:$E1))),"")

+ 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. show today production with adding last previouses
    By akshay6s in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-07-2018, 06:59 AM
  2. [SOLVED] to show previous year from now today function
    By Shamz41 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-01-2018, 03:43 PM
  3. Macro to show day of the today
    By graiggoriz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-21-2014, 04:59 AM
  4. [SOLVED] Show today's date on calendar
    By Marco-Kun in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-26-2012, 04:23 PM
  5. Show today's date if specified cell is modified
    By xavpg in forum Excel General
    Replies: 7
    Last Post: 02-28-2012, 07:16 PM
  6. Replies: 3
    Last Post: 11-19-2009, 10:00 AM
  7. Show today() average
    By albynas in forum Excel General
    Replies: 3
    Last Post: 05-27-2009, 05:12 PM

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