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.