三四郎で尻取り･･･第２弾【解答】

問題はこちらを参照。

循環参照を使います。

【解答の手順（エラー対策無し）】

１．メニューを「ツール」「オプション」と辿り、計算タブで「反復回数」を８にする。

２．セルD1に　=If(D1="",C1,D1 & Search("like'^" & Right(D1,1) & "'",B1:B8))

　　と入力する。

【解答の手順（エラー対策あり）】

１．メニューを「ツール」「オプション」と辿り、計算タブで「反復回数」を８以上にする。

２．セルD1に　=If(D1="",C1,D1 & If(IsError(Search("like'^" & Right(D1,1) & "'",B1:B8)),"",Search("like'^" & Right(D1,1) & "'",B1:B8)))

　　と入力する。

Comments

[投稿情報: スニーカー]

I'm curious to find out what blog system you are using? I'm experiencing some small security problems with my latest blog and I would like to find something more secure. Do you have any recommendations?
スニーカー http://www.oxigenofitness.com/シューズ-japan-1.html

[投稿情報: nike court tradition 2]

Trichomonas vaginalis alternatively is definitely an evil beast; you may not count on something much less of a creature that lives out its entire daily life within your genito-urinary tract. It leads to a terrible tiny illness on the very same name, but you have to get pretty up near and private to catch it. Should you definitely prefer to study about every one of the disgusting symptoms, then the BBC Health web-site has one thing bordering on 'too substantially information'..
nike court tradition 2 http://www.safariuganda.com/lacoste-pas-cher.asp?id=nike-court-tradition-2