Results 1 to 12 of 12

How to extract specific hourly rows based on the maximum daily value in a column

Threaded View

  1. #1
    Registered User
    Join Date
    03-21-2020
    Location
    Italy
    MS-Off Ver
    2016
    Posts
    5

    How to extract specific hourly rows based on the maximum daily value in a column

    Hi,
    Very often I have to face a similar scenario described below:
    a table with days and hours and then all the values in the next columns from which I need to extract only some rows... precisely, those ones with the maximum value in a column. In other words, the outcome is composed of one row per day that represent the hour with the maximum value of a specific column... and of course that selected row has all the corresponding values for that hour.

    I found a way to cope this scenario but I have to implement two pivot tables and a couple of functions (CONCATENATE and VLOOKUP). I am curious to know how you resolve this problem and if someone of you has a smarter or faster or easiers solution to resolve that scenario. I attach the Excel file with my solution and some comments as well.

    Thank you for your attention.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extract rows to another sheet based on specific words + auto updates
    By scooter2012 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-13-2022, 09:17 PM
  2. [SOLVED] Extract specific numbers in a column and do various summations based on their position
    By lamlam28 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-13-2019, 09:35 AM
  3. Replies: 4
    Last Post: 11-19-2019, 01:13 AM
  4. Extract specific rows based on cell
    By ili_Sophia in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-10-2018, 05:52 AM
  5. Replies: 3
    Last Post: 05-11-2016, 04:04 PM
  6. [SOLVED] Find Daily Maximum from Hourly Data
    By computing in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-25-2013, 02:29 PM
  7. Extract rows with specific text in a column
    By TroyB in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-25-2005, 01:06 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