列 A B C D E F G 行 ------------------ | 1 | 1 2 3 4 5 | 2 | 5 5 6 5 5 =MAX(A2:E2) 3(6是最大值，對應的第一行是C1(=3)) | 3 | 3 5 3 3 3 =MAX(A3:E3) 2(5是最大值，對應的第一行是B1(=2)) | 4 | 6 6 6 6 8 =MAX(A4:E4) 5(8是最大值，對應的第一行是E1(=5)) 現在想請教，G2~G4的資料是想找出每一個最大值對應到第一行的數字 這有公式可以自行找出來嗎 謝謝 -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 111.243.103.95
This entry passed through the Full-Text RSS service — if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.
You are receiving this email because you subscribed to this feed at blogtrottr.com.
留言列表
留言列表
