OK, I know the limit of 7 nested ifs, and the vlookup function. But what I
am try to do is the following:

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()


I have about 200 files that have a spreadsheet of active jobs (each job

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()

Hi,
in my book i have a cell with data validation set up to collect data from a

software 發表在 痞客邦 留言(0) 人氣()

Hello,
I have been trying to figure out how to use the Static Data Consolidation

software 發表在 痞客邦 留言(0) 人氣()

What would the function (if any) be to calculate the number of weeks between
two dates.

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()

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

software 發表在 痞客邦 留言(0) 人氣()