Results 1 to 5 of 5

how to get text using sumif or some other function

Threaded View

  1. 03-29-2018, 08:48 AM #1
    fahadmohsin
    fahadmohsin is offline
    Registered User
    Join Date
    11-18-2016
    Location
    Islamabad, Pakistan
    MS-Off Ver
    2010
    Posts
    42

    how to get text using sumif or some other function

    Hi,

    I have a unique situation. I have names of employees in column A and type of purchase in column B, see excel sheet attached.

    I want to get all the type of purchases against an employee. Like for employee A, I want to display every type of purchase made in one cell against A.

    Please help.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. SUMIF function with four criteria, numbers and text
    By bblack812 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-28-2014, 03:01 PM
  2. [SOLVED] Exact text match within a SUMIF function
    By afgoody in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-17-2013, 11:35 PM
  3. SUMIF Function but with text results and variables
    By billyshears in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-16-2013, 10:58 AM
  4. Sumif function not returning text
    By slkelly13 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-02-2013, 06:01 PM
  5. SUMIF function to only sum if the cell is not a text value
    By Thirtyseven10 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-05-2012, 11:59 AM
  6. [SOLVED] Sumif like function for text
    By Kalts in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-18-2012, 09:50 AM
  7. Sumif function won't recognize text
    By roasthawg in forum Excel General
    Replies: 2
    Last Post: 11-02-2008, 03:14 PM
  8. Need a function similar to sumif for text
    By jasm106 in forum Excel General
    Replies: 1
    Last Post: 04-21-2005, 10:36 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1