- Fill in the “Sig Number” in column B for each company from the sheet Sig Number – use a formula to do so
Where is Signumber sheet I didn't find any in the excel attached
Company Sig Number Boyd 2 AMC Networks Inc. 3 Progress 12 Westell 12 Textron Inc. 13 Body 13 Cecil Bancorp, Inc. 14 Golub 15 La Quinta Holdings Inc. 16 Netreit, Inc. 16 Dxp 16 Liveperson, Inc. 17 Essendant 17 Vista 21 Vishay 23 The 23 Salem Media Group, Inc. 24 Triplepoint Venture Growth Bdc Corp. 24 The 24
Hi Sakshi Kaul
=CONCATENATE(C2,", ",+E2,", ",F2,", ",G2,", ",H2)
see below image for result
Please use VLOOKUP function and bring all company sig number in main sheet from sheet Sig Number.
Please let me know if you need help in vlookup as well.
I didn't get your third question.
ques-3 )What is the average revenue per headcount, based on ‘Revenue USD’ for each company. Ignore companies where head count is not given.
file is attached in excel format
Please use AVERAGE function for this question.