|
|
Separating data in a cell by
Adam
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...
|
|
3 |
119 |
|
|
|
October 29th, 2007 08:13 PM
by Pete_UK
|
3 |
53 |
|
|
ISNA match function help by
Adam
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...
|
|
9 |
60 |
|
|
Matching columns and removing duplicates by
Adam
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...
( 1 2)
|
April 17th, 2008 10:09 AM
by Adam
|
10 |
159 |
|
|
Can/Should this work? by
Adam
Can the below actually be done? If so, am i just writing it incorrectly as
it doesn't seem to like...
|
|
1 |
102 |
|
|
Sumproduct on Dates? by
Adam
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...
|
|
2 |
110 |
|
|
Help with Countif by
Adam
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...
|
May 16th, 2008 09:52 PM
by Adam
|
2 |
76 |
|
|
|
|
2 |
98 |
|
|
Question about Comparing Data by
Adam
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...
|
|
1 |
77 |
|
|
Not Proper! by
Adam
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...
|
September 19th, 2007 12:08 PM
by Max
|
2 |
57 |
|
|
Post Code by
Adam
I have a column that contains lots of post codes.
E.g
EH48 3SS
EH48 3HU
EH52 6PQ
EH48 3OP
EH48 3ER
EH52 6XW
|
September 6th, 2007 04:12 PM
by Darrilyn
|
2 |
73 |
|
|
Data Validation List by
Adam
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...
|
February 12th, 2004 11:06 PM
by Adam
|
3 |
242 |
|
|
Can't type while Find Window is open! by
ADAM
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...
|
|
1 |
304 |
|
|
Formuls updating by
Adam
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...
|
October 19th, 2005 07:49 PM
by Adam
|
2 |
85 |
|
|
how to find last value by
adam
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...
|
|
6 |
98 |
|
|
|
October 31st, 2007 05:31 PM
by RL
|
6 |
65 |
|
|
row lookup formula by
adam
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...
|
July 12th, 2007 10:52 PM
by adam
|
7 |
55 |
|
|
IF Function & Nework Days by
Adam
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?"...
|
July 13th, 2007 12:12 PM
by Mike H
|
3 |
60 |
|
|
IF by
Adam
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...
|
July 23rd, 2007 12:24 PM
by Mike H
|
3 |
68 |
|
|
Expansion of COUNT if Question by
Adam
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...
|
July 23rd, 2008 06:25 PM
by PCLIVE
|
1 |
54 |