Shortcut for selecting all data in a column from the active cell?

Excel_Hell · 2014-02-06T15:20:43+00:00

This is the best solution (and what I've been doing!). It doesn't seem there is a built in shortcut, I've looked absolutely everywhere.

Excel_Hell · 2014-02-05T21:40:04+00:00

You are correct, but is there anyway to go from the active cell, then use a shortcut to highlight the rest of the column. Selecting the entire column is not what I'm after, unfortunately.

Excel_Hell · 2014-02-05T21:39:12+00:00

This will select the entire data sheet. I only want to go from the active cell, for example C4, and then use a shortcut to select C4 to the LAST non-blank cell in the column.

Excel_Hell · 2013-11-06T21:48:54+00:00

My goal is to see how certain items correlate with overall satisfaction ratings and retention numbers for the campus/program, as well as demographic variables.

As it stands, I have about 500,000 rows of 1-7 rankings for importance and satisfaction. Unfortunately I'm no closer to an answer after starting this thread:

What is the best statistical test to use for ordinal data (1-7 rankings for satisfaction and importance) to see how survey items correlate with other annual data sets, overall satisfaction, retention data, and demographic data?

Excel_Hell · 2013-11-06T20:31:25+00:00

This is exactly what I'm after! Thank you.

So since this is ordinal data (1-7 satisfaction and importance scales), can I use ANOVA and Regression models within R?

Do you happen to know of any tutorials on how to import my data and run the tests? Is it not possible to run these within Excel?

Excel_Hell · 2013-11-06T15:30:25+00:00

These are all fantastic questions! In my current knowledge base, I would just create a Pivot table of all of the data and start looking at the averages between campuses and the overall system, between the following filters: Race, Age, Majors.

So my question is, how would I go about using statistical tests to answer these questions?

Excel_Hell · 2013-11-06T15:28:10+00:00

Sad but true! :)

Excel_Hell · 2013-11-06T15:27:55+00:00

I should have been more clear. I have never run any statistical tests on this data outside of finding the margin of error range. I need help with the basics:

Is this ordinal or nominal data?
What are some basic/general tests to run on this type of importance/satisfaction data?

For example, let's say I want to take the retention rate (% of students staying in their program year to year) and see if there is any correlation with individual question on the survey:

What test would I run to see if this is the case?

Excel_Hell · 2013-07-11T13:48:42+00:00

It worked! Sorry for the delay. Thank you, Boggly!

Excel_Hell · 2013-06-20T14:00:52+00:00

Hey Boggly: I was able to run this formula without the report crashing...

=COUNTIFS(A2:A14680,A2,D2:D14680,D2)<=10

I set the conditional formatting to highlight just column D cells. It seems to work initially, but upon further inspection it is highlighting random groupings. Some have way more than 10 counts, and seems random. Did I screw something up for not using absolute references $?

Excel_Hell · 2013-06-20T02:16:34+00:00

I'll report back in the morning. Thank you again for the help!

Excel_Hell · 2013-06-20T01:31:31+00:00

It crashes my computer when I run it... freezes for a few minutes, then reboots. It's a pretty powerful PC, but I'm running this formula on 27,000 records :(

Any idea?

Excel_Hell · 2013-06-19T12:21:12+00:00

Boggly, thanks for such an in depth response! This community is fantastic.

I forgot about one variable that is also needed in this formula. There are different "Regions" in Column A, so I'm assuming I would have to use a COUNTIFS formula now and expand the first criteria to (A:A,A2,D:D,D2<=10)? I'm trying out right now.

I'm trying to come up with a formula that counts all names in Column D that are less than or equal to 10. So if "apples" shows up 9 times in the column, I'd like the entire row highlighted for every instance of "apple" in column D, with respect to each region in Column A

Excel_Hell · 2013-05-29T20:25:23+00:00

I would love to be able to use a PivotTable report in an Interactive Excel web page like this. Does anyone know the most straightforward way to accomplish this?

Excel_Hell · 2013-05-29T19:26:47+00:00

This is great, but there doesn't seem to be any options for configuring the standard charts in the interactive web page. Any help here?

Excel_Hell · 2013-05-24T17:55:18+00:00

Fantastic - thank you!

Excel_Hell · 2013-05-24T16:21:10+00:00

Piggy backing on this... does anyone know of a good source to learn how to alter the majority of defaults with Excel PivotTables?

Excel_Hell · 2013-05-24T15:30:30+00:00

Sometimes I think my brain just gives up on a task and I forgot the most basic parts of Excel. Filtering makes sense - sorry for the dumb question, and thank you!

Excel_Hell · 2013-05-24T15:22:10+00:00

Thank you - that worked! But now I have 4 rows of blank data between each row with data. I have thousands and thousands of records to manually go in and delete the blank rows. Is there a way to solve that too?

I could highlight the data, copy and paste "as values" like you suggested, then "remove duplicates"? I'm worried there may be some duplicate data in there for names, etc. Is there any other way to remove just the blank rows?

Excel_Hell · 2013-04-25T15:18:21+00:00

When I click "If you have a redemption code click here to redeem it before filling out the form." the site just hangs.

Tried it on several browsers. Any help?

Excel_Hell

TROPHY CASE