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