Results 1 to 7 of 7

Returning a Value from a table based on the last non zero entry in the table

Threaded View

  1. #3
    Registered User
    Join Date
    03-05-2013
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Returning a Value from a table based on the last non zero entry in the table

    Hi thanks for the quick reply! I have tried to adapt that formula but keep receiving error. Maybe it'll help if you can see the table i wish to able it to. I have posted the spreadsheet. The table i am referring to is the big two way table to the right. The red cell is where i wish for the value to be appear. I aim to check the biggest value in the last row of the table (row 112) and according to the biggest value, i would like the corresponding column title to be entered in the cell. thanks again!
    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. [SOLVED] Sort pivot table based on first column entry
    By Derek Cavanagh in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-20-2013, 12:01 AM
  2. Replies: 1
    Last Post: 07-31-2013, 04:11 PM
  3. Returning data in one table based on the values from another table
    By excelignorant in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-24-2013, 04:12 AM
  4. Returning an entry from a table based on the current date
    By jshaw82 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-14-2012, 12:37 PM
  5. Auto entry based on table
    By xlchallenged1 in forum Excel General
    Replies: 2
    Last Post: 09-17-2008, 01:44 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