Recent content by dramnath1981

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