I received a file with dates formatted using dd/mm/yy hh:mm and I want to graph how many times a certain event occurs per date based on dd/mm/yy. I tried...

I just began using Excel at my office don't have much knowledge of the program. I am trying to create a spreadsheet and the first column needs to be name...

I think I'm having problems using IF(AND in an array formula. I've put together the following formula, which I've gotten help with already from this...

Is there anyway to add a search box to an excel sheet,, similar to "find and replace" pop up search box Regards

when i copy a v-lookup formula in a col I am getting the value which it returned in the 1st cell throughout the col. Unless I am manually get into the cell...

Hello! How to name many rows by values in a column on the same sheet all at once? Regards, Dmitry

Hello! I need to know if there is a way to lock the properties or the values of some rows or columns from editing ? Like the freezed panes if any, user...

I cant get the 'fill colour' to work - any ideas?

Hello, I have a table in worksheet 1 with Product Codes in every other column (A, C, E, etc) and data related to those Product Codes residing in the adjacent...

Hello. I have a worksheet that imports external data from a MS Access database using paramaters. I have it set up to prompt the user for the starting date...

How do I calculate the number of pay periods between two dates, if a person is paid on the 1st and 15th of every month?

i.e., when I highlight cells to format, the color in these cells is barely visible, which makes confirming the cells I want to format extremely difficult. ...

I've got a 3 column list of over 100 contacts looking like this: Jim Sullivan XYZ Company 1400 Penn Ave Great Lakes, IL 60666 (555) 123-4567; Fax: (555)...

Hello I formated a cell , MMMM-YYYY. I would like this cell to always have the previous month. in Excel 2002. THanks in advance

I inserted an Excel table as an object into Word 2007. When saved as a pdf all the e-mail links are corrupted, showing 'funnies' before and after the actual...

Hi experts, I'm trying to create a summary that changes the links to external workbooks dynamically based on the selection of data validation lists. The...

I usually have the screen zoom % at 100%. You would assume that what shows on the screen would equal what would print. However, it appears that the cell...

Hoping someone can help me with this. I have a list of 160 addresses and columns that represent occurance of issues at these addresses. I want to create a...

I just got a new computer and when I opened excel all my keyboard functions are messed up. I have tried to fix but I have not had any luck. If I use my tab...

I have to use an hours:minutes column from a Kronos payroll report(exported to Excel) in the following...