Problem with MAX value and associated cells

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

Guest

I want to search a column of data (D2:D86) and have the search show not that
value but the text in the adjacent C cell. The only what that i can think to
do this is have a if loop that searches each cell to see if it is the max, if
it is it shows the adjacent cell text, if not then it checks the next cell,
but the column has 85 values and will grow, i dont want a cell that has a
function that long. Any suggestions?????


Please Help

Ryan
 
sounds like you're working in Excel. suggest you post your question in an
Excel newsgroup. this newsgroup is devoted to MS Access relational database
software.
 
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

Max Value Problem 4
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
Pick List Problem 1
Excel Concatenate with line breaks but ignore blank cells 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
change certain cell colours in VBA 2
Excel JUMP FROM SEARCH BAR TO RESULT 3

Back
Top