Welcome to DU! The truly grassroots left-of-center political community where regular people, not algorithms, drive the discussions and set the standards. Join the community: Create a free account Support DU (and get rid of ads!): Become a Star Member Latest Breaking News Editorials & Other Articles General Discussion The DU Lounge All Forums Issue Forums Culture Forums Alliance Forums Region Forums Support Forums Help & Search

Computer Help and Support

BootinUp

(49,219 posts)

7. Excel can do something similar

Reply to MANative (Reply #6)

Wed Feb 7, 2024, 11:52 AM

Feb 2024

First convert the spreadsheet data to table data then you can reference them from another sheet. Go to a site like Mr. Excel or just google related tables in excel.

Edit history

Please sign in to view edit histories.

Recommendations

0 members have recommended this reply (displayed in chronological order):

12 replies

= new reply since forum marked as read

Highlight:

Any Excel gurus in the house? [View all] MANative Feb 2024 OP

Would it help to have them together on the same spreadsheet? underpants Feb 2024 #1

Yeah, I found something in my searches that supports your thought MANative Feb 2024 #3

Merge all the data then clip out what BootinUp Feb 2024 #2

That was my first attempt MANative Feb 2024 #4

I would use ms access then BootinUp Feb 2024 #5

Sadly, my company doesn't provide us access to that software, because I think you're probably right. NT MANative Feb 2024 #6

Excel can do something similar BootinUp Feb 2024 #7

Yeah - I think that's the way I'm going to handle it. Tables seem necessary to making this work. Thanks!! NT MANative Feb 2024 #8

One more thought. BootinUp Feb 2024 #9

That sounds viable, too. I will probably need this data for additional scrapes... MANative Feb 2024 #10

Can you give me a better idea of what the data is, and how it's arranged? lastlib Feb 2024 #11

Thanks for the offer!! MANative Feb 2024 #12