# Tag Info

1 vote
Accepted

### Excel: Split a 2 column range (A:B) into multiple smaller columns with a pre-set number of rows

Welcome! The code itself for copying data to other cells is very simple, not much different (by size) from the one you took from the macro eight years ago. As always, when the data for the calculation ...
• 1,261

### MS Excel - how to fix a column in the formula when in named table

Or use indirect formula: =sum(indirect("Table1["&"Field1

### Excel: Plot a single X and Y coordinate in a static graph

Use a scatter plot Set the min and max bounds for each axis to 0 and 4 respectively. The default is "auto" so it will choose the axis scale based on the value to be plotted. Ps. If you use ...
• 3,084
1 vote

### Find Multiple hits of the search value across all columns & rows of a table and return a list of the results from the 1st column of the table

Using =IFERROR(IF(ISBLANK(\$D\$13),"",INDEX(\$A\$3:\$A\$10,SMALL(IF(\$D\$13=\$B\$3:\$H\$10,ROW(\$B\$3:\$H\$10),""),1))),"") in D15 and =IFERROR(IF(ISBLANK(\$D\$13),"",INDEX(\$A\$3:\$...

### Find Multiple hits of the search value across all columns & rows of a table and return a list of the results from the 1st column of the table

Welcome! For me works fine the formula of the form {=IFERROR(IF(ISBLANK(\$D\$13);"";INDEX(\$A\$1:\$A\$10;SMALL(IF(\$D\$13=\$B\$3:\$H\$10;ROW(\$B\$3:\$H\$10);"");{1:2:3})));"")} or ...
• 1,261

### With Excel Dynamic Arrays, is it possible to spill across merged cells?

Why yes, I believe there may well be a better way! (Again, see comments from the one and only JeffA.) I actually first ran into this by accident a couple of years or so ago, and then a few times since,...
• 352