formula & text

  1. B

    Trouble simplifying an IF formula

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

    Creating a formula to find the most common string given a second variable?

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

    IF Formula Using Wildcard to Find Part of Text

    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"...
  4. T

    How to average cells with numbers that also contain non-numeric characters?

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

    HELP! Need to convert comma delimited text into rows

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

    IF THEN Formula?

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

    Average only last two number in a row

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

    Formula Help Please!!

    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)...
  9. O

    Formula that will count the # of rows that contain a specific text and a specific month?

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

    I need VBA Script Help.

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

    Excel aggregating function based on an attribute/field

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

    Help with removing a value (or entering zero) ONLY if a referenced cell indicates "Not attempted"

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

    Show values in formulas instead of reference

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

    Issue with copying formulated data from Excel into Notepad.

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

    formula to extract substring from text string

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

    Splitting text in cells based on criteria.

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

    American Football Formula Help Needed!!!

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

    If Today's date plus 2, then put data here.........

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

    Edit text in all the fields in a column(not manually)

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

    SUMIFS formula help

    I'm working on a balance sheet. It basically works around one main transaction table where I classify each transaction according to its value, the currency in which it was paid, the month in which it happened and the type of transaction. The following is a formula for a table that is derived...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top