Forum Discussion
Will not create data table because excel says there is an array in the proposed data table area.
You'll need to look for an array formula. You can tell that a formula is an array formula when it is enclosed in { }
Thank you very much. I did search for the first bracket "{" using FIND but it said there are none. I will try again but it may again tell me no such bracket in table area. Thanks for your help.
Reuben
Tried again.Cannot find any brackets. Also, if you try to "sort and filter" (custom), it will not do that either because there is supposedly an array in the range I want to sort and filter.
Thank you, Reuben
Find will not work. You will have to select the cell, and you can see the brackets in the formula bar. You can click Show Formulas on the Formulas tab to make it easier to see which cells have formulas in them, but you will still need to click on each cell to see the brackets.