ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

FREQUENCY½Ð±Ð

FREQUENCY½Ð±Ð

½Ð°Ý¤@¤U¡Aµ{¦¡¤@§Ú¬O¥Î¿ý»s¥¨¶°¥X¨Óªº¡Aµ{¦¡¤G¬O­×§ï¹Lªº¡A¦ý¦³bug¡A½Ð°Ýµ{¦¡¤G¦p¦ó­×§ï?Àɮצpªþ¥ó

µ{¦¡¤@:
    Range("B760") = "=FREQUENCY(comparedata0!AD14:AD50006,A760:A774)"
    Range("B760:B774").Select
    Selection.FormulaArray = _
        "=FREQUENCY(comparedata0!R[-746]C[28]:R[49246]C[28],RC[-1]:R[14]C[-1])"

µ{¦¡¤G:
   Range("B6").Formula = "=FREQUENCY(Sheets(3).Range(Cells(14, 16),Cells(369, 16)), Range(Cells(6, 1),Cells(18, 1)))"   
    Range("B6:B18").Select
    Selection.FormulaArray = _
    "=FREQUENCY(¦X¨Ö!P14:P369, A6:A18)"

¦±½u¹Ï°}¦C20130619.zip (198.37 KB)

°}¦C

Simon

¦^´_ 1# morris0914
Cells(14, 16)  ->R14C16
Cells(369, 16)->R369C16
  1.   Range("B6").Formula = "=FREQUENCY(" & Sheets(3).Range(Sheets(3).Cells(14, 16), Sheets(3).Cells(369, 16)).Address(, , , 1) & "," & Range(Cells(6, 1), Cells(18, 1)).Address & ")"
  2.    '¦pSheets(3)¦WºÙ¬° ©T©w¬°[¦X¨Ö] ¥i¥Î ¤U¦¡
  3.     'Range("B6").Formula = "=FREQUENCY(¦X¨Ö!R14C16:R369C16, R6C1:R18C1)"

  4.     Range("B6:B18").FormulaArray = Range("B6").Formula
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

·PÁª©¤j¨ó§U¡A§Ú«á¨Ó§ï¦¨¦p¤U:

Cells(6, 2).FormulaR1C1 = "=FREQUENCY(¦X¨Ö!R[8]C[14]:R[369]C[14], R[0]C[-1]:R[12]C[-1])"
Range(Cells(6, 2), Cells(18, 2)).FormulaArray = "=FREQUENCY(¦X¨Ö!R[8]C[14]:R[369]C[14], RC[-1]:R[12]C[-1])"

­ì¦]¬O°£¤F¤u§@ªí"¦X¨Ö"¬O©T©w¡A¨ä¥¦Äæ¦ì·|ÅܤÆ
Simon

TOP

¦A½Ð±Ð¤@¤UªO¤j¡A¬°¦ó­n¥[.Address(, , , 1)
Simon

TOP

        ÀR«ä¦Û¦b : °ß¨ä´L­«¦Û¤vªº¤H¡A¤~§ó«i©óÁY¤p¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD