•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Filling the blank column B using a Google web scraping
Hi, so I want to find the name of the Treasury Manager in Column B. However, there are 1500 names and I have shown only 2
I want to use Google search to directly post the name itself. I have read that the =INDEX(IMPORTXML()) function would help but I have no idea how to use it
Any help would be gladly appreciated
An image for reference:
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#google sheets
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Treasury Manager
#Column B
#Google search
#web scraping
#INDEX
#IMPORTXML
#names
#function
#spreadsheet
#data extraction
#Excel
#referral link
#image reference
#1500 names