Results 1 to 6 of 6

Returning totals in a series of tables

Threaded View

Nick_in_Dubai Returning totals in a series... 12-29-2008, 07:33 AM
DonkeyOte see attached example (non VBA... 12-29-2008, 08:00 AM
DonkeyOte Nick, previous file had... 12-29-2008, 08:22 AM
Nick_in_Dubai Formula breakdown 12-29-2008, 08:30 AM
DonkeyOte The first: ... 12-29-2008, 09:00 AM
Nick_in_Dubai Thanks so much for that,... 12-30-2008, 12:27 AM
  1. #1
    Registered User
    Join Date
    11-16-2008
    Location
    Dubai
    Posts
    73

    Returning totals in a series of tables

    Happy Xmas All..........

    I have a data dump which is a series of tables, the layout and headers of the tables are fairly fixed however the number of rows in each table is constantly changing. What i would like to do is return the table header, and the average turnaround for each table, preferably without amending the tables. Attached is a sample, these tables marked task C1 task C2 etc are the table headers and in the cell next to Average turnaround is the value i would like to return. I would also like to return the bottom value of each table in column C so at the end it should look like:

    Task C1 434 2.52
    Task C2 16 3.00
    Task C3 10 2.20
    Task C4 329 3.24

    I do not want to amend or adjust the table as this sheet continues on for 3000 more tables, which is the reason i am looking for a VB lookup type function.

    Sheet Attached..

    Really appreciate any help or guidence i can get.

    Thanks Everyone

    Nick
    Attached Files Attached Files
    Last edited by Nick_in_Dubai; 12-30-2008 at 12:27 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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