+ Reply to Thread
Results 1 to 3 of 3

inconsistent formula

  1. #1
    Forum Contributor
    Join Date
    06-29-2016
    Location
    Bristol, England
    MS-Off Ver
    2007
    Posts
    355

    inconsistent formula

    Hi. I have a large sheet of which 1 column (several hundred rows) shows 'inconsistent formula' error. I know what's causing it and it's not a fault. I know how to 'ignore' the error for one cell, but I can't seem to do it for a range (column) of cells?

    Many thanks as always.

    KK

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,520

    Re: inconsistent formula

    Select entire range. Scroll to first cell in selection.

    That is to say, top left most cell.

    You should see yellow exclamation mark there.

  3. #3
    Forum Contributor
    Join Date
    06-29-2016
    Location
    Bristol, England
    MS-Off Ver
    2007
    Posts
    355

    Re: inconsistent formula

    That's got it thanks, I was making the mistake of selecting not scrolling. K

+ 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. Inconsistent formula error
    By Trebor777 in forum Excel General
    Replies: 6
    Last Post: 11-13-2016, 12:30 PM
  2. [SOLVED] Repeating inconsistent formula Help!
    By rham243 in forum Excel General
    Replies: 20
    Last Post: 07-22-2015, 11:32 AM
  3. inconsistent behavior of a formula
    By loubedor in forum Excel General
    Replies: 1
    Last Post: 04-04-2015, 04:14 PM
  4. causes of inconsistent formula
    By ammartino44 in forum Excel General
    Replies: 1
    Last Post: 03-20-2015, 08:41 PM
  5. Inconsistent results for formula
    By Maxwel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-27-2014, 08:04 PM
  6. Formula - Works but inconsistent
    By karobonas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-2011, 07:24 AM
  7. Inconsistent Formula??
    By AlienBeans in forum Excel General
    Replies: 1
    Last Post: 09-03-2006, 12:52 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