Hello all First time poster, so I apologize for any formatting issues. I am working on an assignment, and am posting here because I couldnt make it to class...

hello i have the following text in cell A2 123456 batman £15000.00 i would like to be able to coy just the £ amounts in to cell D2. could anyone please...

hello I am trying to highlight an entire row (e1-e5) if E5 if over £9999.99. i need the whole row to be highlighted in red is this possible?? im using Excel...

Hey, Im trying to work out what clothes I need for the works. I need to find out how how many of size and type of clothes I need. Eg; Nick: Jacket Size:L...

Hi, I am trying to match a portion of the text in a given array and return the corresponding complete value of the array. Example: A ...

I have multiple worksheets within the workbook. There are tab 1,2, 3, etc. Each tab represent days of month(May). I have a rep stats summary tab to sum up by...

I'm coming up with the error message below, does anyone know what it means: 'An unexpected error has been detected Description is:0, Subscript out of...

I am a novice any and all help will be greatly appreciated! I need to provide a list of valid usernames for cell #1, then have the user enter their password in...

So I am trying to complete this project and I have a question with using SUMPRODUCT and dropping the lowest test score. This is the formula I am...

My worksheet has a column#3 of the number of days, produced by subtracting date in column1 from date in column2. Some on this forum helped me with getting...

I need to determine the # of days from several dates for about 2 years past until, say May 1, 2013. In Column 1 I have 5/1/2013 for about 31 rows, and in...

Hi, I need to cope a large range of multiple cells easy. I think copying by color is one easy way. (I am going to make a template of the workbook, and using...

Hello, I am trying to create a macro to run on all worksheets within a tab. So far it is only running on one worksheet and it does not work on other. Can...

How can I type in a certain number in one cell and it comes out with the list of numbers? For example if I input a number "10", it automatically shows a list...

I did a couple of searches but couldn't find what I wanted. Here is the question: I have a worksheet for orders. What formula do I need to populate Name,...

Hi, If anyone can help it would be much appreciated, I'm creating an A3 report for a presentation. Because the data tables that need to be one the A3 are so...

Hi All, I want to have two formula in one cell. Let me explain. I have four cells that I need to input a "Y" or "N" into them. They need to be in order for...

I have a list of about 50 different products that I want to compare different vendor's costs. There are about five vendors total.

Hello Everyone, My name is Michael and I am new to the forum. I know how to do simple this with excel but I see that there is a lot more for me to learn. I...

Hi, I want to find the difference in date from the below dates in the form yyyy-mm-dd Eg: Start date = 1980-02-22 End date = 1966-11-29