|
|
if statement, change cell only if true by
laavista
I know there has to be a simple solution, but I can't find it
Sheet1 has values in column A. Col A is formatted as text and contains
either an
ID...
|
|
4 |
150 |
|
|
|
April 29th, 2010 04:04 PM
by Mike H
|
5 |
148 |
|
|
Imperial Weights in Excel by
andrew.ford.af
How do you use Imperial Weights in Excel, to allow formula for adding up
weights to use in pie charts etc. imperial weight measuring in stones. pounds
and...
|
|
1 |
152 |
|
|
sumif formula by
Vince
I have a summary sheet and a detail sheet. On the summary sheet I am trying
to sum columns (E - O) from the detail sheet that are less than or equal to a
...
|
|
2 |
166 |
|
|
|
|
1 |
191 |
|
|
problem with lookup function by
lampatmyfeet
I have a problem with summing a lookup function
My data looks like this:
A1: text B1: time C1: time D1: time E1: time
A1 = could be any of 8 different...
|
|
2 |
187 |
|
|
Record time by formula by
karim
hi,
i want to create excel sheet wherein time has to be recorded multiple time.
Now() formula does not help and i don't want to use macro.
Pls Suggest
( 1 2)
|
|
10 |
294 |
|
|
|
April 29th, 2010 12:54 PM
by Eduardo
|
3 |
170 |
|
|
Counting Characters In A String by
fabio
Hi
I am trying to manipulate some data strings and I want to count how many
times the characters '(' and ')' occur in each of the data strings on my...
|
April 29th, 2010 11:01 AM
by fabio
|
2 |
155 |
|
|
|
April 29th, 2010 10:41 AM
by CW
|
8 |
278 |
|
|
|
|
1 |
153 |
|
|
Sorting a portion of a worksheet by
NicoleS
*Using Office 2007*
I am using the sort function to organize a list by date and anniversary
year. That works well.
Then I insert blank lines (for...
|
|
1 |
127 |
|
|
Slope??? help please!!! by
beto
------ I have 4 columns : ---------
COLUMN A: Dates (ex. 1/15/2009)
COLUMN B: Time (ex. 1:35:24 AM)
COLUMN C: Dates and Time added and shown in the format...
|
|
1 |
122 |
|
|
Advanced Data Filter by
Asad
How can I generate a count number series on entries recurring on my
worksheet; e.g i have a data sheet with the following data appearing
x
x
x
a
a
g
g
|
|
1 |
125 |
|
|
|
|
6 |
277 |
|
|
Index Match Problem by
jeikenberry
I'm using the following formula, but it's returning #N/A:
=INDEX('File X'!$F$1:$F$2000,MATCH(1,($B5='File X'!$A$1:$A$2000)*(S$4='File...
|
|
3 |
139 |
|
|
Which (logical) function? by
JustJill
Table was codes...if the ID begins with a w and the number in the second
column is a 1 add the ones (which are male ;)
A B
1 ID ...
|
|
3 |
145 |
|
|
formula help by
Jeff Brown[_2_]
I have a formula and can not make it work the way I would like.
=IF(H5="P",G5+12-F5,IF(H5="A",G5-F5,(I5/24)))) here it is.
I need it to subtract .50 from I5...
|
|
4 |
147 |
|
|
How to remove a bunch of zero's by
daisy
Can anyone help me with a function that I could apply to my spreadsheet? I
have 10 columns and hundreds of rows coming over from another application and
now...
|
|
4 |
144 |
|
|
Running calculation of a frequency by
Marcia
Hi,
On a monthly basis I need to calculate a running frequency of scores, but
I'm not sure how to do it. For example, Joe receives 3 scores (based on a 1
to...
|
|
1 |
136 |