Results 1 to 10 of 10

sumproduct - sum the same abbreviated titles of medical journals

Threaded View

Oncology sumproduct - sum the same... 10-25-2018, 08:43 AM
dominicb Re: sumproduct - sum the same... 10-25-2018, 09:21 AM
Oncology Re: sumproduct - sum the same... 10-25-2018, 09:29 AM
Bo_Ry Re: sumproduct - sum the same... 10-25-2018, 09:24 AM
Bo_Ry Re: sumproduct - sum the same... 10-25-2018, 09:35 AM
dominicb Re: sumproduct - sum the same... 10-25-2018, 09:39 AM
CK76 Re: sumproduct - sum the same... 10-25-2018, 09:46 AM
mohan.r1980 Re: sumproduct - sum the same... 10-25-2018, 10:01 AM
FlameRetired Re: sumproduct - sum the same... 10-25-2018, 05:17 PM
Oncology Re: sumproduct - sum the same... 10-26-2018, 05:50 AM
  1. 10-25-2018, 09:46 AM #7
    CK76 is offline
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,973

    Re: sumproduct - sum the same abbreviated titles of medical journals

    You can just use Bo_Ry's formula result as source for pivot table, and do count on title.

    See attached.
    Attached Files Attached Files
    "Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
    ― Robert A. Heinlein
    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. Automated posting from journals to ledgeraccounts
    By TennisShoesFitSz12 in forum Excel General
    Replies: 7
    Last Post: 09-20-2024, 12:04 AM
  2. How to keep titles, sub-titles, and blank space when sorting
    By wanttolearnexcel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-13-2018, 12:54 AM
  3. [SOLVED] Sumproduct based on employee number and column titles
    By jantonio in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-21-2018, 04:10 PM
  4. Ideas on a spreadsheet to create sheets from multiple journals
    By ShadowRider in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-31-2011, 12:06 AM
  5. accounting ledgers and journals
    By llv8rgrl in forum Excel General
    Replies: 1
    Last Post: 07-09-2011, 02:13 AM
  6. Changing the column titles to the spreadsheet titles when scrolling down
    By Frank the Haddock in forum Excel General
    Replies: 4
    Last Post: 06-22-2011, 09:50 AM
  7. spreadsheets and auto General Journals postings
    By Gemini Crafts in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-14-2006, 10:50 PM

Tags for this Thread

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