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