ExcelBanter - Formula array

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Formula array (https://www.excelbanter.com/excel-programming/429577-formula-array.html)

miek

Formula array

How do I enter in the following as a formula array?
{IF(MAX(COUNTIF(A3:A12,A3:A12))1,""Dup's"",""No Dup's"")}
This does not work:
ActiveCell.Value = "{IF(MAX(COUNTIF(A3:A12,A3:A12))1,""Dup's""," "No
Dup's"")}"

Mike H

Formula array

Hi,

Try this

ActiveCell.FormulaArray = "=IF(MAX(COUNTIF(A3:A12,A3:A12))1,""Dup's""," "No
Dup 's"")"

Mike

"miek" wrote:

How do I enter in the following as a formula array?
{IF(MAX(COUNTIF(A3:A12,A3:A12))1,""Dup's"",""No Dup's"")}
This does not work:
ActiveCell.Value = "{IF(MAX(COUNTIF(A3:A12,A3:A12))1,""Dup's""," "No
Dup's"")}"

All times are GMT +1. The time now is 01:37 PM.