|
|
Extracting Data by
Don Guillett
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...
|
|
0 |
143 |
|
|
Calculate age by
MarkN
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....
|
July 18th, 2009 01:50 PM
by rh33a
|
5 |
69 |
|
|
Index lookup with multiple match criteria by
Vance K[_2_]
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...
|
July 18th, 2009 07:08 AM
by haffa
|
5 |
161 |
|
|
Time and Date populates automatically by
newbie_010108[_2_]
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...
|
|
4 |
100 |
|
|
|
|
2 |
79 |
|
|
|
|
4 |
110 |
|
|
If Formula When Contains Partial Word by
zeetoe04
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...
|
|
5 |
104 |
|
|
insert by
Rajat Soni
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...
|
|
3 |
143 |
|
|
Calculation automatically by
capricorngirlone
How do I set up a calculation for spreadshheet? I handle vacation, sick,
accrued leave for the entire office.
|
|
2 |
67 |
|
|
|
|
2 |
80 |
|
|
Lock Unlock Cell Protection by
Mike Josephson
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...
|
|
3 |
105 |
|
|
vlookups by
lfrick
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...
|
|
3 |
86 |
|
|
Using SUMIF with a drop down. by
Steve
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...
|
July 17th, 2009 10:03 PM
by Steve
|
3 |
71 |
|
|
Define a generic name by
Nelson
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...
|
|
3 |
94 |
|
|
|
|
6 |
100 |
|
|
|
July 17th, 2009 06:44 PM
by Help007
|
0 |
88 |
|
|
|
|
5 |
116 |
|
|
|
|
2 |
113 |
|
|
|
|
2 |
104 |
|
|
How to do a lookup using multiple values by
jose123
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...
|
|
5 |
105 |