Results 1 to 3 of 3

Distinguish data from one column to another

Threaded View

  1. #1
    Registered User
    Join Date
    07-13-2021
    Location
    Hong Kong
    MS-Off Ver
    365
    Posts
    8

    Distinguish data from one column to another

    Good day,

    I would like to solve this problem using formula, query, or pivot.

    My company is issuing invoices. Most of them charge audit service fee and outlay together, and some of them only charge outlay.
    I cannot think of a logic to distinguish them in the format I expected.

    Please help.

    Service fee and outlay.png
    Attached Files Attached Files
    Last edited by Bobbie Kan; 08-15-2021 at 09:56 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VLookup/match function requires tweaking to distinguish between 2 data lookup ranges
    By skydivetom in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-01-2020, 08:02 PM
  2. Replies: 4
    Last Post: 03-21-2017, 10:29 PM
  3. Replies: 4
    Last Post: 05-24-2016, 08:19 AM
  4. [SOLVED] I need a formula that will distinguish blocks of data with sub headings as they are foud
    By john dalton in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-15-2015, 10:40 AM
  5. distinguish data from multiple sheets vba
    By rexer231 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-02-2013, 12:21 PM
  6. [SOLVED] Distinguish whether the next cell down is <20 OR a word in a different column is present..
    By tlacloche in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-25-2013, 01:25 PM
  7. match or compare 2 columns to distinguish duplicate data
    By gchauhan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-31-2012, 05:53 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