How do I have a data table display cell names rather than values?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to run some sensitivity analysis on an aggrregate score from a
listing of rankings. The rankings are a product of the rankings in different
attributes and two attributes also have a beta integrated into them. My goal
is to run a sensitivity analysis using a data table. Currently i have a
conditional statement if(max(A3:A66)=A3, "Chicago",
if(max(A3:A66)=A4,"Cincinnati" and so on. Unfortunately I can only do that 12
times, meaning some cells in my 11x11 data table are left blank because I can
not cover them in those tweleve names. The other option I have tried is a
simple MAX function but it only returns values. My question is how do get the
data table to record the name of the cell instead of the value?
 
Put the City names into cells B3:B66 then use

=vlookup(max(a3:a66),A3:B66,2,FALSE)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set non-continuous PrintArea via Function / Name 0
Using two Vlookup in one Cell 1
About Data Validation 2
VBA - retrieve data on last create named range from previous inserted named range 0
How to assign values to a cell based on values in another cell? 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How can I do a lookup to a specific cell on another tab 1
Unique value list 3

Back
Top