formula & text

Hello, I'm looking for a count formula that counts the total number of sheets per person excluding duplicates. For example, below Nate has FTM01 and SM02 sheets assigned to him. His name is shown as 3 times in the table but the sheet names are the same for two of the items below. The answer...

Col M contains a keyed value for "trip segments". If the trip was made w/o stopping Col M = 1; one stop = 2; two stops = 3; etc M2 = " Stopped along route on "&(SUM(M17:M382)-COUNT(M17:M382))/COUNT(M17:M382)*100&"% of trips" That is not 100% accurate, but it's close enough. More than 1...

Hi All, I have been given a task at work and it is to explain the following forumla: =IF($C11=$C10, "", MAX(OFFSET($E$1,MATCH($C11,$C:$C,0)-1,0,COUNTIF($C:$C,$C12)))) All that I know about this is that this formula is taking the average of several cells that have a certain textual...

Help please, Problem is in D19 I could have "week 1" up to "week 52" and I would like E19 to plus 1 for example if D19 was "week 1" E19 would be "week 2" or if D19 was "week 40" E19 would be "week 41". Any solutions guys??

Hello, I am trying to create an IF statement for column H to determine an available time for each client. In column H, I am only looking at the preferred columns (B,D,F). If there are more than three duplicate times per column, I want column H to return with "Look at Preferred Options" so...

Hi Mr and Mrs Excel'er, First time poster here and would love your help I've a string coming from a database e.g. "1000000000 – 23092014 (23092014)" The first part is an ID separated by " - " then a date "23092014" with another date in brackets "(23092014)". Ideally I'd like to copy that...

Hi, I have a long list of file names and within them sits a five digit sequence of numbers and letters. The problem is, the location of that sequence within the file name, differs for every file. For example: 1) ThisisafilenameAB123.doc - sequence = AB123 2) ThisCD453isafilename.doc - sequence...

Hello, I have been having some difficulty for a few days now with this issue. I am attempting to find the Max for an age based on multiple criteria some excluding and including certain texts from the cells. I tried building it like the countifs statement where you can search for certain...

As per attached file Can get experience in Years and months like "12 Years 10 months". <colgroup><col span="4"></colgroup><tbody> S No Name Date of Joining Experience 1 Kane 18-Nov-02 12.81 2 Morris 18-Nov-02 12.81 3 Bill 3-Feb-03 12.60 4 James 17-Mar-03 12.48 5 Rohit 15-Oct-03 11.90...

Dear All, There are two column mentioned below <tbody> Animal Name Animal Type </tbody> In the column named "Animal Name" there is data validation of all Animal like <tbody> Goat Cow Horse <tbody> Lion Tiger Fox </tbody> </tbody> There are two other column <tbody> Types...

Hello, I am not completely sure if this is possible, I have a table like below: <tbody> A B C D E F G H 7/1/2015 1500 2400 3600 7/2/2015 1500 1500 3600 7/3/2015 1600 2400 3600 7/4/2015 1600 3600 1800 7/5/2015 2400 3600 1600 ETC.... </tbody> If...

I have a workbook that I use as a template to import into a billing program. The only issue with is that the software we use, has its an odd naming protocol for the tax areas. I was able to export all the data into a workbook. I need a formula that is able to search for the State, then the...

Hi, Using Excell 2011 on a Mac. I'm trying to get a formula to say if cell A1 = Mon, then 3.25. If A1 = Tue, then 5...and so on throughout the week. I've tried several situations with this, the most recent was...

I have 2 cells as below: Sheet1 <colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody> B C 2 DS </tbody> I want: C2=100 if B2 contains either of "B" or "C" or "Q" or "R" C2=200 if B2 contains either of "D" or "S" ELSE...

Hello, I am working with a large amount of data so I created a small example of what I hope to do attached below. My problem is with formatting in Excel and I have been unable to find the right combination of formulas to complete what I am trying to do, hopefully you all can help...

Hello, I can't figure out the following: I have a list of names as part of a table in Column D: Ex: Adam, Bob, Cindy, Dave. When I filter out two names, how can I get the name in Cell A1 that is on a different worksheet to show the name that appears the most. For instance, if my filter in...

Started with the following formula, then made it fit the start of what I needed. =COUNTIF(A:A,"*MISS*") it helped but I need to add more to it. I have tried and tried but keeping getting errors. I have one workbook with multiple sheets here is the start of the formula that is working...

I am trying to figure out a good way to do this... So, let's say I want to count the number of vowels in a word... how would I do this? I don't want to have to do a separate formula for each vowel and I can't seem to get an array formula to work. Does anyone have any ideas? The list will look...

hello! I have a worksheet with several tabs. I want to take the data from one tab and apply it to another . This is a sample of the info from tab 1. <tbody> 0750010204 Dynamic 0750010205 Dynamic 0750010205 </tbody> What I want to do is apply the information to the new tab so that...

Good evening, I have created budget spreadsheet for myself and i'm just trying to tidy it up a bit. what i would like is count the amount in colum O when a certain word is present in column P, then when it's found that word search for the next one in named range 'income'. I have searched for a...