Excel Magic Trick 145 p4 STDEV IF Standard Deviation IF

[MSUSTEVE1984]

Great Video!

[ExcelIsFun]

@MSUSTEVE1984 , I am glad that you like it!

[MontrealIranians]

I came here to learn about the conditional STEDV, which was great, and got to know these pivot tables which was a huge breakthrough!

A million thanks buddy.

[ExcelIsFun]

You are welcome! It is all put together in a logical order in my new book:

"Slaying Excel Dragons" (Amazon, $19, 550 pages)

[jesuboi]

excel really is fun!

thx a lot

[ExcelIsFun]

You are welcome!

[BirthDateUnknown]

you are a god!! add me to the list of scholar practitioners who consider you a math hero!!

md-gonzales@comcast.net

[ExcelIsFun]

I am glad that the video helped!

[myunlu1]

hi there I was wondering if you could please let me know on excel if there is a way that i can change positive numbers to negative or negative numbers to positive.thanks !

[ExcelIsFun]

If for values in cells:

1) type -1 in some cell

2) copy the cell

3) highlight values you want to convert

4) right-click, Paste Special

5) Click multiply dialog button in the Operations area

6) Click OK.

[DraconisA15]

Great video. I got it as the 4th google result when I typed in "stdevif"

[ExcelIsFun]

Cool!

Google is the best!

[pravinparvekar]

hello sir use ur videos alot that has helped me to

but now i m stuck

how to use array in if function for extacting names

[ExcelIsFun]

Search for this playlist with many videos on this topic:

Excel Extract Records From Database Table / List

[ENZOrockstar]

Awesome! Very useful for my stats class!

[ExcelIsFun]

I am glad that it is useful!

[atfuller17]

Thanks - this is exactly what I was looking for - and it was on the first page of a google search. Much appreciated!

[ExcelIsFun]

You are welcome! I am glad that it helped.

When you searched Google, two questions:

1) what did you type in?

2) were you searching web or video?