Hello everyone,...I'm a newbie in using excel,..plis be kind to teach me something bout excel. thanks

I have a unlocked cell, with Data Validation, List. With sheet protection activated I cannot "add" to the cell contents supplied from the List function. If...

I can't open my orginal worksheet with data.It has been lost and showw message "Excel recovered your formulas and cell values, but some data may have been...

Hello, can someone help me with Vlookup please ? I have a large table with dates (decreasing monthly) in column A, and debt (also decreasing) in column F. I...

Not exactly new to Excel but since retiring 5 yrs ago everything I knew (which wasn't much) has gone out the back door. I have researched this site and seen...

Good day... Im just new in using ms excel 2007. Please help me this scenario. How to get the min and the max in this table base on the names on column A and...

Hi, Can I filter cell that have only 0-9 number in it? I mean that I have 1 column like below: samsung samsung galaxy s2 samsung galaxy samsung galaxy tab

With reference to my previous question regarding a line on the top of text. How can I create an overline font which is similar to the underline font, except...

http://img.photobucket.com/albums/v214/Goatseking/excelquestion.jpg I'm trying to make this Excel document but I want the AdminTimes for the same LastRxNo to...

I'm not sure which function(s) to use to accomplish this. Column A has a checkbox that indicates this line is included Column B has a checkbox that indicates a...

Hi, I have created a 2010 macro enabled excel. I want the cells once entered to be uneditable. Only administrator should be able to change the values in the...

Dear all users I have a table with results of race data, 1st, 2nd and 3rd from several races, from several meetings. I have used the MODE formula to...

I have a worksheet calcuating some results driven by different parameters. Is there a way I can tabulated (probably in a separate worksheet) the different...

I have data in columns A through to J (i.e. 10 columns) and rows 1 to 400. So there is a huge block of data. I need to purely move the data in columns B to J...

Hi, Folks, I wouldn't exactly say I'm NEW to Excel, as I used it in a past job, but I never quite got the hang of it. And with the changes to Office 2010,...

I'm trying to set up a calculator for the following information. Range Percent Per Point 1-100 = 0.10 101-500 ...

I must create a front page that when I choose type of product, it will send me to classification of product then to supplier. The report has to show which...

I am trying to password protect a column of single cells but it keeps protecting the whole work sheet can ant one help?

I have a data sheet with nearly 9000 "rows" of data. Those rows have 7 columns of data. The first column is last names. I need to keep the data in...

Hello, I have a complex workbook of which the first sheet is a large lookup table. It is accessed via 'VLOOKUP' from many parts of the workbook. 5 columns...