|
|
RAND() by
Charles W
I have posted this question in the wrong place, so here I am again.
I want to generate a random number using RAND() in a cell.
But the number generated by...
|
|
9 |
223 |
|
|
|
April 23rd, 2009 09:29 PM
by PattiP
|
1 |
93 |
|
|
index and match on 2 criteria by
Picman
I have a table that i want to extract data from one column based on 2
conditions in other columns. The table has 4 columns, the first and second
are the...
|
April 23rd, 2009 09:08 PM
by Picman
|
7 |
80 |
|
|
|
|
3 |
76 |
|
|
Top 25 List of Times by
thscc1659
I have a spreadsheet with the times run by individuals over a 3 year span.
I've been able to create a Top 25 list out of those times, but am having
trouble...
|
|
1 |
80 |
|
|
Lookup Question by
Harlan
I'm creating a workbook with multiple sheets, that is to be semi-interactive.
I have one sheet (CurrentYear) where I enter all of my information (P & L...
|
April 23rd, 2009 07:57 PM
by Harlan
|
1 |
87 |
|
|
RANK ABSOLUTE NUMBER AND WITHOUT GAP by
M&M[_3_]
The value that I need to rank include positive and negative number. I need
to treat them all absolute value and also need to rank without gap.
VALUE RANK...
|
|
3 |
80 |
|
|
If formula by
Terrie Vargas
I have a project where I am having to report the number of lines, the total
amount and the % based on 5 other criteria...
Legend: ...
|
|
0 |
87 |
|
|
Duplex Printing Macro by
[email protected]
I have created and set up a number of daily reports that mulitple
users can generate from multiple work stations.
All of the work stations are on the network,...
|
|
0 |
89 |
|
|
Data Sort header row by
inungh
I would like to have default Header Row checked when I click on Data
Sort.
Are there any option to set it?
I got randomly sometimes checked Header Row, but...
|
April 23rd, 2009 07:21 PM
by Sheeloo
|
1 |
101 |
|
|
Problem with Vlookup by
Confused
I am using Vlookup to find names in one file and replace it with emails from
another. The two names exist in both files but i get all #N/A . How can I...
( 1 2)
|
|
10 |
122 |
|
|
|
|
8 |
101 |
|
|
If - Then statement by
Neall
I have a drop menu with part numbers, which I pull from another sheet, there
are descriptions associated to those part numbers.
What I want to do is on the...
|
April 23rd, 2009 06:51 PM
by Neall
|
3 |
63 |
|
|
first and last occurance by
Darius
in range a2:a3500 how to find the row number of first cell which its content
value is less than 0.0 and last value which is less than 0.0?
They can be set in...
|
April 23rd, 2009 06:49 PM
by Darius
|
7 |
70 |
|
|
Transfer Information by
Lois
hi
i have 2 worksheets, when a new row of information is added to 1 worksheet,
some of the details need to be transfered unto the next blank row of other. ...
|
|
4 |
74 |
|
|
Average function by
Harriet
I am trying to create a daily average in a spreadsheet. Here is my situation.
I have a row of sums of columns that I want to average. Data is filled into...
|
|
5 |
106 |
|
|
|
|
3 |
120 |
|
|
Formula for Multiple Variables. by
Sri Harsha[_2_]
Hi,
I am preparing an estimation template. I have a source tables which have the
estimated hours of effort and a table which gives options to select the...
|
|
1 |
71 |
|
|
SUMIF, wrong result, strange behaviour by
Werner Rohrmoser
Hi,
I have a found something strange, which I do not understand.
Formula in A1: =SUMIF(D1:D3,C1,E1:E3)
value in C1: 02016521000513438888 formatted as...
|
|
5 |
84 |
|
|
Converting decimals to Time by
Gringarlow
My data for work time is
1.1
1.017
etc...
I need to convert this to
1:06
1:01
etc..
and have this data be used in a Pivot Table that shows the average time of...
|
|
4 |
87 |