exce formula

I have a large spreadsheet that contains our sales managers initials for all dealer accounts. We have about six sales managers so there are six different sets of initials. Is there a command I can do to change all of the initials to their full name (first, last)? Example change JS to John Smith.

Hi, I have looked around the net, but I can't find a clear answer for the following. also a linked to excel is attached at the bottom I would like a VBA code that can fill up the cells, and continues filling not start from the begging so it is based on the current date for example if the...

I have a question about calculating run-out date for inventory based on BOTH projection and actual YTD sales. Currently, I am able to use index,match+offset function to calculate the run-out date based on projection. by using the following equation: '''...

I Don't Not this formula .................................................................

I'm trying to exclude duration of a date range from a set of range that is in another sheet: Table_1 shows total time in seconds a ticket was assigned to someone Table_2 shows the time in seconds when the ticket was put on hold Table_1 ID Start_Date End_Date...

I want to find maximum and minimum for right most number from same cell having multiple values, below is the how data looks. This all values are in same cell, ex: in cell "A1" I want to extract rightmost number, like 1.00,1.5,1.5,1.0,2.00,1.50,1.0,1.00 and find max and min from it. I am...

I am trying to I am trying to write a macro to loop through a column (Z), & find the cells with a "Yes" in them. When a Yes is found I am trying to generate the following Msg “"Check to verify veteran data is entered in FY ## REFERALS. "It's critical that the veteran data is captured." & “You...

I have a VLOOKUP in cell F5 that fills the cell with the word No, if "No Show", or other sect text is in cell L5. The formula below works as expected, but I am trying to adapt it to another workbook. I am trying to have a similar formula where Yes is in cell range O4:R4, will cause “No” to...

This is similar, but slightly different from the last post. I believed that a new post would be appropriate. Cell range D5:Q30 is the range that the user sees & uses to enter leave. Cell range AI5:AV30 is what the system uses to conditionally format Cell range D5:Q30 when an individual...

I have a worksheet that tracks leave taken. Cells in the range D4:Q29 fill with RGB,251,191,143, when it is <today. The range covers a 2 week pay period, therefor a 26 pay period year. I am trying to write a formula that counts the number of days till the last day in the last pay period, minus...

Site Index=25, Cell Index=113, Alarm Cause=Other causes, Site Type=BTS3900 GSM, Site Name=SK0029, Cell Name=SK0029C, Cell CGI=621-20-2d6-754d i have the above, i need to search and pick any where Cell Name appear and pick the id in front to a new cloum e.g SK0029C

dear sir ma'am <colgroup><col><col><col></colgroup><tbody> ORDER ID NO OF HOURS TO PICK OR3173JG-002A 90 OR3289CG-002A 71 OR7846FG-002A 87 OR5531NF-003A 24 OR8259UG-001A 99 OR9663UG-001A 77 OR4926VG-001A 69 OR4421UG-001A 90 OR3805DF-002A 91 OR8570UG-001A 5...

Hi , I have a column B which contains data <colgroup><col></colgroup><tbody> External Video ID 382926____130510783____vod://fyi.tv/FYHT1863761708020000 vod://_c_fyi.tv/FYHT1863761708020000 382926____130497710____vod://fyi.tv/FYST1863761708020000 vod://_c_fyi.tv/FYST1863761708020000...

I have data in a single cell in the below format 1 NULL 384 JPY 0 2 2 384 555 JPY 0 10 3 555 389 JPY 0 128 4 389 1000 JPY 0 2345 I want to split the data into different columns Like for example C1 C2 C3 C4 C5 C6 C7 C8 C9 0 384 555 389 1000 2 10 128 2345 CAn...

Hello everyone! I hope that you can help me with a particular problem that I am having. Namely, I am working on an Excel sheet where I am trying to make a formula that creates a cumulative sum after a number reachest a maximum. For example, I have one component whose maximum Operating hours is...

Really needs some help on this: I am trying to get a count of something that is in a given date range. <tbody> Date Lead Tech Non Lead Tech Completed 3/11/2016 Y 3/15/2016 N 3/16/2016 N 3/17/2016 Y 3/20/2016 N </tbody> So I want...

Hi, I am working on a problem in which I have an array of start and stop dates (mm/dd/yyyy) and time (24 hour format) and a total cost, for example: Start date Stop Stop Total Cost Row1 3/4/2016 14:00 3/6/2016 08:00...

I am trying to perform a simple calculation =I2-H2 and copy it down. However if a zero appears in I2 , I want the formula to place a zero in J2 where the formula will exist. I have searched for an answer that address this without luck. Any suggestions? Thank you in advance

<tbody> Slabs (Purchases) Discount Applicable on HIGH VALUE PRODUCT 0-99 0% 100-299 1% 300-499 2% 500 and Above 3% </tbody> Conditions: 1. To avail the discount, the purchase bill has to be in the limits mentioned above,a minimum of 100 RO of higher denominations Example below...

I have data in a spreadsheet with different but related Alpha locations in Col A&B. I need to count specific values in Col H for each Alpha value. The ALPHA values vary and are numerous. I am trying to accomplish the following, If Exact alpha values in col A & B (A is a facility code and B...