|
|
Break Calculation by
om
Start Time End Time TimeTaken ActualTime Break Start Break End Total Break
14:33:49 14:34:12 00:00:23 X 14:33:51 14:33:54 0:00:03
14:36:07 ...
|
|
1 |
158 |
|
|
Need Help with Percentrank formula by
Dan D[_2_]
I'm looking at 100 companies and have their p/e ratios in column B. I want
to identify the percentile of each p/e ratio in the group and extract the
bottom...
|
|
1 |
109 |
|
|
Using INDIRECT within functions by
Brian
I learned a bit from JLathman in a previous post but tried to use the same
methodology with this formula (also learned from this Group to get the last...
|
|
4 |
112 |
|
|
|
January 2nd, 2010 02:25 AM
by Brian
|
2 |
120 |
|
|
Smallest to Largest by
JJ
I have column A ranging from (Seq)1 - 30 with numerica value. Column B with
(Description)Text names. The data is to be linked so that whenever the seq...
|
January 2nd, 2010 02:16 AM
by JLatham
|
2 |
103 |
|
|
|
|
4 |
136 |
|
|
one cell in a row contains a number by
Chris
I have a fixed row of 7 cells, any one of which might contain a number. the
cell with the number is the relevant one and it will determine my formula; i
will...
|
|
8 |
110 |
|
|
Office 2010 beta exel by
John Duffield
The data refresh is causing a not responding message. Exel closing down.
There are 40 web links
It is a 2007 spreadsheet
Created 4 new links in clean sheet...
|
|
1 |
107 |
|
|
SUM and Frequency for Multiple SHeets by
BobbyRT
Hi....in sheet 1, I have a column that has unique numbers and using the
following formula to lookup the field in sheet 46500! Column H and then count
the...
|
|
3 |
118 |
|
|
remove columns which show "0" as sum by
hsg
My data has following structu
A09 (code) and B09(time) are headings of a table, its data is filled from
A10 upto B100 or so. A column contains codes which...
|
January 1st, 2010 05:37 PM
by hsg
|
3 |
132 |
|
|
Exclude Hidden Row Values by
Dewayne
Is there a way to exclude counting values in a total when rows are hidden and
including them when they are not hidden in a COUNT, COUNTIF, and COUNTA...
|
|
4 |
137 |
|
|
Fill date series in table by
Sunday School Secretary
I have an attendance sheet that 1 day per week. I want to extend a series
across the top row. (I.E. Jan 1, Jan 8, Jan 15, Jan 22, etc.). The sheets are...
|
|
2 |
91 |
|
|
Round Up and Round Down Time by
DaveMoore
Good Morning & a Happy New Year to all subscribers in this group.
I want to round up Start times and round down Finish times to the next
or previous 15...
|
|
2 |
104 |
|
|
Calling name of Sheet as a Variable? by
thekeytothedoor
I'm working on a home budget, and I've made 26 sheets (labeled 1-26, aptly).
Each of the sheets calls the previous information from the other sheets, and
if...
|
|
1 |
131 |
|
|
Return data from catagory by
dadtofive
Worksheet #1 - Standing Database of inventory
Column A = Kool, Marlboro, Newport, Snickers, M&M, Miller, Bud, Labatts
(Actual data is product number)
Column...
|
|
2 |
95 |
|
|
|
January 1st, 2010 02:18 AM
by JLatham
|
2 |
135 |
|
|
|
|
2 |
284 |
|
|
Logical Test: Text Against Number by
rslaughter5
Can someone provide some insight into why Excel will always return TRUE when,
for example, we have ="a"27 (or any other number) and FALSE when ="a"27?
( 1 2)
|
|
17 |
404 |
|
|
Vlookup by
LWilson
Is it possible to have a sum in a Vlookup?
( 1 2 3)
|
December 31st, 2009 10:30 PM
by T. Valko
|
20 |
383 |
|
|
|
|
3 |
219 |