-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
max rows
-
M
2D =FILTER formula to reference row count
Hello, I'm defining my max rows via a basic lookup =LOOKUP(8,1/('Data'!A:A<>""),ROW('Data'!A:A)) This will be named "Rownum" to call globally. So for instance Rownum = 345 or however long Sheet "Data" col A is. I'm looking to change the hard-coded "z20" and "aa20" to still reference the...- MurdochQuill
- Thread
- filter formula max rows row
- Replies: 1
- Forum: Excel Questions
-
J
Multiple pivot tables & slicers - The maximum number of data series per chart is 255
Hi Excel Experts! I am running Excel 2010. I have a raw data set consisting of about 31000 rows and 10 columns. In my columns, month, year, product details, volume, sales etc. I have created a dashboard with 6 different charts connected to separate pivot tables, where the pivot tables are...- jacobardar
- Thread
- max rows pivottable slicer connections
- Replies: 0
- Forum: Excel Questions
-
M
Importing more than 1,0485,576 rows in Excel 2010
Help - This is driving me crazy... I have 1.9M records in a csv file, when I initially go into Import Wizard, it tells you that it can not load all the records, but once imported, you can go to another worksheet and do another import and exclude the 1,0485,576, from the first worksheet you just...- mstimmel
- Thread
- max rows powerpivot text import
- Replies: 1
- Forum: Excel Questions
