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

    How to calculate average temperature using offset function?

    Kaushik, Thanks for responding. Here is the file. http://www.4shared.com/file/S8_tb-HU/WeeklyTemperature.html Regards RK
  2. rkspeaks

    How to summarize the data in dynamic ranges across sheets?

    Hello, I have my data in 12 sheets named by the month names and a Summary sheet. I have to summarize the data. The columns in all the sheets are Product, Qty for 4 regions, Sales for 4 regions, Commission for 4 regions. Each month Sales varies. That's the problem for me to use...
  3. rkspeaks

    How to calculate average temperature using offset function?

    Hey, I have Date field in A column and Temperature in B column. A column goes on till today's date. I have to calculate last seven days' average temperature whenever I open the Excel workbook. If I enter Today's date in C7 (in C7 TODAY function is there), I want the last seven day's average...
  4. rkspeaks

    Tool-tip for a User defined function

    Thank you. Luke. I will try that link and come back later, if any issues.
  5. rkspeaks

    Tool-tip for a User defined function

    Hi Chandoo and all Ninjas, Good evening all of you.. meeting you all after a longtime. Today my questions are : 1. How can I add a Tool-tip for a User Defined Function created by me. Is that possible in VBA for Excel?? If Yes, Just give me some example code in terms of where to place it...
  6. rkspeaks

    What is the maximum criterias for Index Match function

    Oh! What a silly mistake..fine me for eating your head.. Anyways it's just working fine. I cannot spend a day without meeting you guys...! :D Thank you RK
  7. rkspeaks

    What is the maximum criterias for Index Match function

    Good Afternoon All, I have a problem in using the index/match formula. Normally it shoots like a Gun. But here I have four criteria in my problem. I got a #N/A error. I have gone thru some of Chandoo's index/match posts. Still I am not clear on one thing i.e. Is there any limit for the no of...
  8. rkspeaks

    Extract file name from full path using formulas

    Chandoo and all Ninjas, Dasara wishes for everybody, It's a very Good evening for meeting you all again! Apropos to the post with the title "Extract file name from full path using formulas", I came up with a problem (not to mention, I always come up with problems), which has a difficulty...
  9. rkspeaks

    Taste of Formulas

    Chandoo & Hui and all Ninjas, As things are getting more and more interesting, I came up with an plan for Chandoo to conduct a survey/voting event on the taste of Formulas on the following lines just to add up something to the spice. 1. Most interesting formula. 2. Most intimidating formula...
  10. rkspeaks

    Interview Questions ...

    We can hide a worksheet by pressing Alt F11, Under VBA Projects window there is another window named "Properties", Go To Properties ---> Visible --->in the column right beside that, click the drop down to VeryHidden. Come back to Excel sheet, check for the sheet you want to hide. It will...
  11. rkspeaks

    Complex Pivot Table

    Hey Faseeh, Really it's a great spreadsheet work, You actually squeezed the data into a matchbox. I shown this to my neighbor uncle (who is a Scientist), he actually spellbound and immediately ordered me to convey his ton of thanks to you. He even appreciated Haseeb's work as well. Having not...
  12. rkspeaks

    Complex Pivot Table

    Hey Haseeb, It's super! What I understand is that all the difficulty is in the arrangement of the data. If I want to re-arrange the data i.e. years, states over crop(crop is the filter), we have to rearrange it, right! So again you cannot escape from the rearranging process meaning Pivot table...
  13. rkspeaks

    Complex Pivot Table

    Hey Muneer, It kicks back saying you have entered too many arguments. Can you just check it out. Something wrong while pasting the post even if you have built the correct formula? Waiting... RK
  14. rkspeaks

    Complex Pivot Table

    Ok..Wait guys.. I am checking..
  15. rkspeaks

    Complex Pivot Table

    Here is your requirement. State Code Andhra Pradesh AP Arunachal Pradesh AR Assam AS Bihar BR Chhattisgarh CG Delhi DL Goa GA Gujarat GJ Haryana HR Himachal Pradesh HP Jammu & Kashmir JK Jharkhand JS Karnataka KA Kerala KL Madhya Pradesh MP Maharashtra MH Manipur MN...
  16. rkspeaks

    Complex Pivot Table

    Faseeh, He want to see Statewise, Yearwise, Cropwise production without any hassle AND within a small sheet space without any complexity. I tried to give him a solution but the data for so many years is looks like a bit complex in arranging. Thank you RK
  17. rkspeaks

    Complex Pivot Table

    Hi Faseeh, I am stuck with a complex pivot table data. How can I analyze this in a meaningful format. It contains Indian crop data for 9 crops, for a decade period, across all the states in India. It was requested by my neighbor uncle who is a scientist. Here is the link for the database. You...
  18. rkspeaks

    Mirror charts

    Hey Faseeh & Narayank991, Firstly thanks for being prompt. Seen your mirrored charts and understood them well. So we don't have to do something great to show the data items in reverse order(below ground level). If a data item is a negative number it automatically shows them below the...
  19. rkspeaks

    Mirror charts

    Hey Faseeh, The above write-up referred by NARAYANK991 just shown the varieties of different charts but not the recipe. That's what the write-up I am referring to, today morning. Guys, please let me know if anybody knows that this kind of charts are having another name?!? Chandoo, Your...
  20. rkspeaks

    Mirror charts

    Chandoo & All Ninjas, A very Good morning, I have been searching for a writeup on mirror charts. In fact Chandoo has written an article on that. But he did not talk much about the recipe of that cooking. I thought it may be a secret recipe formula like our KFC items, That's why he kept it...
  21. rkspeaks

    How to get totals from Slicer items ?

    Thank you..Suresh !
  22. rkspeaks

    How to get totals from Slicer items ?

    I have a query regarding the Slicers in Excel 2010. Normally we can see slicers and their category items once you insert the Slicers from the Pivot table data. But I want to see the totals of the category items instead of category items. Is it possible? It's pretty straight question, but If...
  23. rkspeaks

    Laptop brand/configuration for Excel power users..Advice please!

    Finally I got a Lenovo Thinkpad E430 with Core i3, 4GB, 500 GB, DOS Machine. That's an apt product for my usage. Thank you all for your advices. RK
  24. rkspeaks

    Laptop brand/configuration for Excel power users..Advice please!

    Oh! It's my pleasure to accept as many advices as you can give from Excel brotherhood. Anyways, I narrowed my choice between Lenovo G580 and Z580. Just tell me your opinion on these two things. Good, Bad or Ugly ?!?!? I will take best configs with these models. i.e. i5, 15.6", 500GB, Numb keys...
  25. rkspeaks

    Laptop brand/configuration for Excel power users..Advice please!

    Thank you Chandoo, That's what I am waiting for. I will ping all once I get the machine which matches all the criteria. But personally I am dragged towards Lenovo G570/G580/Z580. I am stopping my 2 months long research today with this post. Thank you again.
Back
Top