+ Reply to Thread
Results 1 to 6 of 6

Not receiving any results in cell where formula entered

  1. #1
    Registered User
    Join Date
    02-25-2017
    Location
    Lubbock, Texas
    MS-Off Ver
    Excel 2010
    Posts
    5

    Cool Not receiving any results in cell where formula entered

    I have added an attachment of the sample workbook to show what I am trying to accomplish.
    Attached Files Attached Files
    Last edited by jfranklin72106; 02-27-2017 at 11:21 PM. Reason: To add attachment

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Not receiving any results in cell where formula entered

    Hi Welcome to Forum,

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,422

    Re: Not receiving any results in cell where formula entered

    Maybe:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Registered User
    Join Date
    02-25-2017
    Location
    Lubbock, Texas
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Not receiving any results in cell where formula entered

    Thanks so much. I will give that a try. So I think I get what you are saying. Is the =3 the number of cells with the "NA" in it? So then when I add in the rest of the string then I should change the =3 to match the next group of info?

  5. #5
    Registered User
    Join Date
    02-25-2017
    Location
    Lubbock, Texas
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Not receiving any results in cell where formula entered

    I tried the above suggestion and still go an error. I will try to attach the workbook so you can see what it looks like. Thanks

  6. #6
    Registered User
    Join Date
    02-25-2017
    Location
    Lubbock, Texas
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Not receiving any results in cell where formula entered

    Ankur, I have added a sample workbook to my initial thread. Thanks for the suggestion.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. When data is entered into cell results in print or do not print.
    By Bikeman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-31-2016, 04:37 PM
  2. [SOLVED] after receiving data, cell should be MT
    By rajeshn_in in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-16-2016, 04:36 AM
  3. [SOLVED] Receiving #N/A as Result for a Formula
    By Squint in forum Excel General
    Replies: 2
    Last Post: 03-11-2014, 10:36 AM
  4. [SOLVED] Receiving #DIV/0! Error in Basic Formula
    By DDM64 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-10-2013, 11:29 AM
  5. Formula entered in cell via VBA results in #VALUE
    By Freakazoid in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-15-2011, 04:28 AM
  6. Receiving 0 when copying formula
    By mgtid in forum Excel General
    Replies: 2
    Last Post: 09-16-2007, 06:36 PM
  7. Replies: 2
    Last Post: 05-06-2005, 04:48 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