Results 1 to 5 of 5

Subtract values without change value in specific cell

Threaded View

marreco Subtract values without... 12-19-2017, 01:28 PM
Glenn Kennedy Re: Subtract values without... 12-19-2017, 01:33 PM
marreco Re: Subtract values without... 12-19-2017, 01:42 PM
Glenn Kennedy Re: Subtract values without... 12-19-2017, 02:26 PM
Alf Re: Subtract values without... 12-19-2017, 03:34 PM
  1. #1
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Subtract values without change value in specific cell

    Hi, I need subtract values in column T (Yellow color) without change value in cell T31 (30,80)

    Maybe only solver or VBA to fix this...

    Example if you type in T36 and change value 19,03 to 19,00 nothing change in T31, but if you type in T36 and change value 19,03 to 18,00 in cell T31 change to 30,70 (I can't do this happening).

    The file is large, i need upload anotherplace:
    https://www.sendspace.com/file/69i4e2

    Thank you!!
    Last edited by marreco; 12-19-2017 at 01:33 PM.
    "No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.

    If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBS Help to Auto Refresh Pivot Tables when data or specific cell values change
    By kwoltman in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-13-2017, 06:55 PM
  2. Replies: 3
    Last Post: 10-10-2017, 03:25 PM
  3. Replies: 1
    Last Post: 10-06-2017, 04:29 PM
  4. [SOLVED] Subtract two date colums and count rows with specific values
    By waylynjohnston1 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 11-06-2016, 06:45 PM
  5. Replies: 1
    Last Post: 02-09-2016, 08:59 AM
  6. [SOLVED] subtract from a specific amount but keep total in same cell?
    By michaelDDW in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-03-2015, 08:37 PM
  7. Replies: 2
    Last Post: 03-05-2015, 10: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1