Results 1 to 5 of 5

One to One Formula extract then one to many

Threaded View

GCLIFTON One to One Formula extract... 01-13-2017, 05:57 PM
Richard Buttrey Re: One to One Formula... 01-13-2017, 06:49 PM
GCLIFTON Re: One to One Formula... 01-13-2017, 08:09 PM
Richard Buttrey Re: One to One Formula... 01-13-2017, 08:37 PM
GCLIFTON Re: One to One Formula... 01-13-2017, 08:58 PM
  1. #1
    Registered User
    Join Date
    10-21-2016
    Location
    Denver Co
    MS-Off Ver
    2013
    Posts
    65

    One to One Formula extract then one to many

    Need help with a macro that will per the [Operation] will or if the operation is the same
    1. Match amounts when added together = 0 (86, -86) and label them "1"In column AB
    2 Then If operation is the same and if there is not a "1" in Column AB sum all the other Amounts that may equal one to many For Example ( 1,078.55+ 9,670.00 = 10,748.55) and label "2 "in Column AB
    3. Highlight the Amount Cells Green if there is a 1 or 2 in Column AB


    Attach is example of data. I highlight 2 groups that add to zero and sum to zero once a test is run. There may be more that net to zero
    Attached Files Attached Files
    Last edited by GCLIFTON; 01-13-2017 at 06:00 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] extract amounts from formula
    By k1dr0ck in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 03-16-2016, 06:17 AM
  2. [SOLVED] Formula to extract strings
    By sharathnarayanan in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-13-2015, 03:53 AM
  3. [SOLVED] Need help with text extract formula
    By SEMMatt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-09-2014, 07:52 PM
  4. [SOLVED] Extract Year for Other Formula
    By Publicpenguin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-05-2014, 07:29 PM
  5. Formula to extract text
    By nobodyukno in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-14-2014, 08:48 AM
  6. Extract formula text
    By blachloch in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-11-2012, 04:14 PM
  7. [SOLVED] Extract formula from Text box
    By CLR in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 02-08-2005, 11:06 AM

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