I have a series of columns that represent candidates 'x' values for a
regression.
I'd like to be able to create a very simple way of running linest scenarios
on each independent permutation w/o having to rearrange all of the columns a
bunch of different times.
Example:
Column A-J are the candi
I'm trying to utilize a series of data to execute multiple Linests.
I have 10 columns of data of equal length.
The first 9 columns represent 'x-value' candidates
The 10th column represents 'y-value'
I'd like to create linests that utilize each potential unique
variation of each of the first 9 col
I found a subroutine that creates random samples from a data set.
Trying to utilize within another subroutine, but I'm getting a syntax error.
Sub Seer is the main routine; Sampling is the routine I'm trying to call.
Advice appreciated.
Sub Seer()
Dim Ndays As Integer
Dim Sdays As Integer
Nday
I have a pivot table with a large number of filters - let's say 10.
In many situations, combinations of filters results in no data.
Is there a way that when one or more of the filters are set, the other
filter options are limited to choices (including ALL) where data would
exist?
--
--
Thank you - I will. Funny i didn't see this earlier, I've spent about 3 days
looking around for examples.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitte
By the way - I need to be able to accomplish this using VBA - I don't want
to do it directly in the pivot table because I'm locking that down from a
sales organization that doesn't have a very high degree of 'Excel' skills.
--
