Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
All Tags » Formula » Ranges (RSS)

Browse Forum Posts by Tags

Showing related tags and posts for the Forums application. See all tags in the site

  • Re: Multi Criterion & Sumproduct

    Hello again! Wondering if its possible with the same example to actually count the distinct values in the given column I'm aware that I can get distinct count (including text) by saying: =SUM(IF(FREQUENCY(IF(LEN(H3:H11243)>0,MATCH(H3:H11243,H3:H11243,0),""), IF(LEN(H3:H11243)>0,MATCH...
    Posted to Functions and Formulas (Forum) by noaman on Thu, Mar 17 2011

  • Multi Criterion & Sumproduct

    Hello, Would highly like if you could shed some light on how I can accomplish this. My sheet has three segments. The first being a selection for the users (the user can choose which category they want to view the reports for): Selection # Category Include? 1 Electricals Yes 2 Paper Yes 3 Food Yes 4 Beverages...
    Posted to Functions and Formulas (Forum) by noaman on Tue, Mar 15 2011

  • “If” formula for the letter the value begins with?

    I have 3 sheets in my excel document. The first one is the main form and the other 2 are summaries that need to be populated and distributed the correct person depending if one value on Sheet1 begins with a letter between A-O or P-Z. What I need on each summary sheet is this sequence: On Sheet 2 in Cell...
    Posted to Functions and Formulas (Forum) by l.t.doppler on Wed, Oct 20 2010
Page 1 of 1 (3 items)
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.