Hi guys,
I'm looking for posts about presenting data by country via. a world map in excel 2010 without downloading anything onto work computer.
Any idea's?
Thank you! xx
Hi Guys,
Further to this post: http://chandoo.org/wp/2010/11/08/vlookup-array-formula/ I am wondering how best to adapt the below formula to bring back the average between two specified dates?
{=AVERAGE(VLOOKUP(A7,Summary!A:M,{?????????},FALSE))}
Using the data table picture at the top of...
ok, I shall do all of this, this weekend!
thanks again for all of your kind help, you guys rock!
love from NL (where it's still raining .. in july!! boo).x
hellooo again :) i can't thank you enough for your help with this .. it's a super insightful conversation after spending three day's in the power programming book!
I'm still not clear though .. and think it's your first sentance I'm unsure about ... what do you mean that VBA searches for the...
I didn't solve it with your technique .. yet!
Thanks for uploading the example (I was still searching through the list of sites to use trying to decide which one's better! DropBox?) ..
So .. what happens if you move the list .. say by inserting two rows at the top .. then the macro still...
errrm, ok .. should I upload a version for you?
I have already solved the problem using Hui's answer .. but if you're open to discussions, that would be fan-taddy-tastic!!?
Let me know?
thanks! i'm sure this is a silly question, but i still don't think we specified i as the range b2:b7, did we?
i'm still receiving the run-time error and notice that it's leaving 0's in cells c1 and c2 ..
I've also changed my excel sheet around slightly so now the range of cells is called...
Thanks also for your kind words and encouragement, this has been on my to-do list for years, so now I have some time, here I am!!
I see what you mean about learning path now - and I've certainly got a varied one going, but so far (this week) so good! I'll keep you posted!
Again, thank you so...
Actually that does really help!!
I think I get it .. is cell(I,2) referencing the 2nd collum from i? and it's saying that the 3rd column = 2nd column * UserInput?
One last question: how does it know I is the cells b2:b7?
I would swap this terrential downpour in Amsterdam for South America any day dude!!!
A learning path sounds like a good idea though .. tell me, what exactly do you mean?
Also, about your code .. I'm getting a run-time error '13: type mismatch on the 4th from bottom line starting .cells .. ...
Many thanks SirJB7!
I've tried some recording & some writing, and have played with the relative cell referencing, but figure it's also in the practice, so am pleased I have my personal prject to be working on :)
Something tells me it's going to take a BIG while before I'll be fluent though...
haha, I was just coming back to say that @Hui! wows - this is amazing, thank you so very much! now I'm onto my next step at least :) :)
It's interesting how different your approaches are to achieve the same goal - I can see the For-Next loop (is that the right name?) but otherwise you've gone...
Hey Guys! Thanks so much for your help, it's very much appreciated!
Hui, your code is absolutly perfect - except that I want the multiplied values to be dropped into c1:c7 (so I can keep the original data 'clean') - how would I action that?
Sir JB7, nice to make your acquantance as well :)...
Hi kaushik03, and thanks for your reply!
I'm not sure I know what a multiplication factor is, but I'll try to explain:
It's really very simple (and my first ever VBA), I'm just trying to learn, not make the meanest baddest fastest script in the world!
So .. I've got a recipe list in excel...
Hello.
I'm a VBA newbie & today I'm trying to write my first ever program - but I'm not sure exactly how I should approach multiplying a (very small) excel list by a user entry value .. (or if indeed I should have it in excel at all, or just include into the code?)
I've got my UserEntry...
Thanks Hui! I was following your instructions though *scared eyebrow raise* hehe.
Doing that alone has moved the series points to align with the x-axis names - so now the series start at their first plot value ..
But what I want is for them to all start at 0 time & 0 value.
I was sure...
oh wows, thank you so much Hui, I'm very appreciative of the spreadsheet!!
I fear I haven't been clear enough with my question though - as I want my series lines to all start at the 0,0 intersection of the chart (but they're currently starting mid-way through the first month at the first...
Thanks again Hui!!
Unfortunately I'm still not there .. I'm looking at a very basic revenue earned for three shops over a 12 month period .. and what I've got is the three series starting on the y-axis at their first month value .. but what I want is for them to all start at 0, and then join...
Hi guys!
I'm sure there's a setting for this .. I'm trying to make my data lines in a line chart start at the zero intersection .. can someone please remind me how?
Much appreciated!
:)
Hiya Pragnesh!
I'm thinking that you should most definately employ the data > consolidation function in order to turn this into an almost instant analysis.
No nned to spend hours copying data back & forth! What a nause!
As long as each sheet is identially laid out, you can consolidate...
I'm also unsure about the chat options .. but I'd still be pleased to help you :)
If you're able to upload the file, am sure that will communicate half of the issues for you and then we can use this string to continue?
I hope this is helpful!
Hello WorkingMan :)
I think you need to use the 'Freeze Panes' function, which can be found under the 'View' ribbon option.
You can also freeze a sub-section of collums & rows together, or just rows or columns alone. It all depends where your cursor is when you run the function! In short...