RANDBETWEEN
Tue, 26 Aug 2008 16:16:20 -0600
Hi All,
If I use RANDBETWEEN function to generate random samples, how do I make sure
that units are not repeate?
For example-
I have 1000 units and I have to generate 30 samples. I will use
RANDBETWEEN(1,30) in 30 cells. How do I make sure that the numbers are not
repeated and all the samples are uniq ...
|
please advise the solution
Tue, 26 Aug 2008 15:07:15 -0700 (PDT)
Hi,
Please could any one suggest how to do the following in excel sheet,
I have two numbers in excel spread sheet
1 is target price
and
2 in cost,
Now I would like to show it in RED COLOUR if target price is become
less than cost.
Thanks, ...
|
Beginning of Year
Tue, 26 Aug 2008 14:53:04 -0700
I'm nowhere near the technical level as most of you on this site, so I'm
hoping you can help me out.
Isn't there a formula you can enter in Excel that will return the first
calendar year of a year? ...
|
Help on formula for autosum on 2 criteria in 2 ranges
Tue, 26 Aug 2008 14:44:17 -0700
I need to get a sum from 2 different criteria in 2 different ranges.
PLace Type $$
a 1 3.00
a 2 5.00
b 1
c 1
d 1
My end result would be for all "a" in Place column and all "1" in Type
column then auto sum of Column $$
((Range,critera) and (range crite ...
|
working around blank value in IF statements
Tue, 26 Aug 2008 14:32:05 -0700
I have the below formula to calulate benefit increases depending on various
plan dates. It's working perfectly for what I need except that in some
instances there will be no value in cell B3 (a date). I need to figure out
how to rework things so that if B3 is blank the calculations in my IF
statements will s ...
|
Copy a formula to the right increasing the rows from another works
Tue, 26 Aug 2008 14:32:01 -0700
I posted this question this morning, but I did not get a resolve.
Maybe this is a little more clear.
I have two worksheets within my file
Worksheet called "Call List" and another called "Div 6"
Within the Div 6 worksheet I have a formula in cell (G7) which copies
information I already input from cell E8 ...
|
Drop Down List
Tue, 26 Aug 2008 14:30:01 -0700
I have one sheet for data entry where entries include names and dates among
other things. I want to create a second sheet that will search through the
first list and list and return a list with only the date selected in a
drop-down list. An individual could then select a date and see all entries
with that da ...
|
|
|
Variable Range for NPV
Tue, 26 Aug 2008 14:01:01 -0700
I need to calculate an NPV that could start in any given year and end in a
later given year to provide a stream of income.
For example - I have a 30 years for this case. Income will start in year 16
and end in year 30. For a level $100,000 of income in the income period at
10% at beginning of year, I get $ ...
|
Need ideas on which formula(s) to use in this situation
Tue, 26 Aug 2008 16:59:22 -0400
I have a worksheet with a lot of raw data. In one column I have an
identifier, in another I have dates, and in another column I have values.
I need to build a summary table on a new worksheet that will (given a date
and identifier) return the max value. I know MAX will get me the max value
overall, but not ...
|
Moving / Emailing Macro Workbooks with Custom Toolbars
Tue, 26 Aug 2008 13:55:05 -0700
Hi Everyone,
I'm going crazy so I was hoping someone could help me. I have an excel
workbook with macros in it and also a custom toolbar. If I move the workbook
from my desktop to a folder, or if I email the file, the toolbar icons stop
linking back to the macros. It just displays a message saying that y ...
|
