Results 1 to 9 of 9

Average + vlookup?

Threaded View

  1. 06-21-2011, 04:16 PM #1
    ABSTRAKTUS
    ABSTRAKTUS is offline
    Forum Contributor ABSTRAKTUS's Avatar
    Join Date
    04-18-2010
    Location
    England
    MS-Off Ver
    Win10 Excel 2016
    Posts
    609

    Average + vlookup?

    Hi gurus!

    After searching on net I found some ugly formulas to average numbers (excluding blanks and zeros) combined with VLOOKUP. Actually my needs are bit complicated as I have 3 criteria to be looked at:
    • Product
    • Date
    • Average last seven days from today

    Is it possible at all? I am sure someone will come up with bright ideas. See dummy...

    Thanks a ton guys!
    Attached Files Attached Files
    Last edited by ABSTRAKTUS; 06-21-2011 at 05:07 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1