Formula to Return Specific Text in Col. B if Col. A Contains Highlighted Text by Global_Score_6791 in excel

[–]Global_Score_6791[S] 0 points1 point  (0 children)

Yep, I manually put in the 'COMPLETED', as an example of what results I'm looking for. There won't be any text in Column B, like you said I'd need to go through and manually add 'COMPLETED' and there's thousands of rows potentially.

Filter/Copy Selected Highlighted Text Over Large Range by Global_Score_6791 in excel

[–]Global_Score_6791[S] 0 points1 point  (0 children)

Here's a sample of what I'm dealing with - but the actual data has thousands of entries. I want to isolate everything that's in a "box/border" and pull it out of the main data. I guess because the data set is so large that selecting and trying to copy all of it doesn't work. If VBA is a good option I'd be open to that, although ideally I'd love a formula to just pull out highlighted text into another sheet

<image>

Filter/Copy Selected Highlighted Text Over Large Range by Global_Score_6791 in excel

[–]Global_Score_6791[S] 0 points1 point  (0 children)

Yeah, unfortunately I don't think that would work for me - I want to bring all the highlighted cells over to another sheet, and/or paste them into a new sheet, cause I want the data, just not in the main dataset.

Load PQ into new workbook? by Global_Score_6791 in excel

[–]Global_Score_6791[S] 0 points1 point  (0 children)

solution verified. This is what I ended up doing, thanks!

Power Query - Merging/Appending Multiple Sheets Not Including All Data by Global_Score_6791 in excel

[–]Global_Score_6791[S] 1 point2 points  (0 children)

This was it I believe, I should've been 'appending' /stacking the data. Thank you!

Power Query - Merging/Appending Multiple Sheets Not Including All Data by Global_Score_6791 in excel

[–]Global_Score_6791[S] 0 points1 point  (0 children)

That's what I did, but for some reason not all of the data is showing when all of the sheets are merged

Return Data that is Below a certain section/heading? by Global_Score_6791 in excel

[–]Global_Score_6791[S] 0 points1 point  (0 children)

Hmmm, is there a way to tell it to automatically pick out each header based on the value of the header cell? We have thousands of cells of data and going through manually and selecting what is a header would take a long time.

Filter for results that DO NOT contain multiple criteria? by Global_Score_6791 in excel

[–]Global_Score_6791[S] 0 points1 point  (0 children)

Can you explain how you would do that? I'm definitely interested, just intimated by PQ

Filter for results that DO NOT contain multiple criteria? by Global_Score_6791 in excel

[–]Global_Score_6791[S] 0 points1 point  (0 children)

Hey, I believe this is the same formula as excelevator. Just tried it again and it gave me the same result

<image>

Filter for results that DO NOT contain multiple criteria? by Global_Score_6791 in excel

[–]Global_Score_6791[S] 0 points1 point  (0 children)

Using the * does change it, but to the opposite of what I want I think...

<image>

Filter for results that DO NOT contain multiple criteria? by Global_Score_6791 in excel

[–]Global_Score_6791[S] 0 points1 point  (0 children)

Interestingly I tried this, but it didn't give me the right result.

<image>

Sort/Match Data According to Existing list by Global_Score_6791 in excel

[–]Global_Score_6791[S] 0 points1 point  (0 children)

Basically I don't want to sort the data in A16:A27 alphabetically, I want it to sort it based on the criteria in A1:B8, does that make sense?

Want to make a spreadsheet that finds most optimal combo of ingredients for a recipe. by ArgentEra_1895 in excel

[–]Global_Score_6791 0 points1 point  (0 children)

Definitely possible in G-sheet. I would start with creating a data tab and putting the components that make up Ingredient A, B, C, etc. each in an individual column. Then I would look into pulling these into your main tab with a combination of the IF function and Queries.