+ Reply to Thread
Results 1 to 2 of 2

Problem with Excel or ME???

  1. #1
    Registered User
    Join Date
    03-02-2017
    Location
    South Africa
    MS-Off Ver
    2016
    Posts
    4

    Problem with Excel or ME???

    Hi All

    Im not sure if im making a mistake or i have confused Excel.

    Im making a very SIMPLE inventory table for my workshop.

    In a nutsell - its as easy as:

    1. Item 2. In/Out 3. Current stock on hand(Calc) 4. Add or subtract stock

    Logic is a follows:

    I have a table. Items are a drop down list

    The formula i have - which works without issue until excel crashes it - is to simply look at the rows above - to find the last entry of this items above,
    which is the same as the second last entry of this item in the whole column array.

    Formula works great. No circular reference nonsense.

    Then - when i index this formula - to pull the value of the current quantity - it also starts ok, then crashes (says circular reference but cant identify it)

    Please help ?
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Problem with Excel or ME???

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Replies: 6
    Last Post: 07-01-2018, 01:58 PM
  2. [SOLVED] Excel Macro - Copy & Paste (Font) problem & Delete Last Added Rows problem
    By LennartB in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-05-2015, 06:58 AM
  3. Replies: 1
    Last Post: 04-01-2015, 02:30 PM
  4. Replies: 6
    Last Post: 10-20-2013, 07:16 PM
  5. How to properly order information in excel? Statistics + Excel type problem
    By beisbol16 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-23-2009, 06:48 PM
  6. Excel problem (not spreadsheet problem)
    By c991257 in forum Excel General
    Replies: 0
    Last Post: 05-30-2007, 11:18 AM
  7. Started out as an Access problem. Now an Excel problem
    By RobertM in forum Excel General
    Replies: 2
    Last Post: 04-26-2006, 02:35 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