Tips for Communicating with Companies About Multiple Job Openings

Hey guys, I'm scrapping open jobs from LinkedIn and reaching out to decision makers. Some companies have multiple job openings and I'm looking for a way that if a company has multiple jobs open, I can say something like, I see you have X open positions in X location. Any suggestions/ideas are welcome

4 comments

Amit S.
·
·
Create a unique key "Company-Location". Do a lookup in the same table. Count the number of records. You can also do this in a separate sub-table and lookup the count back into the original table.
Bo (.
·
·
Hey, thanks for reaching out Reyhan Amit's right. 1. Use this principle to number the rows and lookup 2. From there use a formula column to extract the highest values of the number rows Cheers
Reyhan K.
·
·
Thanks guys, will work on this
Channeled
APP
·
·
Hi Reyhan K.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: