Results 1 to 20 of 20

macro to create pivot table(s) and sort out data in other worksheet

Threaded View

  1. #7
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: macro to create pivot table(s) and sort out data in other worksheet

    I've attempted something but haven't come up with the same averages as you, which may mean I haven't fully understood.

    In the first sheet of the attachment I've added a formula in cols M-O (for each of the sectors) which puts a 1 for the first lap of each driver and also if any lap time is more than 1.2 times the previous one.

    I've then amended the array formula in the code to exclude any 1s in those columns.

    Where have I gone wrong?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1