formula & text

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

Hello lovely people, I'm trying to write an IF formula which returns a certain value if a referenced cell contains any text and a different value if it is blank. As it stands the only way I've been able to do this is to use a formula which nests each different possible text value the cells...

I will start this by saying I don't know much about excel, but I do know that formula for this problem is beyond my skill level and beyond what a simple Google search will answer. The challenge is: I have 5 areas (Cans/Contingent/Kegs/Maintenance/Bottle) that submit daily codes (20 different...

I am trying to write a formula that will look at the contents of a cell (D19) and see if it contains the text "R-". If D19 contains "R-", then value of D21 for which I am writing the formula would be "240V 1-phase". If D19 doesn't contain "R-", then the value in D21 would be "460V 1-phase"...

I have a worksheet with numeric data, where some are preceded by non-numeric characters. I would like to average the all the values in the row, but the average function does not seem to consider the entries as numeric, so it didn't work. <tbody> A B C D D 1 <1.2 <2.2 3 <1.5 <2...

Hello - I have 65 rows of data; each cell contains anywhere from 5 to 8 comma delimited values that need to be housed in their own rows. Here is an example of my data: Cell A2: 0x460297gpr,9806458rtgjd,0x5641313746fd,9x44564fs4f5s4f5ds3,5x4f35sd4f3sd4f3s Cell A3...

Hi: I need to convert a date in one column to a text field. If the date is between 01/01/2013 and 03/31/2013 then the text would be 13Q1. If the date is between 04/01/2013 and 06/30/2013 then the text would be 13Q2. And so on. I'm trying not to manually do this. Thank you very much!! <TBODY>...

So I currently have this formula: =IF(AC61="","",IF(AC61<9.5,"",IF(AC61="No Review",IF(AB61="No Review",IF(AA61="No Review","","No Review"),"No Review"),"No Review"))) This looks at the last 4 weeks of data and if it finds a value over 9.5, "No Review" is populated in the cell. If it's below...

Hi, I am new here so apologies if this has been posted in the incorrect location! I have a spreadsheet that is tracking the location of documents at work. What I need is for the 'Document Location' column (R10) to read 'Steve Brown' if there is a date in the columns 'First Submission' (F10)...

I'm trying to come up with a count formula to meet my needs. I want the formula to count each row in a sheet that meets two requirements. A cell in a certain column contains a specific text. A cell in a certain column falls within a specific month, the cell is currently in the mm/dd/yyyy...

Hello. i have my list of order and i want it convert it into a specific set of code. <colgroup><col><col><col><col><col span="2"><col><col><col span="4"></colgroup><tbody> OOGO1.O1.13 Size 30 31 32 33 34 36 38 40 Total 32 2 3 3 0 4 3 1 0 16 34 0 1 2 1 1 2 1 1 9 Total...

I've got an excel file with columns, C_IP SESSION_ID CS_USER_AGENT CS_URI_STEM CS_URI_QUERY WEB_LINK I'm not able to aggregate the above attributes due to the limitations of the string size allowed in Oracle (11g). I tried to use a user-defined aggregating function for this. I want to...

I'm helping someone on a series of spreadsheets she does every month/quarter for dozens of different groups. Each group is slightly different, so it's not as easy to standardize. I'm trying to help her consolidate her efforts where possible, so I'm hoping to avoid manual manipulation x's 75...

I am trying to do the following: I16 = 15 H41 = 640 E16 = .035714 (note this is a formula result, not a value) F16 = .125 (note this is a forumula result,not a value) Formula shows: (I16/H41)*(E16*F16) = .00034877 (EIGHT DECIMAL PLACES) Want it to show : (15/640)* (.035714*.125) = .00034877...

MrEXCEL Members, In need of your help, I have a workbook that we created for to produce codes for a unix server for bulk loading. the issue is, when we enter the information in to the cells that need information entered, and copy the populated cell data, paste it into notepad, it puts " on the...

I have a series of cells that contain text which looks like this: blahblah blah blah blah BLAHBLAH line 23blahblahblah The "23" is the relevant part. It's always a number, it could be from one to three digits long, and it always comes just to the right of "line" followed by a space. I...

Hi all, I'm trying to break up text in excel based on certain criteria and would prefer using a formula. Criteria one: Must be 35 characters or less in length Criteria two: Must include full words So for example: Cell A1: Sally bought a new purse End Result: Cell A1: Sally bought a...

What I am trying to do is assign a range of values a name. I have data from a football game such as down & distance, yard line, gain/loss etc.. I want to use a formula to configure "Field Zones" for certain yard lines. For example, when I create a Field Zone collumn to the data I have and...

Hi guys, my first post ever! I am novice excel user and have this very complicated formula (for me anyways): I have 2 files "Summary" and "Detail" "Detail" has heading row of Mon-Fri with data below each date In the "Summary", i also have a heading row of Mon-Fri. I would like to pull...

Hi All, I have a column that has thousands of rows with text similar to "duplicate value found: Service Role duplicates value on record with id: a0YT0000003lFG9". Now I want to edit the column so that I just need the id in each field remaining, which is "a0YT0000003lFG9". If it was for few...