[算表] 似乎跟唯一有關係的數值分析
軟體:excel
版本:2003
想請教一下,現在我有一組數據(20個)
從A1:A20如下
3.83
3.833
3.833
3.834
3.834
3.834
3.834
3.835
3.835
3.835
3.835
3.835
3.835
3.835
3.835
3.835
3.836
3.836
3.836
3.838
我想要在B、C得到
3.83 1
3.833 2
3.834 4
3.835 9
3.836 3
3.838 1
這樣的分析數據,應該要怎麼做呢?
(不好意思,我有爬文,有看到跟「唯一」有關係的,但是我不會用orz ,
只好來具體描述我的問題)
感謝!!
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.113.156.162
推
06/19 22:36, , 1F
06/19 22:36, 1F
推
06/19 23:01, , 2F
06/19 23:01, 2F
→
06/19 23:12, , 3F
06/19 23:12, 3F
推
06/19 23:16, , 4F
06/19 23:16, 4F
→
06/19 23:17, , 5F
06/19 23:17, 5F
→
06/19 23:18, , 6F
06/19 23:18, 6F
→
06/19 23:19, , 7F
06/19 23:19, 7F
推
06/20 12:27, , 8F
06/20 12:27, 8F
→
06/20 12:48, , 9F
06/20 12:48, 9F