Results 1 to 5 of 5

generate value in top row and left column of a table, based on pos. seachcell in table

Threaded View

  1. 03-13-2018, 07:09 AM #1
    sansara
    sansara is offline
    Registered User
    Join Date
    04-12-2016
    Location
    rotterdam
    MS-Off Ver
    windows 7 office 2013
    Posts
    3

    generate value in top row and left column of a table, based on pos. seachcell in table

    hi all, i'm looking for a formula that generates the value in the top row and left column of a table, based on the position of the input cell in that table. I've attached an example to make it a bit more clear what i'm looking for.
    Thanks!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Clear column based on other column in a table and re-sort table
    By shivers in forum Excel General
    Replies: 0
    Last Post: 08-18-2017, 03:03 PM
  2. Generate table based on table in another sheet
    By bakdus94 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-21-2016, 12:14 PM
  3. Selecting highest date value from table column based on the value of a cell in the table
    By bigguspig in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-16-2015, 04:54 PM
  4. Generate a Table based on several conditions
    By steven340 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-09-2015, 08:44 PM
  5. [SOLVED] Do a vlookup based on left 6 numbers in the table
    By kafarrell in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 07-30-2014, 01:57 PM
  6. Need Formula to return the column heading in a table based on a value located in the table
    By gfalcone1 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-25-2013, 05:17 PM
  7. [SOLVED] Excel 2007 : Filling a table with conditional formatting based on the value of the cell to the left
    By dip11 in forum Excel General
    Replies: 5
    Last Post: 05-11-2012, 06:40 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1