Or, for JUST the number =IF(ISERROR(SEARCH("upc",H5)),"",MID(H5,SEARCH("upc",H5)+4,FIND(" ",H5,SEARCH("upc",H5)-1))) -- Don Guillett Microsoft MVP...

Hello, I am looking for a formula that will calculate how old a person is in years and months, with months being rounded up to the nearest complete month....

I have two tables. one that is inventory related and another that is forecast related. I need to tie the inventory data to the forecast data. The issue I...

Hi, how can i make col m autopopulates with a date and time whenever col k is populated with info and col N populates date and time whenever col L has an...

I don't know how to delete cells without loosing info in cells I've concatenanted. Does anyone know?

Setting up a time sheet

Hi everyone, I'm trying to link these two sheets together as far as making them easier to integrate. I have this main sheet thats full of every group that...

hello all I have a column full of data now I want to insert two blank cells in my column below each cell so that I have two blank cells below every filled...

How do I set up a calculation for spreadshheet? I handle vacation, sick, accrued leave for the entire office.

I am populating value from another worksheet in form format using following formula in a cell, let us say in A5 of current worksheet. =Data!E1 Now I want...

I have a spreadsheet that has a range A5:H30 being used as a list of product numbers entered in Column A (A5:A30) and a vlookup in the remainder range b5:h30...

I am new to excel 2007. I am taking it on live through a local college. Any way, I am try to put it a range...

Hi, I think I put tis in the wrong area before. Is it possible to use a value from a pull down in a SUMIF...

I have created a template which will be used to create customer profiles problem here is I want to use names (example Cells A1:A100 = date) without...

I am using an index match formula to evaluate items on a summary sheet based on data input on other sheets. I am then desiring to create conditional cell...

Hi, I understand the tracking functionality within Excel, however unfortunately it does not track any changes that occurs due to data in a linked spreadsheet...

My workbook is set up as...

The formula will only update when i hit the same button - have checked "options" within "Tools" but everything seems ok - any ideas? thanks

OK, my bad. I have an excel 2003 spreadsheet that I protected some of the content within. I forgot the password - how do I copy and paste the tab or...

In my template I have the following information. I'd like to get the data out of the template and into a workbook of its own. What would be the best...