• 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. K

    How to conciliate money transactions!?

    Hello everyone! Before you continue, beware! This is a big post... :) I'm making a personal expense tracker/budget sheet and I've gotten a lot of input from Chandoo's posts.. but now I got a lil stuck and would appreciate your ideas. I import my bank statement to my transaction sheet and...
  2. K

    Arrays - average corresponding values for each occurance

    The post came out unligned.. A1:A5 - a b c a c D1:D3 - a b c E1:E3 - 1 5 3 This means: a = 1, b = 5, c = 3 So I want the resulting array that would be: 1 5 3 1 3 (corresponding values) Then I can average these numbers. Is this clear at all? I could upload the actual spreadsheet somewhere...
  3. K

    Arrays - average corresponding values for each occurance

    Hui, thanks for your thought, but I'm not sure how to use the COUNTIF result to retrieve the values in column E? Also, I cannot use the 'copy down' part, the whole point is to have a formula in a single cell, otherwise I would have gone with VLOOKUP.
  4. K

    Arrays - average corresponding values for each occurance

    Hi everyone! I hope someone can shed some light, because it's driving me crazy here. Been working on this for over a week now! Suppose this situation: A B C D E 1 a a 1 2 b b 5 3 c c 3 4 a 5 c What I need is: get the corresponding values in E for each value of A...
Back
Top