1. T

    VBA instead of array formulae

    Is it possible to replace array formulae with just VBA? If I have the data as follows: 1 10 2 25 3 30 and I want to sum column A and put the result in cell D1, I can record a macro to generate this code: Range("D1").Select ActiveCell.FormulaR1C1 = "=SUM(RC[-3]:R[2]C[-3])"...
  2. K

    Shading GROUPS of Similar Rows of Data in Filtered List

    I've looked and looked and can't seem to find the solution to my particular problem... I'm trying to apply shading to rows of data that are all from the same calendar month. In an UNFILTERED range, all data grouped by month would be shaded alternatively by month (JAN, MAR, MAY, JUL, SEP, NOV...
  3. B

    Convert array formula to "regular" formula or alternatively, how to force user to use Ctrl+Shift+Enter

    Hello, I built the below array formula for a spreadsheet that we use at the office (column B). ={ IFERROR(VLOOKUP(INDEX($E$1:$E$16,MATCH(TRUE,ISNUMBER(FIND($E$1:$E$16,A1,2)),0),1),$E$1:$F$16,2,0),"N/A")} My concern is that, since the file will be used by many not-so-Excel savvy users...

Some videos you may like

This Week's Hot Topics