Search results

I am having an excel table, where I would like to do subtotal at both row as well as column level..While excel default enables calculating subtotal at row levels, how do I do it at column level?

Hi Somendra. Appreciate your sharing the specific formula. I must admist, I am pretty basic with excel and not able to relate to the suggested approach of "entering with ctrl+shift+enter"...So, I enter the formula and then press ctrl+shift+enter OR something else.. Also, I entered the...

Hi Narayan. Appreciate your picking up my thread. After posting the query here, I did some more googling and modified the formula as =INDEX(Sheet1!$D$2:$E$1707;SMALL(IF(Sheet3!$A2=Sheet1!$D$2:$D$1707;ROW(Sheet1!$D$2:$D$1707)-MIN(ROW(Sheet1!$D$2:$D$1707))+1;"");COLUMN(Sheet1!E:E))) I didnt...

I am struggling with a spreadsheet wherein I need to populate mutliple outputs for a given match. I found the formula shown in the video appropriate and serve my need - BUT - when I am trying it in windows 7 enterprise, excel 2010 - it's showing "#value!" error...My output values are in text...

Hi Hui. Sorry. Didn't get to know about your update till the time I logged in today to request for another help from this forum (and my requests end up being over the weekend somehow). Thanks for your updated sheet. I had managed it myself in the meanwhile. Thanks

Hi Hui. Sorry, but just taking a proper look at the chart output and not able to move the chart output to a new tab (it copies only the values and not the legend and chart area / lines). Ideally, I would like to see the chart output in a separate tab and then copy paste it into a power point...

Hi Hui, Naranyan, Thanks for your responses. This time, the reason for delayed response from my end is the time zone gap. I had a look at the file from Hui and looks great. This is what I wanted. Much appreciated. And Hui - regret the inconvenience due to lack of clarity initially. I...

Hi Hui, Narayan. Sorry, for taking 6 / 7 hours for my response to your support above. And, Narayan - but no means I can be intimidating...I am genuinely seeking help, and do desire to complete this by Monday EOD..Hence the urgency. Perhaps since I am not the expert in excel - may be I...

Hi Hui. Appreciate your inputs and the file. However, unfortunately - this is not what I am looking for. As I drew in the pictorial output above https://www.dropbox.com/sh/32yz12b4bbidjby/5FAe7IFuCP#f:Picture1.png Each line is unique for a unique parameter and the 2 dots on a specific line...

HI Narayan. Appreciate you noticing my post. Please find the sample data below. Please note, the data and number of parameters could be different. Thanks in advance. 2013 Input Score 2025 Input Score Direct Competition 4.58 3.95 Customer Pressure 3.47 3.84 Summary of Direct Forces 4.25...

I need some urgent help on plotting data points on a linear scale. I played around with various chart options, but cant seem to figure out. My data contains 2 point values (per parameter) for a few parameters, and i would like to show them in a chart format (instead of a boring table). The data...