limitations

I have never used access, but just started to investigate the limitations for a potential project. My data sets will have approximately 13 million fields quarterly, and I will eventually need 60 quarters worth of data. That's around 260 million data points. Nearest I can figure, it's about...

So I have a really tough issue that I can't seem to wrap my head around. I have a list of players in each position QB, RB, WR, and TE. I need to pick 1 QB, 2 RBs, 3 WRs, and 1 TE from these lists, I would assume by using combinations. On top of this I want to be able to then limit the...

Team, I am using excel as a checkbook and would like to be able to Create a function e-mail button - specific to each row line item Assign an e-mail action to the button when clicked Once the button is clicked - it pastes the word "Closed" into a specific cell P7:P375 - pending which row is...

Can anyone please help. Our company is in the process of moving over from Excel 2007 to 2013. In Excel 2007 it was possible to have a maximum of 65,534 items in a pivot field before the software would apply a cut-off and display a limited list of items. I have noticed that in Excel 2013 when...

this is a copy of a previous post on summing a text string. Example: 21+12+13..... The string is of variable length with the possibility of 256 or more chars. Try Jindon's Function SumInCell(ByVal txt As String) As Double SumInCell = Evaluate(Replace(Application.Trim(txt), ",", "+")) End...

I stumbled upon this post while trying to figure out the size limits of PowerPivot. http://www.mrexcel.com/forum/showthread.php?t=447852 I have a text file, delimited by a "|" (pipe), which has 22 columns and a little under 30 millions row. The text file is about 4.5 GB is size. I started...