Get instant live expert help on How do I create from selection command
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Use the Create from Selection command to create named ranges for the data table B8:E11 using the labels in row 1 as the basis for the names.
Solved by O. U. in 11 mins
Is there a way to combine this logic into one command?
=COUNTIF(P32,”France”)+COUNTIF(AH33,”France”)
Cell P32 and AH33 cannot be part of an array selection. (example P32:AH33)
Solved by F. J. in 25 mins
Refresh not working for pivot table/chart. "This command requires at least two rows of source data. you cannot use the command on a selection of only one row. Try the following" If you're using an advanced filter, select a range of cell that contains at least two rows of data. then click the Advanced Filter command again. If you're creating a PivotTable report or PivotChart report , type a cell reference or select a range that includes at least two rows of data
Solved by F. H. in 22 mins
create appropriate range names for cell b18 and b21 by selection, using the values in the left column
Solved by M. Y. in 11 mins
I need to create a formula to extract my selection into a number
Solved by T. J. in 23 mins