| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Creating a list from Table Data
I have a table of Row = "Invested $" (ie. 10%, 20%...,50%) vs. Column =
"Priority" (ie. 1,2,...,5). The values are scores and I have a "given value". I want to create a list or table that shows the Row title (10%) and Column title (1) for all the values in the table that are greater than the "given value". I've been trying different ways with INDEX, VLOOKUP and other functions with no luck yet. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| I am having problems creating pivot table of data | Charts and Charting in Excel | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
| Data Table - does it work with DDE links and Stock Tickers? | Excel Worksheet Functions | |||
| Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) | |||
Threaded Mode
