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

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

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

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

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 ?

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