formula & text

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...

Hi All, I have a range where the following text can appear "Zone: Zone1".Now this text can appear in different cells, so one week it will be in cell E29 and the next week it will be in cell E40 (data is sent to me this way). Is there a formula, that can search a range, say E29 to E40, look for...