1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Extracting rows from a sheet based on the value of one cell per row

Our take

Hi folks, If you're looking to streamline your thematic analysis in Excel, you're in the right place. By leveraging functions like FILTER or advanced sorting, you can easily extract and organize your quotes and codes based on the themes in your C column and further categorize them by sub-themes in D. This process not only enhances clarity but also empowers you to gain deeper insights from your data. Let's explore how these tools can transform your analysis and improve your workflow.

Hi folks,

I’m using Excel to organize a thematic analysis. In A column, I have quotes. In B column, I have codes. In C column, I have themes, and in D, I have sub themes.

I want to pull out each quote/code based on the theme in C, and then further organize each quote by its assigned sub theme. Is there a way for me to do that?

Thanks!

submitted by /u/deplorable_word
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

Tagged with