officer

I know how to add bullet points generally to and excel cell. The problem I am having is I already have multiple lines of text in one cell in a giant spreadsheet someone else made. We want to use bullet point to show where the new line of text is in each cell And I have not been able to figure...

hello, looking for a formula that will identify if column A and b matches, example below <tbody> Biz Site Officer code <tbody> A000000802778 </tbody> <tbody> E63 </tbody> A000000802778 E63 <tbody> A000008803992 </tbody> <tbody> A6Z </tbody> <tbody> A000008803992...

Hi all, I'm looking for help in trying to achieve the following. If any of the values in a range is >1, then use the corresponding name from column A. The comments in the code below will hopefully explain what I'm hoping for. I've also created a table for reference. Thanks in advance Sub...

I have a table of data that contains the following columns. I am trying to count the number of loans each officer has made. In order to have a slicer on the dashboard to switch between combinations of New/Refi funds some loans can be duplicates. Can someone help me with a formula to count the...

Hello - I have been stuck on this formula for a few hours. It is the last one I need for this report. Here is mycurrent formula: =SUMPRODUCT((1/COUNTIF(CIF,CIF&""))*(--(LEFT(Officer,3)=D2))) CIF = my rangename for each customer’s ID, which consists of three letters and four numbers...

I have a spreadsheet that has something similar to thefollowing:<o:p></o:p> <tbody> <o:p></o:p> Find this number in range A1:B4<o:p></o:p> Bring back Officer who issued Ticket (ticket assigned to)<o:p></o:p> A<o:p></o:p> B<o:p></o:p> C<o:p></o:p> D<o:p></o:p>...

Hi, I would like to auto-fill a cell based on conditions. For Example: We have "Sheet1" with text 'Brad' in B3, and 'Secretary' in F3. (Brad is the secretary). So when I enter 'Brad' in any row in "Sheet2" (eg. C4), then I want the same row, in column D (eg. D4), to auto fill with 'Secretary'...

Hi everyone, Needs your support for given situation. I have one cell (sheet - 1) in which I enter the name , employee number and functional title of many employees. i want to extract name, employee code and functional title in three different columns another sheet (sheet - 2 ) first line of...

Dears i need your assistance in the following : I have a list of employees, their IDs, grades and job titles. For each job tile there are certain Competencies related to it and for each competency it has certain courses related to it. i created a sheet with ID drop down list and whenever you...