This will return `TRUE` for `#VALUE!` errors (ERROR.TYPE = 3) and `FALSE` for anything else.

    =IF(ISERROR(A1),ERROR.TYPE(A1)=3)

in EXCEL 2013 i had to use IF function 2 times:
1st to identify error with ISERROR
and 2nd to identify the specific type of error by ERROR.TYPE=3 in order to address this type of error. This way you can differentiate between error you want and other types.

After reading [this article][1] I decided to take a closer look at the way I was using Dapper.

I ran this code on an empty database

	var members = new List&lt;Member&gt;();
	for (int i = 0; i &lt; 50000; i++)
	{
		members.Add(new Member()
		{
			Username = i.toString(),
			IsActive = true
		});
	}

	using (var scope = new TransactionScope())
	{
		connection.Execute(@&quot;
	insert Member(Username, IsActive)
	values(@Username, @IsActive)&quot;, members);

		scope.Complete();
	}

it took about 20 seconds. That&#39;s 2500 inserts/second. Not bad, but not great either considering the blog was achieving 45k inserts/second. Is there a more efficient way to do this in Dapper?

Also, as a side note, running this code through the Visual Studio debugger took **over 3 minutes!** I figured the debugger would slow it down a little, but I was really surprised to see that much.


**UPDATE**

So this

	using (var scope = new TransactionScope())
	{
		connection.Execute(@&quot;
	insert Member(Username, IsActive)
	values(@Username, @IsActive)&quot;, members);

		scope.Complete();
	}

and this

		connection.Execute(@&quot;
	insert Member(Username, IsActive)
	values(@Username, @IsActive)&quot;, members);

both took 20 seconds.

But this took 4 seconds!

    SqlTransaction trans = connection.BeginTransaction();
    
    connection.Execute(@&quot;
    insert Member(Username, IsActive)
    values(@Username, @IsActive)&quot;, members, transaction: trans);
    
    trans.Commit();


  [1]: https://www.gamasutra.com/view/news/170502/Indepth_SQL_Server__High_performance_inserts.php

Bulk inserts taking longer than expected using Dapper

I am using code sample from [Making Sense of Multitouch][1]
[1]: http://android-developers.blogspot.in/2010/06/making-sense-of-multitouch.html
for zooming image view. On ScaleListener I added `ScaleGestureDetector.getFocusX() and getFocusY()`for content to zoom about the focal point of the gesture. It is working fine. 

***The problem is, on first multitouch the entire Image drawing position is changing to the current touch point and zooming it from there. Could you help me to resolve this issue?***

