• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. J

    Shorten Sumproduct formula

    Hi there, how can we shorten this? =SUM(SUMPRODUCT(A1:W1,A11:W11),SUMPRODUCT(A2:W2,A12:W12),SUMPRODUCT(A3:W3,A13:W13),SUMPRODUCT(A4:W4,A14:W14)) It's summing the sumproduct of 4 paired arrays.. I've tried using MMULT with TRANPOSE, but it doesn't give me the same result...
  2. J

    Weighted average in pivot tables

    Greetings again! I know Pivot Tables can calculate averages, sums, etc., but can they calculate weighted averages? Below is a table with categories (Level1) and Sub-categories (Level2). Within each sub-category, I want the average (simple enough). For the category (Level1) I want the...
  3. J

    Transpose table from a questionnaire

    Hi all, I'm creating a questionnaire, which will be linked to a small dashboard. I'd need to transpose a table that maintains links to the original table. I've tried to many things! Here's a file that explains more and shows my plan so far. I originally posted a related question here...
  4. J

    Combining paste functions: Paste Link and Transpose

    Anyone able to do this? Choosing "transpose" in the Paste Special menu grays out the Paste Link option. AND/OR I have a reasonable array of cells (~15 rows x 24 cols), populated by a conditional reference to another cell: =IF(C6="", "", C6) - I want to transpose paste this...
  5. J

    Change Icon

    Hi there, is it possible to change my icon/picture? My face looks stressed out, it makes me feel tense just looking at it! Many of your faces look so nice and calm; your tranquility is contagious.
  6. J

    Creating a modeless UserForm to guide users as needed

    Hi there, I'm creating an assessment tool (to evaluate water security in rural, resource-limited communities) and would like to provide guidance As Needed by the users. I'd also like to save screen space and not overwhelm the user, so I'd like to rule out using simple text boxes. My...
  7. J

    Display name of a named range in cell

    Hello, I want to display the name of an assigned range in a cell. Example: Cell $B$5 is named Population Example: Range $C$9:$E$20 is named Stats I want to display the assigned name within a cell (say A1), so that the cell output reads, e.g. Population. If I were to change the name of the...
  8. J

    Count unique values within a dynamic hierarchal range

    Hi there, I've read up on counting unique number of entries: sumproduct(1/countif(A2:A100, A2:A100)) What I'm trying to do now is do this for a dynamic subset of this range. I'm using Excel's Table features, and it's set up like this: Level1 Level2 Count of Unique Level2 for...
Back
Top