Search results

Thank you so much for your help.

Hi, I tried Sparkline for showing Actual Vs. Target in one single chart. But its showing up in two different cells. Is there any way that we can show both Actual Vs. Target in one cell using Sparkline? I have attached the sample data for your consideration. Kindly support. This chart will be...

Thanks Chihiro. I doubted one formula and fixed it. After that everything seems to work fine. The reason why Excel was unable to point a cell, should be there were 2 references which were referring to each other. May be that's the reason why Excel was not able to point out one single cell as an...

I have already tried all of these. Even I have gone to each and every sheet and looked at Error Checking for any Cell reference. But nothing can be found. This kind of error is beyond the menu commands and I am not sure how to resolve it.

Hi, I came across a new issue in Circular Reference which doesn't say the cell reference in which there is a problem. Please help me with the attached error message. I have many excels and very few cells without a formula. In this scenario, its very difficult for me to find without any idea of...

Thank you Khalid. Its a new learning for me. Any similar shortcut for Data Filter as well?

Thank you Khalid. I have a different issue and I hope the attachment will make it clear. Please help.

Similar to CountIF & SumIF, how good it will be if we have SumProductIF!!!! Likewise, in data filter it would be of great help if we have an inverse selection option. For ex: if we have selected 3 out of 10 values in the filter and now we need to select the rest 7 values, its manual and time...

Thanks. Got it.

Hi, I have a file with 10 sheets with formulas connecting to different files. Of which, I believe the linkage is lost in 2 of the files, as they are not saved. Can anyone please guide me on how to identify the sheet and the particular cell which has some reference to the 2 unsaved files? The...

Very true. I often feel handicapped without this feature while filtering values. I believe it will be a blessing for all of us if Microsoft considers your suggestion.

Its really amazing Jeff and works perfectly well for my requirements.

Thanks Deepak for your guidance. I learnt a new stuff today.

I came across a weird issue when I tried to find a cell value "80% ~ 100%". The problem is not with 80% or 100%. The issue here is the cell value has got the symbol "~" which Excel is unable to recognize. When you change the symbol from "~" to "-", excel promptly finds the value. This is so...

Is there any way we can inverse the selected vales in a data filter? Assume, we have 5 values in Column A and already filtered Values 2 & 4. I am looking for a solution whereby I should be able to select rest of the values like 1, 3 & 5 by click of a button. Can anyone help with a macro or any...

One more clarification please.... When I check the Conditional Formatting by keeping the cursor for example in Cell C11 or C16, the Formula there still refers to $D10 only. But there is nothing wrong with the result. Any reason why it shows only the first value in the Range even when the...

You are really a Ninja. You deserve the title. It took me 5 minutes to understand what you did. Today I have learned somthing really awesome. This is a new dimension of how to use Conditional Fomatting and Wingdings Font together. May be Chandoo can publish an article on Conditional...

Guys, I need your expert help to show the relevant custom icons in Column C according to the values in Column B. I have attached the file for moe clarity. Your kind help is much appreciated. Regards, Ramnath

Many thanks Hui & Khalid for your expert advise. The calculating duration is now reduced to 45 seconds. For the benefit of everyone, may be you can consider posting these tips about the probable time consuming formulas, which can be avoided.

Yes. I have a 48 MB file which has the customer portfolio details and runs up to 77000 rows with 43 columns and additional 20 formula columns and 11 sheets. When ever I open this file, for every action, excel starts calculating and it really takes a decent 3 mins for every input. I need to...

Everyone must have come across this Calculating issue when excel is filled-up with formula. But I am wondering is there a way to find out which spcific cells are causing this issue? This is because, not all the formula cells are problematic. There might be very few cells containing volatile...

Thank you so much.

I am very curious to know how you have removed the dummy series legend. Can you please enlighten me?

Thanks a ton. This will save my time to a great extent. I have never used a dummy series like what you have done. Its a learning for me. Though we cannot remove the dummy series both from the table and in the legend, your tip is very handy and to the purpose. Please mark my query as "Solved".

Hi Somendra, Thanks for your quick reply. You are almost correct. But the issue here is, when we are in Sep, I need Sep values for all the 3 lines like Actual, Budget & Forecast. Eventhough, the Budget & Forecast start and end values are the same, the current month values need to be changed...