Results 1 to 8 of 8

Offset formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-01-2012
    Location
    rotterdam, holland
    MS-Off Ver
    Excel 2013
    Posts
    170

    Offset formula

    I want to have in A1395 the data for ' Cyril ' and when I choose for ' Ronald' with the combobox I want the data for him in A1395 with his data in this row (and going down all to 31/12/2013 for just this employee, chose in the combobox, beginning from the top A1395.). Point is, I have 3 employees, so how do I use Offset? I made a start in A1395, Total rows is 365 per employee so I'd guess 365 + 365 = 730, just no idea how to put this in a formula. Thanks a lot!

    65.xlsm
    Last edited by IKZOUHETNIETWETEN; 03-02-2013 at 07:55 PM.

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