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

How to confront multiple sheets against each other?

Our take

Confronting multiple sheets in Excel can be challenging, especially when organizing data for a conference program. To create an "OTHERS" sheet that captures any conference titles not included in your specific topic sheets, you can use functions like VLOOKUP or FILTER. By comparing each row in your daily sheets against your topic sheets, you can identify and import missing entries. This process allows you to maintain a comprehensive overview without losing track of important sessions, ensuring that no relevant conferences are overlooked.

English is not my first language, if anything doesn't make sense pls ask.

I am currently trying to filter a bigger excel for a conference programm, their file was divided as such sheets:

Day 1, Day 2, Day 3, Day 4 -> this containes, for each day in the title of the sheet each conference title for a given room at a given time.

I created other sheets, which i named as the main topic.

for example: Hybrid if the sheets containes mentions of hybrid as a word in the session or title of the conference.

I am now stuck, since I only searched my main interest and created new sheets only for the word I choose. I now have a incomplete subdivision, since I didn't copy each and every conference.

I would like to create a new sheets named OTHERS in which I import any conference I don't have in the specific sheets I created.

So for example if in Day 1, row7 column 15 never appear in each new sheets I created (hybrid, liquid, ...) I want that row imported in the sheets OTHERS.

Is there a way to do this, even only by finding the single row# column# and then I can manually create the table for the new sheets OTHERS. Or I just need to filter manually or use an AI (which i don't like to do since I want to use excel if possible)

submitted by /u/Candid-Note6320
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

Tagged with

#Excel alternatives for data analysis#google sheets#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#Excel alternatives#row zero#rows.com#real-time data collaboration#real-time collaboration#natural language processing#Excel#conference#sheets#Day 1#Day 2#Day 3#Day 4#filters#import