-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
alternatively
-
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])"...- tiredofit
- Thread
- alternatively array formulae macro vba
- Replies: 4
- Forum: Excel Questions
-
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...- kruss77
- Thread
- alternatively data group month shaded
- Replies: 8
- Forum: Excel Questions
-
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...- Bering
- Thread
- alternatively array formula missing user
- Replies: 7
- Forum: Excel Questions
