Recent content by jsk_lge

Hi there, i have two sheets in which one of the sheet contains raw data branch & model wise (the sheet name is "data is like this" in attached file). in raw data, branch is in column and model is in row. i need a formula to arrange this data in which branch & models both are in column. pls...

Thank you very much Hui sir.

yes !!! but how I can ??

Dear HUI, sorry for delay, I want a chart something like in attached sheet. pls suggest how to make it ?

Dear Sir, in the attached file, i want to show EMP count as column series while in same chart, i want to show primary & secondary as row series, but is not possible with a single legend. so i want separate legends for column & row series. pls help. thanks.

hi there, i want to use more than one (two) legends in my single chart. how can I do so ?? sample data is below: Region EMP Count Investment Cost East 14 2.5% West 10...

Hi There, I am in search of a chart template which show attractively region vs branches break up. My region is central, regional Productivity is 2.5%. I have 5 branches is central region and productivity is as below- Branch A - 2.5% Branch B - 3.1% Branch C - 1.9% Branch D - 0.8% Branch E -...

Thanks Narayan, your formula works.

I have many numbers in a colum. I want to count only those numbers which are divisible by 2. which formula should I use?

@Narayan dear Sir, I cant understand how to apply countif in subtotal ? like =subtotal(2,?,?,?,...) which function no. should i use and how apply the condition??

I have a filtered list contains letters a, b, c, d etc. i want to count those cells only which contains "d". which function should i use?