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

    world-map chart via. excel 2010?

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

    vLookup array formula

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

    VBA to multiply small list by UserEntry value?

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

    VBA to multiply small list by UserEntry value?

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

    VBA to multiply small list by UserEntry value?

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

    VBA to multiply small list by UserEntry value?

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

    VBA to multiply small list by UserEntry value?

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

    VBA to multiply small list by UserEntry value?

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

    VBA to multiply small list by UserEntry value?

    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?
  10. C

    VBA to multiply small list by UserEntry value?

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

    VBA to multiply small list by UserEntry value?

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

    VBA to multiply small list by UserEntry value?

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

    VBA to multiply small list by UserEntry value?

    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 :)...
  14. C

    VBA to multiply small list by UserEntry value?

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

    VBA to multiply small list by UserEntry value?

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

    how to start my chart at 0 intersection?

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

    how to start my chart at 0 intersection?

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

    how to start my chart at 0 intersection?

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

    how to start my chart at 0 intersection?

    Many thanks Hui!! Although I don't quite follow - I'm down to selecting series 1 in the chart, but not sure where the edit button is? :)
  20. C

    how to start my chart at 0 intersection?

    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! :)
  21. C

    Consolidaton Spiliting

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

    help help in file

    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!
  23. C

    help help in file

    Hi Jenan! I'd be pleased to help you .. can you share your file? Cheers!
  24. C

    How do I make rows stationary as i scroll down my spreadsheet?

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