• 0

Excel formula help


Question

Hi all

I need a little help with a formula in ms excel.

Basically I have a table with 2 columns, in the left column is a list of names, the right column is a list of times, each column corresponds to the next one, ie, cell A1 is the name and B1 is the time.

The times in this table gets manually updated.

Next I have another table, the left column has the name again and the right column has the time. But this time the time column has a formula in which looks at the first tables times and it lists the top 3 times, on 3 different rows, it works fine as when I update the times in the first table, they change in the 2nd table depending on which time is the lowest.

The problem I am having is the name on the 2nd table needs to update automatically with the times when they change.

Can anyone shed any light?

I've tried playing round with vlookup but can't seem to get anywhere.

Cheers, Jason

Link to comment
https://www.neowin.net/forum/topic/1179357-excel-formula-help/
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

  • Recent Achievements

    • Dedicated
      EYEREX earned a badge
      Dedicated
    • First Post
      Electronic Person earned a badge
      First Post
    • Week One Done
      CyberCeps666 earned a badge
      Week One Done
    • Very Popular
      d4l3d earned a badge
      Very Popular
    • Dedicated
      Stephen Leibowitz earned a badge
      Dedicated
  • Popular Contributors

    1. 1
      +primortal
      609
    2. 2
      ATLien_0
      227
    3. 3
      Xenon
      163
    4. 4
      neufuse
      134
    5. 5
      +FloatingFatMan
      121
  • Tell a friend

    Love Neowin? Tell a friend!