i have a question in my text book and i dont know how to do it.. exsample: in cells D2:G2, enter labels "bob", "kat", "greg", "doug"respectively... how do...

it asks to reate a CVP chart of sub-type "scatter with data points connected by lines without markers" enter "cost-volume-profit" as the chart title, enter"...

=TEXT(DATE(2009,4,1),"mmmm") doesn't work for different locales. This one is done for english based locale, but will not work for russian because format is...

I want a spread sheet to be scroll only up and down not left and right. Is it possible to do so and How??? Thank you

I need to work with two Excel books. The first MainBook consist of a list of products (different sheets with around 100 rows - the first column is the list of...

Sheet A contains a large (16000 rows, 8 columns) array of data and Sheet B a single column which lists certain text values also found in column 1 of Sheet A. ...

Hi, i have a worksheet, where Column A is formatted for mmm-yy What i would like to be able to do is to add a row at R3 and have Column A automatically...

Hi, I need to analyse some data that is held in an Access database, but I want to do this in Excel. I have the data in an Access Query. My data is about...

Hi Everyone I am trying to achieve the following Sheet 2 contains data imported from an Access Spreadsheet and I am trying to analyise this data on Sheet...

Can someone please explain if there is any difference in the terminology of a worksheet and a spreadsheets or is the latter simply a colloquial expression...

Hi I have three cells O28,O29,O30. In cell O27 I want to display the average of the other three cells, but only if they have values in them. Not sure how to...

Hi Can anyone advise if there is an easier and less complicated way to achieve the following...

Hi When i open a worksheet I am getting a Circular reference error The reference is on $s$6 and the forumula is: =IF(ISERROR(S6),0,SUM(R6/Q6)) Q6 contains the...

Hi I am analyising a lot of data. I am using: =SUMPRODUCT(--(TEXT(MISDATA!$G$3:$G$5000,"mmm-yy")=TEXT($A39,"mmm-yy")),--(MISDATA!$H$3:$H$5000="Paul...

Hi is it possible to have an AND statement in a vlookup when comparing data. For example: VLOOKUP($A29,Sheet2'!$D$4:$E$1045,2,0) will look up where the $A29...

Hi, I am playing with learning solver and using a test case that I found I think on the MS Site A company produces Radios, CD Players and Speakers. These...

Please help me to resolve circular reference calculation error A B C 1 vegetable 2 fruit ...

Help please. I have troubles with COUNTIF. I need to count rows with two criteria in different columns both are parts of text. For example: text1- “counting...

Is there a way to create a button in a cell that when clicked will activate a macro? Thanks

I have a small chart that needs to be copied and pasted for each day on which i take data and want to get averagees out of the progression of days, so...