Search results

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?

dear all, I have a table, in which a column named Grade contains A, B, C, .... F. now I insert a pivot table, in value field, when i drag the grade field, naturally it displays count of grade. pls note that in colum field i put exam and every exam has unique grades e.g. exam 1 has A to F grade...

yeah its working thank you

hi all, I have some values between 1 and 12 in col A. these are month numbers. now i want a format which will convert each month by its name, like 1 show Jan, 2 - Feb and so on. I use custom formatting as MMM but all values shows JAN only. how can it possible?

I have a chart in which data table is shown at the bottom but i want to show it on top, how will it possible?

Dear All, I have an Excel sheet, I want to link this sheet to PowerPoint, when I update the data in excel sheet, the chart automatically update in PPT, how can I link this excel sheet with PPT.

Waht is value() function in excel and how do we use it ?

No need to post data here, sir this formula is perfect. Thank you Narayan.

Yes sir, The nimbus field is only for REF products And this forumula is also perfect. It return exact results. Thank you Narayan. :)

@NARAYANK991 Dear Sir, this formula is perfect, but here is a little problem, I specify the conditions again:- if Aging is 1 Year then all products are In Warranty, If Aging is 2 Year - 3 Year then MNT and those REF which are nimbus are in warranty and all other Out of Warranty and if aging is...

Catch me if you can ..

A B C D Aging PDT Nimbus Wty Status 1 Year Audio N 2 Year REF N 1 Year MNT N 2 Year REF Y 1 Year RAC N 3 Year LTV N 4 Year PTV N 5 Year WM N I want the result in D colum, conditions are as below:- For aging 1 Year - All Products In Wty For aging 2 Year-3 Year - MNT and REF...

Hi all, I have a database, screen shot is below- A B C D 1 Aging PDT Nimbus Wty Status 2 1 Year Audio N 3 2 Year REF N 4 1 Year MNT N 5 2 Year REF Y 6 1 Year RAC N 7 3 Year LTV N 8 4 Year PTV N 9 5 Year WM N I want the result in D colum, conditions are as below:- For aging...