OK, I know the limit of 7 nested ifs, and the vlookup function. But what I
am try to do is the following:
- Oct 22 Sun 2006 20:09
Nested ifs and conditional population
- Oct 22 Sun 2006 20:09
Is there a function like quot;Data Tablequot; for multiple Inputs
I have a model that takes a whole range of inputs to give you a final
amount you can borrow. I would like to use something like the
- Oct 22 Sun 2006 20:09
Vlookup maybe???
- Oct 22 Sun 2006 20:09
can a cell value to be duplicated to another cell during data entr
we need that users will enter same exact values in 2 different colums. the
reson being is that the spreadsheet data is uploaded to DB. later on a
- Oct 22 Sun 2006 20:09
Data Validation range
Hi,
in my book i have a cell with data validation set up to collect data from a
- Oct 22 Sun 2006 20:09
static data consolidation
Hello,
I have been trying to figure out how to use the Static Data Consolidation
- Oct 22 Sun 2006 20:09
Function to calculate the nuber of weeks between dates?
What would the function (if any) be to calculate the number of weeks between
two dates.
- Oct 22 Sun 2006 20:09
Insert Subtotal button
I use the subtotal(9,..) function quite a lot and want to add a toolbar
button to make it easier to use. I've tried various macros etc to do this
- Oct 22 Sun 2006 20:09
Macro to highlight cells based on content
I have a spreadsheet generated by an Access query being exported. It lists
names down the first column, then has 5 columns, some cells in these columns
- Oct 22 Sun 2006 20:09
concatening in excel/programming
Can anyone help me rework this code. What I need is the code to call four
columns. First is a name column. Then a space then 3 numbers separated by