-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
significantly
-
R
calculated SD vs Data Analysis
Hello, When I calculate the standard deviation for a set of numbers, I get a different amount then when I use the "Data Analysis" on the data tab. Why is that? For instance, when I calculate the SD for 1, 2, 3, 4, 5, 6 I get 1.707825 but the data analysis gives me 1.870828. This is...- robertdseals
- Thread
- analysis calculate correct data significantly
- Replies: 2
- Forum: Excel Questions
-
Alternate to COUNTIF(E$6:E6,E6)
I have a huge data set and i need to identify duplicate . I am using the formula COUNTIF(E$6:E6,E6) but this formula slows the calculation significantly in huge list approx 65000 rows. Is there any fastest formula ?- earthworm
- Thread
- countife$6e6 formula huge list significantly
- Replies: 13
- Forum: Excel Questions
-
M
If Statement with Named Range
Hello, I am wanting to use a named range in a IF statement to significant shorten the formula. This is what I am currently using, but would need to expand the formula significantly to gather the information I need...- murphyjeff4
- Thread
- formula named range significantly statement
- Replies: 7
- Forum: Excel Questions
-
Forum Loading Speed
Is anyone else experiencing dramatically slower loading speeds on the forums since the update yesterday? It is taking a significantly longer time (upwards of 20-30 seconds) for any page to refresh or for a reply to post.- MrKowz
- Thread
- loading longer seconds significantly time
- Replies: 13
- Forum: About This Board
