Results 1 to 7 of 7

Pulling "MIN" Data From Another Sheet (Error Detection)

Threaded View

  1. #1
    Registered User
    Join Date
    05-13-2022
    Location
    Florida, USA
    MS-Off Ver
    365
    Posts
    12

    Question Pulling "MIN" Data From Another Sheet (Error Detection)

    This community is always so helpful, hoping you can pull another one off for me

    I have attached the workbook with the goal of pulling information from the sheet "CallTek" into the "Daily Tickets Report" sheet cell D6. Currently I am using the following function: =(CallTek!P2)

    This works only if I presort the data on the sheet "CallTek" so that the oldest ticket date is first in cell. The problem is if the reference cell is null than it displays "0" when I want it to display "N/A"

    Someone on this site provided a function that works in the other rows in column D - only if they are in a date form like #/#/## however if the reference cell says "# days ago" it breaks the function. This function provided was: =IF(COUNT(SheetName!M:M)=0,"N/A",MIN(SheetName!M:M))

    Goal: Display "# of days ago" or "N/A" if reference cell is null -AND- if possible pull the oldest value such as "2-months ago" over "2-days ago"
    Attached Files Attached Files
    Last edited by PinkFloydEffect; 05-27-2022 at 05:15 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. "Error" or "Disallow" Entries If Data Entered in Wrong Cell
    By sage.tx in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-12-2017, 12:20 PM
  2. Replies: 35
    Last Post: 01-13-2016, 02:16 AM
  3. Script not copying data from "Emails" sheet to "New Sheet" - Run time error: Object
    By methuselah90 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-08-2014, 03:22 PM
  4. Replies: 3
    Last Post: 05-31-2013, 05:16 AM
  5. [SOLVED] Is there a way to change the error "div/0" in data table to "--" using cond. formatting?
    By Snowpear in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-04-2012, 01:05 PM
  6. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 AM
  7. Replies: 10
    Last Post: 03-11-2010, 05:03 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1