0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 1 year has passed since last update.

Excelにおいて、全体から特定の行のみ抽出する方法

Last updated at Posted at 2023-05-15

Excelに記載してあるもののうち、特定の文字から始まる行だけ抽出したい時に使用する関数

シートの中でXXX文を抽出する

=IFERROR(INDEX(B:B,1/LARGE(INDEX((ISNUMBER(FIND("XXX",B:B)))/ROW(B:B),0),ROW(A1))),"")

使用方法
新規でExcelを開く
B列の2行目にメインの内容を貼る
同じシートの2行目の右側(AA列など)に上記の関数を貼り付ける
関数を貼り付けたセルを左クリックし下に引っ張る
すると、特定の文字から始まる行だけが抽出される

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?