•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Need to tag ~30k vendors as IT vs non-IT
I have a large xlsx vendor master list (~30k vendors).
Goal:
Add ONE column: "IT_Relevant" with values Yes / No.
Definition:
Yes = vendor provides software, hardware, IT services, consulting, cloud, infrastructure, etc.
No = clearly non‑IT (energy, hotel, law firm, logistics, etc.).
Accuracy does NOT need to be perfect – this is a first‑pass filter for sourcing analysis.
Question:
What is a practical way to do this at scale?
Can it be done easily? Basically, the companies should be researched (web) to decide if it is IT relevant or not. ChatGPT cannot handle that much data.
Thank you in advance.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#conversational data analysis
#data analysis tools
#rows.com
#natural language processing for spreadsheets
#big data management in spreadsheets
#digital transformation in spreadsheet software
#Excel compatibility
#large dataset processing
#cloud-based spreadsheet applications
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#cloud-native spreadsheets
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data cleaning solutions