LinkBack URL
About LinkBacks
Hi plk,
Try this:
HTH
Sheets("Sheet1").Range("D10").Formula = "=SUMPRODUCT((A2:A10000<>"""")/COUNTIF(A2:A10000,A2:A10000&""""))"
Robert
Hi plk,
Try this:
HTHSheets("Sheet1").Range("D10").Formula = "=SUMPRODUCT((A2:A10000<>"""")/COUNTIF(A2:A10000,A2:A10000&""""))"
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks