【エクセル】複数条件でデータを抽出/SUMPRODUCT関数等の利用法

目次

◆エクセルをデータベース的に使うには、フィルタ&セルの色付けと手作業抽出&計算という方はまだまだ多い!

さて、シート内にデータテーブルとして、一行一列対応状態のレコード群から複数条件に一致したデータを抽出するとき・・・手作業でよく使うのならフィルタ機能という方は少なくないのではないでしょうか? これです。

ですが複数条件で一致したデータを、たとえば複数のシートから抽出となってくると、非常に煩雑。 まずは全データを合体させたシートを別シートとして用意して、動作がしづらいのでそれぞれのデータ参照リンクを切って、値貼り付けにしてなどなど・・・自動化処理するにしても、エクセルブックを開けてからこうした動作を行わせるとなると、動作も不安定で、一致したデータが抽出しにくいのです。 一度に使える1データ行あたりのフィルタ条件数にも限りがあり、これが複数条件をそのまま設定して動的にデータを見ることを妨げている原因という人も少なくありません。

さらに色付けしたセルを抽出することは可能なのですが、かなり大きなデータテーブルに対して、単一色で塗ってくれればいいものを「赤」といったら、「赤系統の複数色で塗り分けてくる」などという離れ業の方も・・・ これでは、複数条件でのデータ抽出以前に、エクセルの中で色系統に合わせて、作業者が手作業で塗りなおしなどを、官能的判断(色覚)尺度で行う必要も出てきます。 これでは自動化どころか、スムーズな業務、いや、正確な状態でのデータ利用はなかなか困難でしょう・・・。

”背景色付きセルを利用してできる分類データベース化 エクセルVBA自動化すれば、業務改善効果抜群! エクセルで 色のついたセルを数えるアプリを作りました。”

VBAでできること実例16選【業務改善の為のエクセル活用例】
Tech Engine | VBAでできること実例16選【業務改善の為のエクセル活用例】 たとえば上記リンクでは、エクセルのセル色を使ったさまざまなTIPSをご紹介しています。

◆データ抽出を行うとき、多くの人が使っているVLOOKUP・・・とくに、複数条件でのデータ抽出では、実は使いにくくありませんか?

集計表作成では、一度計算式を設定した小計用のセルを、各行に対して別に用意して、それをもとにデータ抽出を行うことがほとんど。 多くの方では条件設定したセルを、VLOOKUPの抽出列に取り出して、その状態で取り出したセルのある列に対して集計をかけるという状態でしょうか。

■VLOOKUP■ 使用可能なエクセルVer:2000/2002/2003/2007/2010以降 指定された範囲の1列目で特定の値を検索し、指定した列と同じ行にある値を返します。テーブルは昇順で並べ替えておく必要があります。 書式:VLOOKUP(検索値, 範囲, 列番号, 検索型)

俗にいう縦方向にレコードが並ぶ=行単位でレコードが並ぶ表を、検索や抽出するための関数。 これに対して、横方向にレコードが並ぶ=列単位でレコードが並ぶ表を検索や抽出するものは、

■HLOOKUP■ 使用可能なエクセルVer:2000/2002/2003/2007/2010以降 指定したテーブルまたは配列の先頭行で特定の値を検索し、指定した列と同じ行にある値を返します。 書式:HLOOKUP(検索値, 範囲, 行番号, 検索型) などがあります。

VLOOKUPの動作は、レコード数とマシン環境などによっても、また式の複雑さによっても正確かどうか疑わしいこともあります。 とのため、各行データごとに、検算を行う意味でも、正しい行データを取り出せたかの判定などを記述しておくことも必要。

単純にVLOOKUPで取り出すだけでも、こんな風にデータの加工が面倒です。 たとえば、表の中の「1列目=エリア10005」のデータの中から目的の値を取り出したいなあと考えて、 各行に関数:=VLOOKUP(”10005”,B8:$H$22,7,1) から連続データを生成させると、設定した検索値が並んでいないとき&検索値がユニークではないため、同じエリア列=10005の中でも、単に整列順のTOPの値ではない「いずれかのレコード」を拾ってしまいます。

そこで、エリア部分を整列させてみても =VLOOKUP(”10005”,B27:$H$41,7,1)では、 やはり表中一番上の値を拾ってくれるわけではありません。 整列だけはしているものの、エリアコードがユニーク値ではないので(完全に一意の値ではない)同じような結果に・・・ (※このデータがなぜ拾われたかは、最後におまけでご紹介しています。「一致検索と近似検索」参照)

こういった場合、細かな数値設定や、入れ子にしてエリアコード10005かつ商品名××や支店名××のような条件設定が必要。式設定が面倒ですし、数値だけが毎月差し替わる売上データのようなときには妥当ではありません。

ちなみに、VLOOKUPは意外とリソースを消費する処理で、こういったデータの中では、ユニーク値を検索するときにはスムーズに目的データにたどり着けます。

※【蛇足ですが・・・】エクセルプログラミングや表自動化設定のときにはMUSTですが、プログラマーが書くマクロやVBAでは、こんな風にすべての行に対して抽出させた後、表中最も最後に数値が取れている行を、ROWなどで得てその数値をもとに処理させます。 万が一データ取得に間違いがあった場合、見つけやすくなる=データ取得エラー自体を、自動で引っ掛けやすくするためです。

よく使われているIF文を使って各行ごとに値を取り出したあと、複数グループをたてて、同じシート、あるいは別シートやブック上にデータをいったん転記しながら見えない位置で処理を行わせることになります。

上の例ではJ列とK列に10005と10001の2グループだけを抽出していますが、端末上のリソースを多く取ります。 だから事務用マシンでは動作が不安定になったり、途中で停止してしまうなんて言う方も。 また各行で、基本的に(エクセルのブックオープンの都度再計算を行わない設定にしない限りは)都度計算を行うため、ファイルオープン時にあらゆる処理が集中してデータが壊れやすいといったことも発生します。 面倒な記述を行うよりは、複数条件からすぐに演算ができて、その部分だけ集計したものが取り出せれば便利です。

どんな関数を使った処理なら簡単なのでしょうか?

◆エクセルでのデータの単純抽出、複数条件からデータをすっきり抽出したいとき、覚えておきたい関数たち

データ抽出や計算には、ちょうどこれからご紹介するような関数が、比較的すっきりとした記述で使用できます。 まず、直接それぞれ単独で、どんな動作ができるのかを見ておきましょう。

エクセルの抽出や演算でツカエル関数~SUMPRODUCT

■SUMPRODUCT■ 使用可能なエクセルVer:2000/2002/2003/2007/2010以降 範囲または配列の対応する要素の積を合計した結果を返します

二つ以上の数値の組を、配列という形で掛け合わせて合計した結果を返してくれます。

たとえば画像のような検索元テーブルで、通常は、各行ごとに小計を出し、それをSUMで下の合計欄に集計します。 ですがこのテーブルのレコード行数が多い時や、エリアや支店ごと集計を出したい時。また別シートごとにレコードがまたがって記録されているとき。さらに一定の売り上げ条件や値引き率を条件とした集計、支店名ごと、エリアごと集計などを行うときにも、IFやVLOOKUPからフラグを建てて集計を行うには、いちど、それぞれを別シートに参照転記などを都度行わせる処理をさせたうえで、計算するのがもっとも安定。 自動化するにしても、作業にはかなり手間がかかります。

ここで関数SUMPRODUCT を使えば・・・ SUMPRODUCTは実は、複雑条件を設定して、データを抽出計算するのが得意です。 ですが、ほかの関数と組み合わせずに、SUMPRODUCT 単独でもかなり使い勝手が良いのです。 行えることとしてはたとえば、図中の 検索結果1の式=SUMPRODUCT(E8:E22,F8:F22,G8:G22) 検索結果2の式=SUMPRODUCT((E8:E22),F8:F22,(B8:B22="005")*(G8:G22=1)) 検索結果3の式=SUMPRODUCT(E8:E22,F8:F22,(F8:F22>=100)*(G8:G22=1)) のように、各行ごとのデータ全体の集計から、その中で特定の条件分岐をさせたものだけを抽出して合計することなど。 関数式自体も非常にすっきりしていて、処理もスムーズなのも便利です。

検索結果2の関数式 =SUMPRODUCT( E8:E22,F8:F22,(B8:B22=”005”)*(G8:G22=1)) について。 この式で注意したいのは、条件設定した各配列の項目中では、それぞれに抽出条件(ここでは「(B8:B22=”005”)*」)をつけなければならないこと。配列要素が論理値なので、かならずこの記述が必要となります。 検索結果2のケースでは、検索元テーブルの中の、非計算数値行に対しての条件をB列に対して設定していますが、配列3で数値による抽出条件(単価に対して値引きなし=1)を設定しているため、ここに抽出条件を付けています。

検索結果3の式では、同じく配列3(=G列)に対して、配列2の数値を条件として設定しています。 =SUMPRODUCT(E8:E22,F8:F22,(F8:F22>=100)*(G8:G22=1)) すっきりとして見やすいですね。

他にも、SUMPRODUCT単独では、他にも、配列計算から、一定のサイズかつ一定の品目の行だけをカウントするなんていう使い方もできます。

この釣果の表からLサイズのさわらが連れた行だけを、匹数を求めずにカウントします。 時間帯1区分ごとに 魚種&サイズでは各行に重複がないように作成されているデータテーブルなので、複合条件カウントではこの方法が便利!

=SUMPRODUCT((B6:B32=”さわら”)*(C6:C32=”L”)) で、配列の合計を出すことなく、該当する行数を抽出させてカウントだけをさせます。

論理値計算を応用したものですが、かなり便利ですね。

エクセルの抽出や演算でツカエル関数~DGET

出典:pixabay.com

■DGET■ 使用可能なエクセルVer:2000/2002/2003/2007/2010以降 データベースの列から指定された条件を満たす1つのレコードを抽出します。 書式:DGET(Database, フィールド, Criteria) このデータベースという部分は、データラベル(各データの項目タイトルを、1行対1セル対応)を含んだ範囲選択です。

DGETはエクセルに用意されている中でデータベース関数に属します。 DGETが一番シンプルな使われかたをされているケースでは、順位やIDなど重複のない値(キーや重複排除されたインデックス値他)を基にした値を基に、一定のデータを抽出するとき。 ただし条件フィールド(この例ではB24:F26とB30:F31)のほうを、検索元テーブルよりも後ろにおく必要など、細かな制約があります。

上のようなテーブルに対して、検索結果1では「=DGET(B4:F19,”都道府県”,D22:E23)」を条件に設定。 苗字=紀本名前=むとんぼの人の所属市町村名を抽出しています。 この苗字と名前は、データテーブル中では重複なしの組み合わせ。 対して検索結果2では、 苗字=大本名前=まりおの人の所属市町村名を抽出しようとしていますが、このデータは同姓同名の別エリア居住の人があり、重複あり。 そのため「#NUM!」が表示されます。

検索結果3では 同姓同名データがあるが、都道府県も検索条件にしているため、正しいデータが取れるようになっています。 非常に便利ですね。

エクセルの抽出や演算でツカエル関数~INDEX

■INDEX■ 使用可能なエクセルVer:2000/2002/2003/2007/2010以降 指定された行と列が交差する位置にある値またはセルの参照を返します。 書式:INDEX(範囲, 行番号, 列番号, 領域番号)  ※複数範囲も指定できます

=INDEX(D9:H23,E27,F27,1)

ここではシフトの時間帯行に割り当てた番号と、曜日列に割り当てた番号を用いて、該当する9行目3列目の国友=水曜 10~15時を取得

エクセルの抽出や演算でツカエル関数~SUMIF

■SUMIF■ 使用可能なエクセルVer:2000/2002/2003/2007/2010以降 指定された検索条件に一致するセルの値を合計します。 書式:SUMIF(範囲, 条件, 合計範囲)

◆ SUMIF をつかった検索例 SUMIFとは…範囲から合致するものなどの1条件をつけて数値を合計するもの 書式例=SUMIF(検索範囲,検索条件[,合計範囲]) 計算例=SUMIF(商品名,セル位置もしくは”あおさ”,売上) ここでは、下の画像の各セルに入力されたデータをもとに集計しています。 =SUMIF($B$3:$B$18,F4,$C$3:$C$18)

エクセルの抽出や演算でツカエル関数~SUMIFS

■SUMIFS■ 使用可能なエクセルVer:2007/2010以降 範囲から合致するものなどの複数条件をつけて数値を合計するもの 書式:SUMIFS(合計範囲,検索範囲1,検索条件1[,検索範囲2,検索条件2…])

◆ SUMIFS をつかった検索例 こちらも、ベースとなるデータ一覧表は、SUMIFと同じ。 下の画像の各セルに入力されたデータをもとに集計しています。 =SUMIFS($C$3:$C$18,$B$3:$B$18,F23,$D$3:$D$18,”2018/4/8”) エクセルで印刷向けフォーマットを作る時などは、ごく一般的ですよね。

もしこれも、SUMIFで行おうと思えば、集計対象フラグを建てたセルを用意して、その該当セルだけを足さなければいけません。 複数条件を設定しておきながら見栄えをよくしたり直接印刷出力をするために、別シートにいったん計算結果をとって、そこにさらに複数条件抽出などをかけて、集計用シートに戻すなんて言うこともままあります。 ですが、SUMIFに比較すれば、エクセルのバージョンは限られる関数ですが、便利に使えますね。

エクセルの抽出や演算でツカエル関数~DPRODUCT

■DPRODUCT■ 使用可能なエクセルVer:2000/2002/2003/2007/2010以降 上辺を満たすデータベースレコードの指定したフィールドに入力されている数値の積を返します。 書式:DPRODUCT(データベース,フィールド,セル範囲)

こちらの検索結果では、D29セルに式設定をして、B29~B37に入力した商品名の在庫の中で、在庫数が0のものを含んでいるときに、D29セルに「要在庫確認」と表示されるようになっています。 他の関数との組み合わせで、たとえば、C29~C37に発注予定数を入力したときに、安全在庫数を下回るかどうかなどで、このD29の警告表示条件を切り替えてもいいかもしれません。 各行単純掛け合わせなどのため、入力チェック在庫チェックなどに、よく使われています。

エクセルの抽出や演算でツカエル関数~DSUM

■DSUM■ 使用可能なエクセルVer:2000/2002/2003/2007/2010以降 データベースの指定された列を検索し、条件を満たすレコードの合計を返します。 書式:DSUM(データベース,フィールド,セル範囲)

この売上データの中から、品目や販売営業所など、複数の条件や単一の条件を組み合わせながら、合計を出したいというとき、フィルタを使って表示させるのもよいのですが、集計表などに使うなら、この方法が便利です。 =DSUM(B7:E23,E7,B26:D27) で、B26:D27の27行目に入力された値を基に、売上セルが合計表示されます。

注意したいのは、<4月1旬 売上先品目一覧>のデータテーブルと、<DSUMをつかった計算1>ならびに<DSUMをつかった計算2>では各列のタイトルセル(列名セル)が同じ名称を使い、同じ隣り合ったセル構造をもっていること。 同じセル間の配置の構造を持っていれば、売上先品目一覧表の直下になくても(シートの左などにあっても)使用できます。

大データで、フィルタをつかって同じことを行うと、非常に時間もかかり不安定に。 こういった関数で、すっきり取り出して表示させてしまいましょう。

◆エクセル関数の複合技で、複数条件抽出ももっと便利に

出典:pixabay.com

さてこれまでご紹介した関数と、そのほかの関数を組み合わせて、もっと違う方法ですっきりとした検索ができないかどうか試してみました。

エクセル関数をつかった複合技で複数条件からデータ抽出~SUMPRODUCT×INDEX×ROW

さてこんなテーブルから、小さな表に任意の条件を入力して、複数条件からデータを抽出しやすいフォームを考えてみました。

=INDEX($F$4:$F$19,SUMPRODUCT((C4:C19=I4)*(D4:D19=I5)*(E4:E19=I6),ROW(F4:F19))) こちらでは、左側の表<検索条件1>のI4~I6セルに入力された値を基に、テーブルから検索結果を返します。

VLOOKUPやDGETと異なり、この検索方法でより便利な点は・・・ 「元の表と同じ形状をした条件を指定したエリアを設定」しなくてもOK。 またその項目行(俗にいうタイトル行や列名行)を表の上部にもってこなくても OKということ。 現在利用している印刷用のエクセルフォーマットからそのまま、式が適用できます。

エクセル関数をつかった複合技 よくある集計表業務 3行おきに合計を出したい ~SUMPRODUCT×ROW×MOD

さて、集計表業務では、やはり社外向けだけではなく社内向けでも見やすさが一番。 これまで長年使われてきたフォーマットを変えずに、すぐに計算や印刷作業ができることが求められています。 たとえば、こんな表はありませんか?

よくある予実管理表や、人件費、労働時間、工数計画集計表などで使うタイプのもの。 これも、一番下の行に、5か年分の売り上げ件数があります。 長期的な事業報告などでは、こういったデータも、複数枚出てくることがあるんですよね。 各部門ごと、それぞれの部局ごとのデータとシートごとリンクしていたりするため、抽出式が複雑条件で設定されているので、できるだけ、一番上の階層の集計表部分は軽くまとめたいところ。 各部門や職種、年数などが増えたケースでは、SUM集計すると、 契約件数の五か年合計を普通にSUM集計すると =SUM(E2,E5,E8,E11,E16) のように書かねばならず面倒です。

項目数が多いデータの場合、シートやブックが重くなり、時間がかかったり、あるいはデータ自体がトラブルで消失してしまうことも。 そこで使いたいのが、エクセルの実力テスト問題@職場として頻繁に組合から出題される、SUMPRODUCT×MOD×ROWの合わせ技です。

契約件数の合計セルは=SUMPRODUCT((MOD(ROW(D3:D17),3)=2)*(D3:D17)) かなりすっきり、一度でデータが取れる点は便利ですね。

◆このほかにもすっきりとした計算を行ってくれる便利なエクセル関数たち

出典:pixabay.com

入社時研修や学生時代に覚えたきりで、ちょっと古いVersionでエクセル操作を覚えている人がほとんど。 新しく出た関数のチェックは怠ったままという方もあるかもしれません。 ここでは簡単にご紹介しますが、たとえばこんな関数を使えば、さまざまな計算を行わせることもできます。

SUBTOTAL

■SUBTOTAL■ 使用可能なエクセルVer:2000/2002/2003/2007/2010以降 リストまたはデータベースの集計値を返します。

ちなみに1つの関数で11種類もの計算を行うことができます。 書式=SUBTOTAL(集計方法,範囲1[,範囲2・・・]) この集計方法の部分は、数字で指定するもので、 1AVERAGE 2COUNT 3COUNTA 4MAX 5MIN 6PRODUCT 7STDEV 8STDEVP 9SUM 10VAR 11VARP が使えます。

AGGREGATE

■AGGREGATE■ 使用可能なエクセルVer: 2010以降 リストまたはデータベースの集計値を返します。 こちらはSUBTOTALを超えて、19種類もの計算を行わせることができる優れもの。SUBTOTALを機能拡張させた関数ですが、2010以降でしか使用することができないのがちょっと残念。 書式=AGGREGATE(集計方法のうち1~13,オプション,参照1[,参照2・・・]) 書式=AGGREGATE(集計方法のうち14~19,オプション,配列,順位)

この集計方法の部分は、数字で指定するもので、 1~11まではSUBTOTALと同じ 12MEDIAN 13MODE(MODE.SNGL) 14LARGE 15SMALL 16PERCENTILE(PERCENTILE.INC) 17QUARTILE(QUARTILE.INC) 18PERCENTILE.EXC 19QUARTILE.EXC が使えます。

COUNTIFS

■COUNTIFS■ 使用可能なエクセルVer: 2007/2010以降 特定の条件に一致するセルの個数を返します。 127個までの複数の検索条件に一致するセルの個数を返してくれます。 これまで長くCOUNTIFでフラグを建てて、個数を集計していたものを、一気に1セル当たり127個までの条件を付けてカウントしてくれる優れもの。便利ですね。 書式=COUNTIFS(検索範囲1,検索条件1 [,検索範囲2,検索条件2・・・])

GETPIVOTDATA

■GETPIVOTDATA■ 使用可能なエクセルVer:2000以前 使用可能なエクセルVer: 2002以降 ピボットテーブルの中にある値を、レイアウト変更やページ切り替えなどでどれだけテーブル内のセル位置が移動しても、常に目的のデータを取得してくれる関数。

既につかっている方が圧倒的だとは思いますが、エクセルVer:2000以前とエクセルVer:2002以降ではそれぞれ書式が異なります。 書式=エクセルVer:2000以前では GETPIVOTDATA(ピボットテーブル,名前) 書式=エクセルVer:2002以降では GETPIVOTDATA(データフィールド,ピボットテーブル[,フィールド1,アイテム1]…)

◆エクセル2016では、さらにすっきりと複雑な計算を行ってくれる便利なエクセル関数たちが仲間入り!

さらにエクセル2016では、これまで以上に複雑な条件を、すっきりと取り出せる IFS関数、SWITCH関数、TEXTJOIN関数、CONCAT関数、MAXIFS関数、MINIFS関数、FORECAST.ETS系関数などが仲間入り。

数式の編集を容易にする新しい 6 つの Excel 関数 今回追加されたのは、リスト内または範囲内の文字列を結合する TEXTJOIN 関数と CONCAT 関数、わかりにくい IF 関数の入れ子を回避するための IFS 関数と SWITCH 関数、1 つ以上の条件を指定して範囲内の最大値を返す MAXIFS 関数と と最小値を返す MINIFS 関数です。

とくにエクセルを業務で使っていた方では、複数条件設定による入れ子の数が多すぎて、データ抽出や演算、再計算動作が思わしくない方が多く見られました。 そんな悩みに効く、IFS 関数と SWITCH 関数による複数の条件の指定はかなり便利です。

IF 関数を連続して入れ子にする必要がなくなります。IF 関数は Excel で最も頻繁に使用される関数の 1 つで、IF 関数内に IF 関数を使用する (IF 関数を入れ子にする) 手法は一般的に使用されてきましたが、入力に手間がかかったり、わかりにくかったりする場合があります。 新しい IFS 関数を使用するメリットは、1 つの関数で複数の条件を指定できることです。
=IFS(C1>=90, “A”, C1>=80, “B”, C1>= 70, “C”, C1>=60, “D”, C1<60, “Fail”) この数式は、C1 セルの点数が 90 以上の場合は A を返し、80 以上 90 未満の場合は B を返し、70 以上 80 未満の場合は C を返す、というように処理していきます。 SWITCH 関数でも複数の条件を処理します。IFS 関数と異なるのは、複数の条件付きステートメントを指定するのではなく、式と複数の値および結果を指定する点です。値は式と比較され、最初の完全一致に対応する結果がセルに適用されます。また、式がいずれの値にも一致しない場合に返される「既定」の結果を指定することもできます。IF 関数を入れ子にすると、同じ式を繰り返し入力しなければならない場合がありますが、SWITCH 関数を使用すればこの手間を省くことができます。

これまでこんなに長かったIFの入れ子の複雑な抽出条件・・・非常に見づらく、カッコの数を数えるときに、おもわず指で画面を抑えながら、数がくちから出てくるようなオジサマも数多くオフィスでは見られました。 管理部門業務でよく使用するファイルの格納構造=各部門や係ごとにデータシートを特定の場所に設置し、それぞれの部門のサーバから、特定条件のシートを、管理部門のサーバ内のファイルに、それぞれ別シートで、複数条件を付けて抽出して集計・・・などという、ファイルオープンや演算処理だけで、毎朝PC起動後、なにもできない(※自分でPCを操作すると、フリーズやファイル壊れの危険がある)といった状態では、こうした複数の入れ子や、複雑な参照先が多数指定されているエクセルブックがほとんど。

それもSWITCHを使うとここまで簡単!シンプルに。 もう、式が見やすいので、引き継いだ人がシートの構造を読み込んで改変するにも簡単!

◆エクセルで複数条件でデータを抽出するのに役立つ関数・・・いかがでしたか?

SUMPRODUCTを中心に、いずれも覚えておくと、これまでのデータ処理をすっきりとさせてくれる関数ばかりをあつめてご紹介しました。 とくに関数自体は、習得自体にもあまり時間がかからないので、これを読んだついでに。週末などにまとめてしっかり練習しておくのをおススメします!

【おまけ】検索/行列関数による検索データ抽出方法の2つ=一致検索と近似検索 とは?

先ほどご紹介したVLOOKUPとHLOOKUPのような検索では、予期しない値を勝手に表示しているときがあります。 実はこの2つの関数などには、「一致検索」と「近似検索」という二つの検索方法があるから。

  ・エクセル関数の「一致検索」とは

  定められた検索方法の引数をFALSEもしくは0に設定   検索値に完全にデータが一致するときは完全に一致したデータを抽出。   一致しないときは「#N/A」を戻す   

  ・エクセル関数の「近似検索」とは

  定められた検索方法の引数をTRUEもしくは1もしくは省略で設定   検索値に完全にデータが一致するときは完全に一致したデータを抽出。   一致しないときは「検索値未満で、もっとも大きな値」を戻す

この近似検索をエラー処理に使うケースもありますが、直接関数で処理するケースでは、すぐに表示させて意味のある使えるデータとして取り出したいところです。 正確なデータにすぐにたどり着ける関数があればそちらを優先に。 ない場合は、その他のエラー処理を使いながら、複数関数で処理をというのが基本です。

294 件のコメント

  • Hi, Neat post. There is a problem with your web site in internet explorer, would check this… IE still is the market leader and a large portion of people will miss your wonderful writing because of this problem.

  • I just wanted to post a simple note to be able to say thanks to you for all the wonderful solutions you are sharing here. My long internet research has at the end of the day been paid with high-quality facts and strategies to exchange with my family and friends. I ‘d declare that we website visitors are very blessed to exist in a great community with so many perfect people with interesting tactics. I feel very much lucky to have encountered the webpages and look forward to tons of more enjoyable times reading here. Thank you once more for a lot of things.

  • Fantastic beat ! I would like to apprentice while you amend your site, how could i subscribe for a blog website? The account aided me a acceptable deal. I had been tiny bit acquainted of this your broadcast offered bright clear concept

  • After research a couple of of the weblog posts in your website now, and I really like your approach of blogging. I bookmarked it to my bookmark web site listing and will be checking again soon. Pls try my web page as well and let me know what you think.

  • I’m really loving the theme/design of your site. Do you ever run into any internet browser compatibility issues? A number of my blog readers have complained about my website not working correctly in Explorer but looks great in Chrome. Do you have any advice to help fix this problem?

  • I’ve read several good stuff here. Definitely worth bookmarking for revisiting. I surprise how so much attempt you set to make any such great informative web site.

  • Hi, Neat post. There is a problem with your site in internet explorer, would test this… IE still is the market leader and a big portion of people will miss your great writing because of this problem.

  • Good day! This is kind of off topic but I need some guidance from an established blog. Is it very hard to set up your own blog? I’m not very techincal but I can figure things out pretty quick. I’m thinking about setting up my own but I’m not sure where to start. Do you have any ideas or suggestions? Thank you

  • With havin so much content do you ever run into any issues of plagorism or copyright infringement? My blog has a lot of exclusive content I’ve either written myself or outsourced but it appears a lot of it is popping it up all over the web without my authorization. Do you know any methods to help protect against content from being stolen? I’d definitely appreciate it.

  • Hey this is kinda of off topic but I was wanting to know if blogs use WYSIWYG editors or if you have to manually code with HTML. I’m starting a blog soon but have no coding knowledge so I wanted to get guidance from someone with experience. Any help would be greatly appreciated!

  • A person necessarily assist to make severely articles I would state. That is the very first time I frequented your website page and so far? I amazed with the research you made to create this particular post incredible. Wonderful task!

  • I’ve been exploring for a little bit for any high-quality articles or blog posts on this kind of area . Exploring in Yahoo I at last stumbled upon this website. Reading this information So i am happy to convey that I have an incredibly good uncanny feeling I discovered just what I needed. I most certainly will make sure to do not forget this website and give it a look on a constant basis.

  • With havin so much written content do you ever run into any issues of plagorism or copyright violation? My website has a lot of unique content I’ve either created myself or outsourced but it looks like a lot of it is popping it up all over the web without my agreement. Do you know any solutions to help prevent content from being stolen? I’d genuinely appreciate it.

  • Youre so cool! I dont suppose Ive read something like this before. So nice to search out any individual with some authentic thoughts on this subject. realy thanks for beginning this up. this website is one thing that is needed on the web, someone with just a little originality. useful job for bringing something new to the web!

  • hi!,I like your writing so a lot! percentage we keep in touch more about your article on AOL? I require a specialist on this house to resolve my problem. Maybe that’s you! Looking ahead to see you.

  • I do love the manner in which you have presented this challenge and it does indeed present me a lot of fodder for consideration. However, coming from just what I have witnessed, I just trust as the feedback pile on that people remain on issue and not get started upon a soap box associated with the news du jour. All the same, thank you for this exceptional piece and whilst I do not necessarily agree with it in totality, I regard your point of view.

  • I precisely desired to appreciate you yet again. I am not sure what I would have handled without those tips discussed by you regarding my topic. It absolutely was an absolute traumatic condition in my position, nevertheless encountering the professional style you resolved that made me to leap with happiness. I am just happier for this help and even hope you realize what a powerful job you’re getting into educating the mediocre ones using your web page. I’m certain you have never got to know any of us.

  • Howdy, i read your blog from time to time and i own a similar one and i was just curious if you get a lot of spam remarks? If so how do you reduce it, any plugin or anything you can suggest? I get so much lately it’s driving me mad so any help is very much appreciated.

  • you’re really a good webmaster. The website loading speed is incredible. It seems that you are doing any unique trick. Also, The contents are masterpiece. you’ve done a fantastic job on this topic!

  • Admiring the time and energy you put into your website and detailed information you offer. It’s awesome to come across a blog every once in a while that isn’t the same out of date rehashed material. Great read! I’ve saved your site and I’m including your RSS feeds to my Google account.

  • Howdy! Someone in my Facebook group shared this website with us so I came to check it out. I’m definitely loving the information. I’m bookmarking and will be tweeting this to my followers! Fantastic blog and amazing style and design.

  • I’m really inspired together with your writing talents and also with the format for your blog. Is this a paid theme or did you modify it yourself? Either way keep up the excellent quality writing, it’s uncommon to peer a great blog like this one these days..

  • whoah this weblog is great i really like reading your articles. Stay up the great work! You understand, many persons are searching round for this info, you can help them greatly.

  • Along with every thing which appears to be developing throughout this specific area, a significant percentage of perspectives happen to be fairly stimulating. Nevertheless, I beg your pardon, but I do not subscribe to your entire theory, all be it exciting none the less. It would seem to me that your commentary are generally not entirely justified and in simple fact you are generally your self not even totally confident of your point. In any event I did appreciate reading through it.

  • I like what you guys are up also. Such clever work and reporting! Carry on the excellent works guys I have incorporated you guys to my blogroll. I think it’ll improve the value of my site 🙂

  • Great blog! Do you have any recommendations for aspiring writers? I’m hoping to start my own blog soon but I’m a little lost on everything. Would you recommend starting with a free platform like WordPress or go for a paid option? There are so many choices out there that I’m totally overwhelmed .. Any recommendations? Many thanks!

  • I would like to express some appreciation to you just for bailing me out of this type of matter. As a result of looking through the world wide web and coming across tips which are not helpful, I figured my life was gone. Being alive without the solutions to the difficulties you have solved by means of the blog post is a critical case, and ones that could have negatively affected my entire career if I hadn’t come across your blog post. Your good mastery and kindness in dealing with all things was tremendous. I don’t know what I would’ve done if I had not come upon such a point like this. I am able to at this point look forward to my future. Thanks a lot very much for your specialized and sensible help. I won’t be reluctant to suggest your blog post to any person who should have counselling on this issue.

  • Hey there just wanted to give you a quick heads up. The text in your post seem to be running off the screen in Internet explorer. I’m not sure if this is a format issue or something to do with browser compatibility but I thought I’d post to let you know. The design look great though! Hope you get the issue fixed soon. Many thanks

  • wonderful post, very informative. I wonder why the other experts of this sector don’t notice this. You should continue your writing. I’m sure, you have a huge readers’ base already!

  • Woah! I’m really digging the template/theme of this site. It’s simple, yet effective. A lot of times it’s very hard to get that “perfect balance” between superb usability and visual appeal. I must say that you’ve done a fantastic job with this. Also, the blog loads very quick for me on Chrome. Exceptional Blog!

  • A powerful share, I just given this onto a colleague who was doing slightly evaluation on this. And he in reality bought me breakfast because I discovered it for him.. smile. So let me reword that: Thnx for the deal with! However yeah Thnkx for spending the time to discuss this, I really feel strongly about it and love studying more on this topic. If attainable, as you turn into experience, would you mind updating your blog with extra details? It’s highly helpful for me. Massive thumb up for this weblog put up!

  • Hey would you mind sharing which blog platform you’re working with? I’m going to start my own blog in the near future but I’m having a difficult time making a decision between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your design seems different then most blogs and I’m looking for something completely unique. P.S Sorry for getting off-topic but I had to ask!

  • Wow! This could be one particular of the most beneficial blogs We’ve ever arrive across on this subject. Basically Wonderful. I’m also an expert in this topic so I can understand your effort.

  • Thank you, I have recently been looking for info about this subject for a long time and yours is the greatest I have came upon till now. But, what about the conclusion? Are you sure in regards to the supply?

  • An interesting discussion is value comment. I believe that you must write more on this topic, it won’t be a taboo topic however usually people are not sufficient to talk on such topics. To the next. Cheers

  • You can definitely see your skills in the work you write. The arena hopes for even more passionate writers such as you who aren’t afraid to mention how they believe. All the time go after your heart.

  • Hi, Neat post. There’s a problem together with your site in internet explorer, might test this… IE still is the marketplace chief and a big element of other people will leave out your wonderful writing because of this problem.

  • I’ll immediately grab your rss as I can not find your e-mail subscription hyperlink or e-newsletter service. Do you have any? Please allow me understand so that I may just subscribe. Thanks.

  • After examine just a few of the blog posts in your web site now, and I actually like your manner of blogging. I bookmarked it to my bookmark web site record and will likely be checking again soon. Pls try my web page as nicely and let me know what you think.

  • Thank you for any other informative site. The place else may just I am getting that kind of info written in such a perfect means? I have a project that I am just now working on, and I’ve been at the look out for such info.

  • At this time it appears like WordPress is the best blogging platform out there right now. (from what I’ve read) Is that what you’re using on your blog?

  • Does your site have a contact page? I’m having a tough time locating it but, I’d like to send you an e-mail. I’ve got some creative ideas for your blog you might be interested in hearing. Either way, great blog and I look forward to seeing it develop over time.

  • Hi, I am the marketing apprentice at Peaches and Screams. We are currently striving to tap into the vape wholesale marketplace. Does anyone here possess any practical experience with the vape industry or B2B list building? We are significantly predisposed to invest in the Global Vape Shop Database, Vape Company E-Mail List and Yoggy’s Money Vault Search Engine Scraper in order to create our own B2B leads. Does anybody here have any expertise with any of the above advertising and marketing resources? Would love to listen to your thoughts and reviews prior to committing myself to the investment. Additionally, I would very much appreciate any tips for really helping us to develop our vape wholesale company. Thanks

  • Hmm is anyone else having problems with the images on this blog loading? I’m trying to determine if its a problem on my end or if it’s the blog. Any responses would be greatly appreciated.

  • Great beat ! I would like to apprentice while you amend your site, how can i subscribe for a blog web site? The account helped me a acceptable deal. I had been tiny bit acquainted of this your broadcast provided bright clear concept

  • After study a number of of the blog posts on your website now, and I truly like your way of blogging. I bookmarked it to my bookmark website listing and might be checking back soon. Pls try my web page as nicely and let me know what you think.

  • A powerful share, I simply given this onto a colleague who was doing a little bit evaluation on this. And he in fact purchased me breakfast because I discovered it for him.. smile. So let me reword that: Thnx for the deal with! However yeah Thnkx for spending the time to debate this, I really feel strongly about it and love studying extra on this topic. If possible, as you turn out to be expertise, would you mind updating your weblog with extra details? It is highly helpful for me. Massive thumb up for this blog post!

  • Hello! I’ve been reading your web site for some time now and finally got the courage to go ahead and give you a shout out from Lubbock Texas! Just wanted to say keep up the excellent work!

  • Its like you learn my thoughts! You appear to grasp a lot approximately this, like you wrote the book in it or something. I feel that you could do with some to power the message house a little bit, but other than that, that is fantastic blog. A fantastic read. I will definitely be back.

  • Exceptional post but I was wondering if you could write a litte more on this subject? I’d be very grateful if you could elaborate a little bit more. Appreciate it!

  • What i do not realize is actually how you are not actually much more well-appreciated than you may be now. You’re so intelligent. You recognize therefore significantly relating to this subject, made me in my opinion consider it from numerous varied angles. Its like men and women aren’t interested until it’s one thing to accomplish with Girl gaga! Your personal stuffs excellent. All the time deal with it up!

  • Good day! Do you know if they make any plugins to assist with SEO? I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very good success. If you know of any please share. Thanks!

  • Hi my friend! I want to say that this article is amazing, nice written and include almost all important infos. I would like to see more posts like this.

  • You could certainly see your skills within the work you write. The arena hopes for even more passionate writers such as you who aren’t afraid to mention how they believe. All the time follow your heart.

  • My wife and i have been very thankful when Raymond could do his preliminary research using the precious recommendations he obtained using your web page. It is now and again perplexing just to continually be releasing guides which often most people might have been selling. So we know we’ve got the writer to give thanks to because of that. The entire explanations you made, the easy site navigation, the relationships your site assist to foster – it’s many impressive, and it’s really letting our son and our family consider that this topic is interesting, and that’s tremendously pressing. Thanks for the whole lot!

  • We stumbled over here different page and thought I should check things out. I like what I see so now i’m following you. Look forward to checking out your web page repeatedly.

  • Nice weblog here! Also your web site lots up fast! What host are you the usage of? Can I am getting your affiliate hyperlink in your host? I want my site loaded up as quickly as yours lol

  • I hope your week has started out good. I have a new list for you all. This list has more links than the others. Happy link building!

  • Thanks, I’ve just been looking for information approximately this subject forages and yours is the greatest I’ve found out so far.However, what about the conclusion? Are you certain in regards to the source?

  • Bonsoir GinetteIls ont fait pire, en octobre 2011 j’envoyais reguliérement des emails à ce mouvement pour ce mobiliser contre la guerre de l’Otan en Libye.Voiçi ce que j’ai reçu d’eux :Christophe le WebmestreENLEVEZ-MOI DE VOTRE LISTE IMMEDIATEMENTD’autre part à la manifestation du 15 ocotbre 2011 à Paris ils n’étaient pas présent non plus.

  • My partner and I stumbled over here coming from a different web address and thought I may as well check things out. I like what I see so now i am following you. Look forward to looking into your web page again.|

  • Hmm it looks like your blog ate my first comment (it was extremely long) so I guess I’ll just sum it up what I submitted and say, I’m thoroughly enjoying your blog. I too am an aspiring blog blogger but I’m still new to the whole thing. Do you have any recommendations for inexperienced blog writers? I’d definitely appreciate it.

  • Thank you for the good writeup. It in fact was aamusement account it. Look advanced to more added agreeable from you!However, how can we communicate?

  • Hello there, I found your website via Google while searching for a related topic, your web site came up, it looks good. I’ve bookmarked it in my google bookmarks.

  • Ahaa, its fastidious discussion on the topic of this posthere at this web site, I have read all that, so nowme also commenting at this place.

  • I wanted to post you one very small remark just to thank you over again on the fantastic things you have shown in this article. It is certainly incredibly open-handed with people like you in giving unhampered what many individuals would’ve supplied as an ebook to get some money on their own, chiefly considering that you could have done it in the event you considered necessary. The techniques likewise served to be a fantastic way to comprehend many people have similar keenness much like my personal own to realize great deal more in respect of this matter. Certainly there are thousands of more fun occasions in the future for individuals that view your website.

  • This is the perfect site for anybody who hopes to find outabout this topic. You know soo much its almost tough toargue with you (not that I personally wold want to…HaHa).You definitely put a fresh spin on a topic that has been written about for a long time.Excellent stuff, just excellent!

  • I truly appreciate this post. I have been looking all over for this! Thank goodness I found it on Bing. You’ve made my day! Thx again

  • Thanks for the good writeup. It in truth used to be a amusement accountit. Look advanced to far delivered agreeable from you! By the way, how could we keep in touch?

  • Hello! I could have sworn I’ve been to this blog before but after checking through some of the post I realized it’s new to me. Nonetheless, I’m definitely happy I found it and I’ll be bookmarking and checking back often!

  • Thank you for the good writeup. It in fact was a amusement account it. Look advanced to far added agreeable from you! By the way, how can we communicate?

  • Hello.This article was really remarkable, particularly because I was searching for thoughts on this topic last couple of days.

  • Do you have a spam issue on this blog; I also am a blogger, and I was wanting to know your situation; many of us have developed some nice procedures and we are looking to swap methods with other folks, be sure to shoot me an email if interested.

  • An outstanding share! I’ve just forwarded this ontoa friend who was doing a little research on this. And he in fact boughtme dinner due to the fact that I found it for him… lol.So allow me to reword this…. Thank YOU for the meal!! But yeah, thanks for spending the time to discuss this topic here on your web page.

  • Hi, I do think this is an excellent site. I stumbledupon it 😉 I will return yet again since i have book-marked it. Money and freedom is the greatest way to change, may you be rich and continue to help others.

  • Excellent items from you, man. I have be mindful your stuff prior to and you are just extremely fantastic. I actually like what you’ve bought here, certainly like what you are saying and the way during which you assert it. You make it entertaining and you continue to care for to stay it smart. I cant wait to read far more from you. This is actually a tremendous web site.

  • Almost all of what you claim happens to be astonishingly appropriate and it makes me ponder why I had not looked at this in this light before. This particular article truly did switch the light on for me as far as this particular issue goes. However at this time there is actually just one position I am not really too comfortable with and while I try to reconcile that with the central idea of your issue, allow me observe just what all the rest of the subscribers have to point out.Very well done.

  • Hi, i feel that i noticed you visited my weblog so i got here to “return the prefer”.I’m attempting to to find things to improve my web site!I assume its adequate to use a few of your ideas!!

  • Do you mind if I quote a couple of your articles as long as I provide credit and sources back to your blog? My blog is in the exact same niche as yours and my users would definitely benefit from a lot of the information you present here. Please let me know if this alright with you. Thanks a lot!

  • This website is known as a walk-by means of for all of the info you wished about this and didn’t know who to ask. Glimpse here, and also you’ll undoubtedly discover it.

  • I was wondering if you ever considered changing the structure of your site? Its very well written; I love what youve got to say. But maybe you could a little more in the way of content so people could connect with it better. Youve got an awful lot of text for only having 1 or two images. Maybe you could space it out better?

  • of course like your web-site but you have to check the spelling on quite a few of your posts. Many of them are rife with spelling issues and I find it very bothersome to tell the truth nevertheless I’ll definitely come back again.

  • When I initially commented I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get three emails with the same comment. Is there any way you can remove people from that service? Thank you!

  • Great – I should definitely pronounce, impressed with your website. I had no trouble navigating through all tabs and related info ended up being truly easy to do to access. I recently found what I hoped for before you know it at all. Quite unusual. Is likely to appreciate it for those who add forums or something, website theme . a tones way for your client to communicate. Excellent task..

  • You can certainly see your enthusiasm within the work you write. The arena hopes for more passionate writers like you who are not afraid to mention how they believe. All the time go after your heart.

  • What i do not realize is actually how you’re not actually much more well-liked than you may be now. You’re so intelligent. You realize therefore considerably relating to this subject, made me personally consider it from so many varied angles. Its like women and men aren’t fascinated unless it’s one thing to accomplish with Lady gaga! Your own stuffs outstanding. Always maintain it up!

  • Hello, Neat post. There is a problem along with your site in internet explorer, might test this… IE nonetheless is the market leader and a huge part of people will pass over your fantastic writing due to this problem.

  • great points altogether, you simply gained a brand new reader. What would you suggest in regards to your post that you made a few days ago? Any positive?

  • It’s a pity you don’t have a donate button! I’d definitely donate to this outstanding blog! I guess for now i’ll settle for bookmarking and adding your RSS feed to my Google account. I look forward to brand new updates and will share this site with my Facebook group. Talk soon!

  • Thanks for a marvelous posting! I genuinely enjoyed reading it, you might be a great author.I will remember to bookmark your blog and will often come back sometime soon. I want to encourage that you continue your great work, have a nice afternoon!

  • In the awesome design of things you actually receive a B+ just for hard work. Where you actually lost everybody ended up being on all the specifics. You know, people say, details make or break the argument.. And it couldn’t be more correct in this article. Having said that, permit me tell you precisely what did deliver the results. Your writing is extremely engaging and that is possibly the reason why I am making the effort to comment. I do not really make it a regular habit of doing that. Next, even though I can easily see a jumps in reason you make, I am definitely not certain of how you seem to connect your details which inturn produce your final result. For now I will, no doubt subscribe to your issue however hope in the future you link your facts much better.

  • Cool blog! Is your theme custom made or did you download it from somewhere? A theme like yours with a few simple tweeks would really make my blog jump out. Please let me know where you got your design. Cheers

  • You can definitely see your expertise in the work you write. The world hopes for more passionate writers like you who are not afraid to say how they believe. Always follow your heart.

  • Thanks for another excellent post. Where else could anyone get that type of info in such a perfect way of writing? I have a presentation next week, and I am on the look for such info.

  • It’s a shame you don’t have a donate button! I’d definitely donate to this brilliant blog! I suppose for now i’ll settle for book-marking and adding your RSS feed to my Google account. I look forward to brand new updates and will share this site with my Facebook group. Talk soon!

  • hi!,I love your writing very much! percentage we be in contact extra approximately your post on AOL? I require a specialist in this space to solve my problem. Maybe that’s you! Looking forward to peer you.

  • Appreciating the hard work you put into your blog and detailed information you offer. It’s awesome to come across a blog every once in a while that isn’t the same outdated rehashed material. Wonderful read! I’ve bookmarked your site and I’m including your RSS feeds to my Google account.

  • Excellent blog here! Also your website loads up fast! What host are you using? Can I get your affiliate link to your host? I wish my web site loaded up as fast as yours lol

  • Thank you for the good writeup. It in fact was a amusement account it. Look advanced to more added agreeable from you! However, how could we communicate?

  • A formidable share, I just given this onto a colleague who was doing a bit of analysis on this. And he actually purchased me breakfast as a result of I found it for him.. smile. So let me reword that: Thnx for the treat! But yeah Thnkx for spending the time to discuss this, I really feel strongly about it and love reading extra on this topic. If doable, as you change into experience, would you mind updating your blog with more particulars? It is extremely useful for me. Large thumb up for this blog submit!

  • Hello there, just became alert to your blog through Google, and found that it’s really informative. I am going to watch out for brussels. I will appreciate if you continue this in future. Numerous people will be benefited from your writing. Cheers!

  • I think this is among the most vital info for me. And i’m glad reading your article. But should remark on some general things, The site style is ideal, the articles is really excellent : D. Good job, cheers

  • Hey! Someone in my Myspace group shared this website with us so I came to give it a look. I’m definitely enjoying the information. I’m book-marking and will be tweeting this to my followers! Terrific blog and great style and design.

  • Hey! Do you use Twitter? I’d like to follow you if that would be okay. I’m undoubtedly enjoying your blog and look forward to new posts.

  • Wow, incredible weblog layout! How long have you been blogging for? you make blogging look easy. The overall look of your site is great, let alone the content material!

  • You can certainly see your enthusiasm within the paintings you write. The world hopes for even more passionate writers like you who aren’t afraid to mention how they believe. At all times follow your heart.

  • I keep listening to the news bulletin speak about getting boundless online grant applications so I have been looking around for the best site to get one. Could you tell me please, where could i acquire some?

  • Great post. I used to be checking constantly this weblog and I am inspired! Extremely useful info particularly the ultimate phase 🙂 I take care of such info much. I was looking for this certain information for a very lengthy time. Thank you and best of luck.

  • I used to be suggested this blog by way of my cousin. I’m no longer certain whether this put up is written by means of him as no one else realize such designated approximately my problem. You’re incredible! Thank you!

  • I am curious to find out what blog platform you are working with? I’m having some minor security problems with my latest site and I would like to find something more secure. Do you have any solutions?

  • The very root of your writing whilst sounding reasonable initially, did not really settle very well with me personally after some time. Somewhere throughout the paragraphs you were able to make me a believer unfortunately just for a while. I nevertheless have a problem with your jumps in assumptions and one might do nicely to fill in those breaks. When you can accomplish that, I will surely be impressed.

  • The core of your writing while sounding agreeable initially, did not work very well with me after some time. Somewhere throughout the sentences you managed to make me a believer but just for a very short while. I however have a problem with your jumps in logic and one would do nicely to fill in all those gaps. In the event you can accomplish that, I could certainly be fascinated.

  • I was curious if you ever considered changing the structure of your blog? Its very well written; I love what youve got to say. But maybe you could a little more in the way of content so people could connect with it better. Youve got an awful lot of text for only having 1 or 2 images. Maybe you could space it out better?

  • Hi, i think that i saw you visited my site thus i came to “return the favor”.I am trying to find things to enhance my site!I suppose its ok to use some of your ideas!!

  • When I originally commented I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get several e-mails with the same comment. Is there any way you can remove people from that service? Thanks a lot!

  • Does your site have a contact page? I’m having a tough time locating it but, I’d like to send you an email. I’ve got some creative ideas for your blog you might be interested in hearing. Either way, great website and I look forward to seeing it develop over time.

  • Hello, i feel that i noticed you visited my weblog so i came to “return the prefer”.I’m trying to to find things to improve my website!I assume its ok to make use of some of your concepts!!

  • You actually make it seem so easy along with your presentation but I find this topic to be actually something that I feel I would by no means understand. It kind of feels too complicated and very broad for me. I am looking forward in your subsequent put up, I will try to get the grasp of it!

  • I just could not leave your website prior to suggesting that I really loved the standard info a person supply to your visitors? Is going to be again regularly in order to check up on new posts

  • Throughout this great scheme of things you actually receive a B+ just for hard work. Where exactly you actually misplaced everybody was on your facts. You know, people say, details make or break the argument.. And that could not be much more true in this article. Having said that, permit me say to you exactly what did do the job. The writing is definitely quite engaging and this is most likely the reason why I am taking the effort in order to comment. I do not really make it a regular habit of doing that. 2nd, even though I can certainly notice a jumps in logic you come up with, I am not confident of exactly how you appear to unite the details which in turn make your final result. For right now I shall subscribe to your point however trust in the foreseeable future you connect your dots better.

  • I am curious to find out what blog system you happen to be working with? I’m having some small security problems with my latest website and I’d like to find something more safe. Do you have any solutions?

  • This is the precise weblog for anybody who needs to search out out about this topic. You notice a lot its almost arduous to argue with you (not that I actually would need…HaHa). You definitely put a brand new spin on a subject thats been written about for years. Nice stuff, just great!

  • Heya i’m for the first time here. I found this board and I find It truly useful & it helped me out a lot. I hope to give something back and help others like you helped me.

  • hello!,I like your writing very much! share we communicate more about your article on AOL? I need an expert on this area to solve my problem. Maybe that’s you! Looking forward to see you.

  • Valuable info. Lucky me I found your website by accident, and I am shocked why this accident didn’t happened earlier! I bookmarked it.

  • I really like what you guys are usually up
    too. This kind of clever work and exposure! Keep up
    the superb works guys I’ve added you guys to our blogroll.

  • Howdy I am so happy I found your blog page, I really found you
    by mistake, while I was researching on Askjeeve for something else, Anyhow I
    am here now and would just like to say thanks for a
    remarkable post and a all round interesting blog (I also love the theme/design), I don’t have time
    to read it all at the minute but I have book-marked it and also
    included your RSS feeds, so when I have time I will be back to
    read much more, Please do keep up the awesome b.

  • you’re in point of fact a excellent webmaster.
    The website loading pace is incredible. It sort of feels that you are doing any distinctive trick.
    In addition, The contents are masterpiece. you
    have performed a wonderful task on this subject!

  • I got this web site from my pal who shared with me concerning this web page
    and now this time I am visiting this website and reading very informative
    posts at this time.

  • I wish to express thanks to this writer for rescuing me from this particular predicament. Right after looking through the the net and seeing ways which are not productive, I assumed my life was over. Living devoid of the strategies to the issues you’ve solved through your good short article is a crucial case, as well as those which might have badly damaged my entire career if I hadn’t noticed your blog. Your own personal capability and kindness in handling all areas was important. I’m not sure what I would’ve done if I had not encountered such a subject like this. I am able to now look ahead to my future. Thanks a lot very much for your professional and amazing guide. I will not be reluctant to endorse your web site to anybody who wants and needs recommendations about this subject matter.

  • Nice read, I just passed this onto a friend who was doing some research on that. And he just bought me lunch because I found it for him smile So let me rephrase that: Thank you for lunch!

  • This is the right blog for anyone who wants to seek out out about this topic. You realize so much its almost exhausting to argue with you (not that I truly would want…HaHa). You definitely put a new spin on a subject thats been written about for years. Nice stuff, simply nice!

  • I’m curious to find out what blog system you have been utilizing? I’m having some small security issues with my latest site and I’d like to find something more safeguarded. Do you have any suggestions?

  • Oh my goodness! an incredible article dude. Thanks Nevertheless I’m experiencing problem with ur rss . Don’t know why Unable to subscribe to it. Is there anybody getting similar rss drawback? Anybody who knows kindly respond. Thnkx

  • I have been exploring for a little bit for any high quality articles or weblog posts on this sort of area . Exploring in Yahoo I finally stumbled upon this site. Reading this info So i’m glad to express that I’ve an incredibly good uncanny feeling I came upon just what I needed. I so much unquestionably will make certain to do not disregard this site and provides it a glance on a continuing basis.

  • I’ve been surfing online more than three hours today, yet I never found any interesting article like yours. It’s pretty worth enough for me. In my view, if all site owners and bloggers made good content as you did, the net will be a lot more useful than ever before.

  • Pretty great post. I just stumbled upon your blog and wanted to say that I have truly loved browsing your blog posts. After all I will be subscribing in your feed and I’m hoping you write again very soon!

  • I have not checked in here for some time since I thought it was getting boring, but the last several posts are good quality so I guess I’ll add you back to my everyday bloglist. You deserve it my friend 🙂

  • Superb blog! Do you have any tips and hints for aspiring writers? I’m planning to start my own blog soon but I’m a little lost on everything. Would you propose starting with a free platform like WordPress or go for a paid option? There are so many options out there that I’m completely overwhelmed .. Any tips? Many thanks!

  • コメントを残す

    メールアドレスが公開されることはありません。