|
|
Add Seconds to Date - Time Field by
terminal euphoria
I have an Excel spreadsheet that provides a date/time field in one column and
a seconds field in another column. How can I combine the seconds to this...
|
|
2 |
105 |
|
|
vlookup by
Alexey[_2_]
Hi is it possible to have an AND statement in a vlookup when comparing data.
For example:
VLOOKUP($A29,Sheet2'!$D$4:$E$1045,2,0) will look up where the $A29...
|
|
1 |
101 |
|
|
Lookup function-text by
T.Mad
Hi there
I have a query about the lookup function.
In one column there are registered the names of some people and in a second
column there are registered the...
|
September 19th, 2008 01:23 PM
by T.Mad
|
2 |
122 |
|
|
|
|
0 |
237 |
|
|
need help with conditional data by
Alok
I have two worksheets. Worksheet A has item names and company names. Item
names are unique, but not company names.
In worksheet B, I want to select a company...
|
|
1 |
193 |
|
|
|
|
2 |
233 |
|
|
notify of entered criteria by
Ken
I have list of criteria “E104, E105, E107, E123, E124, E127, E131, E142,
E952, E1510, ALCOHOL”
The criteria is listed in "A1" How do I get my spreadsheet...
|
September 19th, 2008 09:25 AM
by Ken
|
2 |
122 |
|
|
|
|
2 |
167 |
|
|
Find total number of unique model numbers by
Brian[_16_]
Howdy All,
I have a workbook that contains service data for units.
Column A = Model Name (alpha) 87 model names that repeat throughout the
column
Column B =...
|
September 19th, 2008 05:51 AM
by T. Valko
|
8 |
173 |
|
|
|
|
2 |
169 |
|
|
Rolling figure to a cell by
Brenton
I am trying to calculate a rolling figure to a cell by updating a spread
sheet on a weekly basis. I want to input data on a dated row and get the
formula to...
|
September 19th, 2008 05:36 AM
by Brenton
|
2 |
135 |
|
|
SUMIF with 2 creteria one Name one DAte by
Gary
rIn a previous post JMB said:
How many sales Brian had in January (2):
=SUMPRODUCT(--(A1:A5="Brian"),--(MONTH(B1:B5)=1))
I have a similar problem and have...
|
|
1 |
110 |
|
|
|
|
8 |
146 |
|
|
Match/Vlookup/Hlookup ? by
Daniel Q.
Not sure what formula to use when trying to match two criteria and having
them pinpoint a cell depending on teh criteria.
I need the formula to go out and...
|
|
3 |
153 |
|
|
Sum and skipping cells by
art
Hello all:
Is it possible to sum the cells by starting from A1 and add A10 then A20,
and so on every tenth cell. How do I write the formula for it?
|
|
2 |
125 |
|
|
Expire count down by
Sweetie
Hi guys/Gals
Im desperatly trying to work out how to put a countdown on a excel sheet for
things that are due to expire.
I have a hundred and one uses for...
|
September 19th, 2008 05:02 AM
by Sweetie
|
5 |
146 |
|
|
if and sum, 2nd try. by
Christy
This is what I have:
Col G Col H Col I
15 in v
20 ot v
30 in n
This is what I need to do:
When...
|
|
6 |
104 |
|
|
Formulas by
Matt
i am looking to get an average of a group of cells but I do not want the cell
with a 0 in to be included but the cells numbers will change when I reuse the...
|
|
4 |
116 |
|
|
greater then less then by
andrew
I am trying to do this.
I have 2 cells that contain curency values in each,
I want a 3rd cell to tell me which one is greater, I need the 3rd cell to
show...
|
September 19th, 2008 04:38 AM
by T. Valko
|
2 |
107 |
|
|
Forms-Scroll Bar function in Excel 2007 by
DB
I recently switched from 2003 to 2007 and cannot seem to find the function to
create scroll bars, check boxes, etc. in Excel 2007.
I'm sure the feature must...
|
September 19th, 2008 04:36 AM
by T. Valko
|
1 |
138 |