New answers tagged

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
0 votes

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

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

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 ...
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:$...
0 votes

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
0 votes

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
0 votes

In Excel, how to generate a row of random numbers between 2 values, where the random value does not repeat in row?

I needed to chose a 1 2 or 3 in the same row and not repeat numbers. To do that you can use RANDBETWEEN 1 and 3 in the first column and in the next 2 columns look at the previous columns and use ...
  • 1
0 votes

Why does the dropdown button in Excel data validation disappear?

I went to Options then "Advanced", then scrolled down to "Display options for this workbook:" Then in the "For all objects, show:" I clicked "All". Worked for ...
  • 1

Top 50 recent answers are included