Search results
-
J
Hello .. Introduce yourself
Hello all, I'm a research analyst, and excel is ruining my everyday life! I totally love it! I must say the excel ninjas here are very very knowledgeable, from nested formulas, to VB code, to being wisecracks. I'm very thankful for all the help I can get. It'll take me 10 lifetimes to get...- jasonleewkd
- Post #270
- Forum: The Lounge
-
J
Use of large, index match, or VBA?
Narayan, Yes I have checked out sheet 2. I've learnt the offset function from Chandoo's website and it is very helpful. I've implemented it in my other uses of excel. I understand that your formula has expanded to include indirect, large, and the use of named ranges. Very helpful. If you see...- jasonleewkd
- Post #5
- Forum: Ask an Excel Question
-
J
Use of large, index match, or VBA?
District 1 Australia 10 Singapore 9 China 9 USA 9 Germany 6 Malaysia 5 The above turns into the below (using various formulas, large, index/match) Name of top 3 in district 1 Top 3 in district 1 Australia 10 Singapore...- jasonleewkd
- Post #3
- Forum: Ask an Excel Question
-
J
Use of large, index match, or VBA?
Hi gurus at Chandoo. Can anyone help me with the dataset I have and the retrieval? I have used formulas large, index & match, but not vba as I'm not well-versed in it. On the Y axis are nationalities. On the X axis are residential districts. The number in the body of the data is the...- jasonleewkd
- Thread
- Replies: 12
- Forum: Ask an Excel Question