firm

Hello! I have Googled and searched the forum here, but I haven't been able to find the exact solution I'm looking for. The context of this request is that I'm doing a database update. The source of the records includes addresses, some of which have firm names in them, some of which do not. Our...

Hi, I have following problem: In the attached workbook I have a sheet where I need the answer "yes" or "no" in cell J based on the information in cell I. "Yes" if one of the cells in I does not have Frankfurt in it. The question is if a firm contact is known in another office than Frankfurt...

Hello So I have a spreadsheet (Excel 2013) with two columns for Firm Names and Address. Now for several entries, the firm name is present in both the firm name and the address column. How can I compare these two columns and strip off the firm names from the address column? How I have it...

Hi Guys, is it possible to open a xls file with only knowing part of the string I have two file Custx Fore wk 18 NetChange-Report-A Custx Firm wk 18 NetChange-Report-A I want to open the Fore file and work on it and then do the same on the firm. my issue is the Custx string changes so does...

I am having trouble creating a viable formula that will sum the product found on the sheet1 within a certain date range. I would like to enable it as a vlookup. Essentially, look for item one sheet1, and total sum within the month. Similar to below. Sheet1: <colgroup><col><col><col...

Hi, New here and hoping you can help me. I have 4 columns of data and I need to be able to search for values in three columns, and return the 4th value if a match occurs. The data is as follows: <tbody> A B C D FIRM A SINGLE FAMILY No Basement/Enclosure 1 FIRM A SINGLE FAMILY With...

Iam trying to show visual representation of which agencies had what percentageof candidates on an interview slate for each department. From the examplebelow, firm 2 had two candidates on slate for the FN openings, firm 1 had 1 andfirm 3 had one. So, not only do I need a way to pull this data...

I need to make a list of all values where in Column A that meet certain criteria in Column B. Ultimately so that I can do a Vlookup. For example: <tbody> Last Name Collections Firm Column C Harrison Firm A Mitchell Firm B Ward Firm A Johnson Firm C Jenkins Firm C Kruger...

I have a workbook with Raw data about many firms.The two identifying factors of the firms are it's name and it's ID number. The manual process would be to create a filter on the firm name or firm id number and then manually go through each firm one by one. Copy and Paste each firm's...