Here is My Code Sample For TouchImageView.

    public class TouchImageViewSample extends ImageView {

	private Paint borderPaint = null;
	private Paint backgroundPaint = null;

	private float mPosX = 0f;
	private float mPosY = 0f;

	private float mLastTouchX;
	private float mLastTouchY;
	private static final int INVALID_POINTER_ID = -1;
	private static final String LOG_TAG = &quot;TouchImageView&quot;;

	// The ‘active pointer’ is the one currently moving our object.
	private int mActivePointerId = INVALID_POINTER_ID;

	public TouchImageViewSample(Context context) {
		this(context, null, 0);
	}

	public TouchImageViewSample(Context context, AttributeSet attrs) {
		this(context, attrs, 0);
	}

	private ScaleGestureDetector mScaleDetector;
	private float mScaleFactor = 1.f;

	// Existing code ...
	public TouchImageViewSample(Context context, AttributeSet attrs, int defStyle) {
		super(context, attrs, defStyle);
		// Create our ScaleGestureDetector
		mScaleDetector = new ScaleGestureDetector(context, new ScaleListener());

		borderPaint = new Paint();
		borderPaint.setARGB(255, 255, 128, 0);
		borderPaint.setStyle(Paint.Style.STROKE);
		borderPaint.setStrokeWidth(4);

		backgroundPaint = new Paint();
		backgroundPaint.setARGB(32, 255, 255, 255);
		backgroundPaint.setStyle(Paint.Style.FILL);

	}

	@Override
	public boolean onTouchEvent(MotionEvent ev) {
		// Let the ScaleGestureDetector inspect all events.
		mScaleDetector.onTouchEvent(ev);

		final int action = ev.getAction();
		switch (action &amp; MotionEvent.ACTION_MASK) {
		case MotionEvent.ACTION_DOWN: {
			final float x = ev.getX();
			final float y = ev.getY();

			mLastTouchX = x;
			mLastTouchY = y;

			mActivePointerId = ev.getPointerId(0);
			break;
		}

		case MotionEvent.ACTION_MOVE: {
			final int pointerIndex = ev.findPointerIndex(mActivePointerId);
			final float x = ev.getX(pointerIndex);
			final float y = ev.getY(pointerIndex);

			// Only move if the ScaleGestureDetector isn&#39;t processing a gesture.
			if (!mScaleDetector.isInProgress()) {
				final float dx = x - mLastTouchX;
				final float dy = y - mLastTouchY;

				mPosX += dx;
				mPosY += dy;

				invalidate();
			}

			mLastTouchX = x;
			mLastTouchY = y;
			break;
		}

		case MotionEvent.ACTION_UP: {
			mActivePointerId = INVALID_POINTER_ID;
			break;
		}

		case MotionEvent.ACTION_CANCEL: {
			mActivePointerId = INVALID_POINTER_ID;
			break;
		}

		case MotionEvent.ACTION_POINTER_UP: {
			final int pointerIndex = (ev.getAction() &amp; MotionEvent.ACTION_POINTER_INDEX_MASK) &gt;&gt; MotionEvent.ACTION_POINTER_INDEX_SHIFT;
			final int pointerId = ev.getPointerId(pointerIndex);
			if (pointerId == mActivePointerId) {
				// This was our active pointer going up. Choose a new
				// active pointer and adjust accordingly.
				final int newPointerIndex = pointerIndex == 0 ? 1 : 0;
				mLastTouchX = ev.getX(newPointerIndex);
				mLastTouchY = ev.getY(newPointerIndex);
				mActivePointerId = ev.getPointerId(newPointerIndex);
			}
			break;
		}
		}

		return true;
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see android.view.View#draw(android.graphics.Canvas)
	 */
	@Override
	public void draw(Canvas canvas) {
		super.draw(canvas);
		canvas.drawRect(0, 0, getWidth() - 1, getHeight() - 1, borderPaint);
	}

	@Override
	public void onDraw(Canvas canvas) {
		canvas.drawRect(0, 0, getWidth() - 1, getHeight() - 1, backgroundPaint);
		if (this.getDrawable() != null) {
			canvas.save();
			canvas.translate(mPosX, mPosY);

			Matrix matrix = new Matrix();
			matrix.postScale(mScaleFactor, mScaleFactor, pivotPointX,
					pivotPointY);
			// canvas.setMatrix(matrix);

			canvas.drawBitmap(
					((BitmapDrawable) this.getDrawable()).getBitmap(), matrix,
					null);

			// this.getDrawable().draw(canvas);
			canvas.restore();
		}
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see
	 * android.widget.ImageView#setImageDrawable(android.graphics.drawable.Drawable
	 * )
	 */
	@Override
	public void setImageDrawable(Drawable drawable) {
		// Constrain to given size but keep aspect ratio
		int width = drawable.getIntrinsicWidth();
		int height = drawable.getIntrinsicHeight();
		mLastTouchX = mPosX = 0;
		mLastTouchY = mPosY = 0;

		int borderWidth = (int) borderPaint.getStrokeWidth();
		mScaleFactor = Math.min(((float) getLayoutParams().width - borderWidth)
				/ width, ((float) getLayoutParams().height - borderWidth)
				/ height);
		pivotPointX = (((float) getLayoutParams().width - borderWidth) - (int) (width * mScaleFactor)) / 2;
		pivotPointY = (((float) getLayoutParams().height - borderWidth) - (int) (height * mScaleFactor)) / 2;
		super.setImageDrawable(drawable);
	}

	float pivotPointX = 0f;
	float pivotPointY = 0f;

	private class ScaleListener extends
			ScaleGestureDetector.SimpleOnScaleGestureListener {

		@Override
		public boolean onScale(ScaleGestureDetector detector) {
			mScaleFactor *= detector.getScaleFactor();

			pivotPointX = detector.getFocusX();
			pivotPointY = detector.getFocusY();
			
			Log.d(LOG_TAG, &quot;mScaleFactor &quot; + mScaleFactor);
			Log.d(LOG_TAG, &quot;pivotPointY &quot; + pivotPointY + &quot;, pivotPointX= &quot;
					+ pivotPointX);
			mScaleFactor = Math.max(0.05f, mScaleFactor);

			invalidate();
			return true;
		}
	}

And here how I used it within my activity.

    ImageView imageView = (ImageView) findViewById(R.id.imgView);

	int hMargin = (int) (displayMetrics.widthPixels * .10);
	int vMargin = (int) (displayMetrics.heightPixels * .10);

	RelativeLayout.LayoutParams params = new RelativeLayout.LayoutParams(displayMetrics.widthPixels - (hMargin * 2), (int)(displayMetrics.heightPixels - btnCamera.getHeight()) - (vMargin * 2));
	params.leftMargin = hMargin;
	params.topMargin =  vMargin;
	imageView.setLayoutParams(params);
	imageView.setImageDrawable(drawable);

Android Image View Pinch Zooming

I&#39;d like to write a formula such that if cell A1 displays `#VALUE!`, say `TRUE` in cell B1.

Here&#39;s my formula in cell B1:

    =IF(A1=&quot;#VALUE!&quot;, &quot;TRUE&quot;, &quot;FALSE&quot;)

I get `FALSE` when A1 does not say `#VALUE!` so that part is fine.  But, when it does say `#VALUE!`, I get a `#VALUE!` error in cell B1, when I want it to say `TRUE`.  How do I do this?

How do I recognize &quot;#VALUE!&quot; in Excel spreadsheets?

I'd like to write a formula such that if cell A1 displays <code>#VALUE!</code>, say <code>TRUE</code> in cell B1.
Here's my formula in cell B1:
<pre><code class="hljs language-ini">=IF(A1="#VALUE!", "TRUE", "FALSE")
</code></pre>
I get <code>FALSE</code> when A1 does not say <code>#VALUE!</code> so that part is fine. But, when it does say <code>#VALUE!</code>, I get a <code>#VALUE!</code> error in cell B1, when I want it to say <code>TRUE</code>. How do I do this?

I&#39;ve heard much about the understandable abhorrence of using `.Select` in Excel VBA, but I am unsure of how to avoid using it. I am finding that my code would be more re-usable if I were able to use variables instead of `Select` functions. However, I am not sure how to refer to things (like the `ActiveCell`, etc.) if not using `Select`.

I have found [this article on ranges][1] and [this example on the benefits of not using select][2], but I can&#39;t find anything on *how*.

  [1]: http://msdn.microsoft.com/en-us/library/aa139976%28v=office.10%29.aspx
  [2]: http://www.businessprogrammer.com/201105/power-excel-vba-secret-avoid-using-select/



How to avoid using Select in Excel VBA

If I have an auto filter set up in Excel and I want to loop through all the visible data in one column with VBA code, what&#39;s the easiest way to do this? 

All the hidden rows that have been filtered away should not be included, so a plain Range from top to bottom doesn&#39;t help. 

Any good ideas? 

Easiest way to loop through a filtered list with VBA?

I have the following information:

      Height	Weight

        170     65
        167 	55
        189 	85
        175 	70
        166 	55
        174 	55
        169 	69
        170     58
        184     84
        161  	56
        170  	75
        182 	68
        167 	51
        187 	85
        178     62
        173     60
        172     68
        178     55
        175     65
        176     70

I want to construct quadratic and cubic regression analysis in Excel. I know how to do it by linear regression in Excel, but what about quadratic and cubic? I have searched a lot of resources, but could not find anything helpful.

Quadratic and cubic regression in Excel

What is the meaning of the use of the `#` symbol in Excel VBA?

It is used like this:

     a = b /100#

I don&#39;t understand the significance of `#` after the `100`?

Use of symbol # (hash) in VBA Macro

I want to &quot;freeze&quot; Row 1 and Column A simultaneously in Excel 2010. 

Is this possible?

Freezing Row 1 and Column A at the same time

When I want to find the last used cell value, I use: 

    Dim LastRow As Long
    
    LastRow = Range(&quot;E4:E48&quot;).End(xlDown).Row
    
    Debug.Print LastRow

I&#39;m getting the wrong output when I put a single element into a cell. But when I put more than one value into the cell, the output is correct. 
What&#39;s the reason behind this?

Error in finding last used cell in Excel with VBA

This seems like a simple Pivot Table to learn with.  I would like to do a count of unique values for a particular value I&#39;m grouping on.

For instance, I have this:

    ABC   123
    ABC   123
    ABC   123
    DEF   456
    DEF   567
    DEF   456
    DEF   456

What I want is a pivot table that shows me this:

    ABC   1
    DEF   2

The simple pivot table that I create just gives me this (a count of how many rows):

    ABC   3
    DEF   4  

But I want the number of unique values instead.

What I&#39;m really trying to do is find out which values in the first column don&#39;t have the same value in the second column for all rows.  In other words, &quot;ABC&quot; is &quot;good&quot;, &quot;DEF&quot; is &quot;bad&quot;

I&#39;m sure there is an easier way to do it but thought I&#39;d give pivot table a try...

Simple Pivot Table to Count Unique Values

Suppose I have: 

 1.  a value of 5 in `B1`
 2.  I want to pass the number (5) in `B1` as a row variable, which will be read in conjunction with column `A` into another cell (say `C1`) as &quot;=A(B1)&quot; i.e. &quot;=A5&quot;
   
How would I do this?

Pass row number as variable in excel sheet

I have a column of values that often appear as duplicates. I need to create a new column, of unique values based on the first column, as follows:

    Column A   Column B  
    a          a
    a          b
    b          c
    c
    c

This Column B will actually need to appear on a different sheet, within the same workbook, so I assume it will need to work with the `sheet2!A1` style format.

I have not had any luck with the Data/Filter menu options as this only seems to work on command. I need column B to update automatically whenever a new value is entered into column A. 

Ignore Duplicates and Create New List of Unique Values in Excel

I have a very large excel spread sheet that has a column of time stamps. Does anyone know convert that over to a date? Is there a function I can use? I tried format cell date but that doesn&#39;t work. My file is 91,568 KB. If there is a simpler way to this that would be great. I&#39;m open to ideas.

Thank you in advance :)

P.S.
I don&#39;t know any programming languages

Content Type	Original Author	Original Content on Stackoverflow
Question	phan	View Question on Stackoverflow
Solution 1 - Excel	Charleh	View Answer on Stackoverflow
Solution 2 - Excel	Excellll	View Answer on Stackoverflow
Solution 3 - Excel	Mirec Tkáč	View Answer on Stackoverflow

How do I recognize "#VALUE!" in Excel spreadsheets?

Excel Problem Overview

Excel Solutions

Solution 1 - Excel

Solution 2 - Excel

Solution 3 - Excel

Android Image View Pinch Zooming

Bulk inserts taking longer than expected using Dapper

Attributions