Hi,
I am looking for formula that match keyword in from 2 files.
File1:
<colgroup><col></colgroup><tbody>
Keywords Exclude
intern
accountant
accounting
admin
advertising
advisor
analyst
architect
assistant to vice president
assistant to vp
Attorney
auditor
Author...
Hello,
I have to build monthly Income statements (IS) for 47 projects and one combined (IS) based on Trial Balance (TB) exported from accounting system into Excel. Under each account of the TB there are 48 rows related projects (47 projects and one not assigned to projects, in total 48...
I have thousands of cells with text containing various descriptions. I'm trying to search the text and tell me if the description says x, y, or z and to return which one it says. The descriptions are all over the board, but contain certain key words that I need to categorize. Example Below...
It was hard to title this one. Thanks in advance for your help.
In cells A30 through A34, I have the following list:
Assistant Manager
Manager
Coordinator or Treasurer
Vice President
President
We have an "approval level" control that determines who needs to sign the requisition depending on...
I have a report where I'm listing locations and President-Co-President.
I have at 41 different entries and several of our sites have multiple people in one position (a president and co - president). I would like the report to skip the local for the second person listed.
In other words, if I...
I am using an excel spreadsheet as a study tool for a professional exam that I am taking. I have several thousand lines of information basically its a textbook outline. I would like to be able to look at the information and make fill in the blank type questions out of them. This is an...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.