+ Reply to Thread
Results 1 to 11 of 11

AVERAGE - Multiple VLOOKUPs whilst ignoring zeros or blanks

Hybrid View

Jake_1 AVERAGE - Multiple VLOOKUPs... 01-20-2020, 06:19 AM
shank_mis Re: AVERAGE - Multiple... 01-20-2020, 06:43 AM
davsth Re: AVERAGE - Multiple... 01-20-2020, 06:44 AM
MY0987 Re: AVERAGE - Multiple... 01-20-2020, 07:07 AM
Jake_1 Re: AVERAGE - Multiple... 01-20-2020, 07:55 AM
MY0987 Re: AVERAGE - Multiple... 01-20-2020, 08:12 AM
Jake_1 Re: AVERAGE - Multiple... 01-20-2020, 09:39 AM
MY0987 Re: AVERAGE - Multiple... 01-20-2020, 10:29 AM
Jake_1 Re: AVERAGE - Multiple... 01-20-2020, 11:20 AM
MY0987 Re: AVERAGE - Multiple... 01-20-2020, 12:06 PM
Jake_1 Re: AVERAGE - Multiple... 01-20-2020, 01:00 PM
  1. 01-20-2020, 08:12 AM #1
    MY0987 is offline
    Registered User
    Join Date
    01-15-2020
    Location
    Bangalore
    MS-Off Ver
    2016
    Posts
    21

    Re: AVERAGE - Multiple VLOOKUPs whilst ignoring zeros or blanks

    Capture.JPG

    Not sure what are you referring to, here I am getting values for Agent6, Agent13 and Agent16 are NA
    Reply With QuoteRegister To Reply
  2. 01-20-2020, 09:39 AM #2
    Jake_1 is offline
    Registered User
    Join Date
    09-16-2017
    Location
    England
    MS-Off Ver
    2016
    Posts
    43

    Re: AVERAGE - Multiple VLOOKUPs whilst ignoring zeros or blanks

    So I've attached what I'm currently looking at.

    Agents 18,19, and 26 shouldn't be showing as NA as they have call data from one of the days. See what I mean?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need to average data excluding blanks that matches 2 vlookups.
    By jdiegelmann in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-13-2017, 08:56 AM
  2. [SOLVED] Plot minimum value for given year by skipping or ignoring the zeros, blanks and errors
    By Sekars in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-03-2016, 08:16 AM
  3. Averaging data from a table by row name and ignoring blanks/zeros
    By HoneyBadger302 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-01-2015, 10:52 AM
  4. Index/Match ignoring Blanks/Zeros for each instance
    By corhrtz in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-18-2015, 11:04 AM
  5. Working out an average across multiple non concurrent cells excluding blanks and zeros
    By Streaky in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-11-2014, 07:56 AM
  6. Ordering a list whilst ignoring zeros
    By Woody. in forum Excel General
    Replies: 4
    Last Post: 10-22-2013, 11:20 AM
  7. Excel 2007 : Averaging Averages Whilst Ignoring Zeros
    By Jeff_Farrar in forum Excel General
    Replies: 2
    Last Post: 02-14-2011, 06:58 PM

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