|
|
|
January 14th, 2010 07:38 PM
by Roy
|
0 |
106 |
|
|
|
|
4 |
123 |
|
|
Random Numbers by
John Pivot Table
Hey!
A question about random numbers in excel. I have a huge list of people and I
need to assign to each one a random number between 0.0 and 1.25.
The...
|
|
2 |
102 |
|
|
Turning numbers into Dates by
Kbass
I would like to know how to turn a number such as "51319" into a date such as
"5/13/19". As of now, when I try to format the cell to a date format, it...
|
|
4 |
97 |
|
|
IF Statement with Dates & Calculations by
Diane
I am trying to create a formula that looks at two dates, and based on the
results places either a the calculation of number of days between the two
dates,...
|
January 14th, 2010 07:14 PM
by CLR
|
5 |
99 |
|
|
|
|
1 |
141 |
|
|
|
January 14th, 2010 07:00 PM
by Luke M
|
2 |
95 |
|
|
Code to Unhide Rows using Macro by
Rajat
I’m using Excel 2003, what I intended to accomplish to create a macro to
unhide row (By default few rows will be hidden) based on the drop down list
value...
|
|
7 |
84 |
|
|
Using VLOOKUP wrong? by
Destrachan
Hey all, I've got 2 columns "A" has names & "B" has percentages. I've
been able to use the VLOOKUP function w/in the same workbook as the
data with success,...
|
|
0 |
88 |
|
|
Need a function by
Alma Brumley
Can anyone help me with this??? Is there a function that can identify if a
person (name) is found in one of 4 worksheets.
--
Alma Brumley
|
|
2 |
119 |
|
|
|
January 14th, 2010 06:15 PM
by Eduardo
|
1 |
89 |
|
|
excel problem by
bill boch
hello
I have company #'s in column C ...the invoice amts are in column P & Q...I would like ...if there are 2 invoices i would like the invoice total of "P"...
|
January 14th, 2010 06:01 PM
by CLR
|
1 |
88 |
|
|
|
|
2 |
77 |
|
|
Calculate hours, past midnight etc by
CindyJ
Need help on formula calculating start time, end time, start time, end time -
with hours past midnight. What I have so far:
C3 D3 ...
|
|
4 |
102 |
|
|
Worksheet to Worksheet skip blanks by
Treadstone
I am trying to copy data from cells to another worksheet missing out blanks -
typically sheet 1 has data say in B1 D1 & F1 trying to get the data to sheet
2...
|
|
3 |
96 |
|
|
|
January 14th, 2010 05:14 PM
by Luke M
|
3 |
95 |
|
|
Spin Box Date and Sumproduct by
JPDS
Is it possible to use a date (created via an INDEX calculation) within a
SUMPRODUCT calculation?
I use a SUMPRODUCT calculation to generate headcount figures...
|
January 14th, 2010 05:05 PM
by JPDS
|
3 |
72 |
|
|
|
January 14th, 2010 04:59 PM
by Pierre
|
3 |
116 |
|
|
|
January 14th, 2010 04:46 PM
by Luke M
|
1 |
105 |
|
|
|
|
3 |
109 |