I have data in cells that contains date and time information as text. It is in the same format as below. 01 Sep 2003 10:16:53:000 How do I separate the date...

How do I make the numerical value of column "a" postive or negative based on the text value of column "b" For example: $126,513.00...

Ok, i need some help. I have two columns of data. For one of the columns, i need to find out if its contained somewhere, anywhere in the other column. So...

Apologies - i've tried finding the answer to this in an already posted question, but i'm struggling. I have a code in column A and a date in column G. There...

Can the below actually be done? If so, am i just writing it incorrectly as it doesn't seem to like...

I have a column of dates (in calendar order3/1/08, 3/2/08, 3/3/08,etc...) and a column of corresponding $ amounts next to each date. I need to be able to...

I have a few thousand rows Of data, each row has 1-7 outputs in the adjacent columns. There are 27 different types of outputs. Lets just say A- Z, the...

i want to setup some sort of formula to search a column for specific keywords (multiple keywords as well) and return a value from an adjacent column...

I have identical worksheets that I create every week. The only thing I change is the backup data (weekly data). Then I open up last weeks worksheet and...

Hey I've been using the proper function this morning and its not working for some reason. Cell B3 contains the word: MISS I want cell C3 to contain the...

I have a column that contains lots of post codes. E.g EH48 3SS EH48 3HU EH52 6PQ EH48 3OP EH48 3ER EH52 6XW

Is it possible to have 2 validation list dependent upon the entry of another cell? Example A1 =Cat or Dog Validation list= B1:B10 A1=Car or Truck Validation...

I'm using Excel 2000 and when I press the Ctrl+F keys and bring up the find window, I can't type in the actual document while it's open. I seem to recall...

Hey there, I have worksheet (Worksheet 1) that I am pulling in data from specific cells in another workbook worksheet (Worksheet 2). I want my formula to pull...

every day we record the product name, quantity and the date, how to make lookup or vlookup (or any other function) find the first date and the last date for...

Does anyone know of an add-in that allows you to lock and unlock multiple worksheets at one time?

I have a list of vendors that are associated with a job. On another spreadsheet I have that list of vendors all with their vendor number going from 1 and...

Hi I've been working on the formula below but I can't get it to work: =IF(J10="Yes","(NETWORKDAYS(B10)+5)","N/A") Cell J10 is in my "Response Required?"...

I've just been speaking to our IT helpdesk and they said my request was too hard and would take 5 hours to work out. I'm not so sure so I'll run it past this...

I have two large columns of data, one with numbers and the other is verbal. I need to write a code in a specific cell that will SUM of a group of those...