formuals

  1. R

    formula for moving text to colums

    HI Guys I am looking for a formula that can do this: if row contains the word "center" move it column named "school" if row contains the word "street "move it column named "street" this is the data I have: row1: Miami k-8 center row2: 2301 NW 87 street row3: Miami, Fl 33166 row 4: kendall k-8...
  2. F

    delete "ENTER" from fields

    hi, if in the filed you have some text/value and then enter char (it makes 2 lines, but the second one is empty). How we can remove it? Trim isn't work here...
  3. H

    please help, IF functions

    I have attached the google docs for my excel spreadsheet and the list of steps i need to complete, at this point I need help with the first 3 sentances in # 5 and all of #7 https://docs.google.com/document/d/168EFIMexqkv9w4nmMgmzxhjCeSYShuRbcm-QHKUaa-c/edit that is the list of steps and here...
  4. E

    Data Entry Validation to prevent special characters

    I have a workbook that has several text fields that must be entered. However, there are three special characters which should cause an error message to appear which are <>; I am trying to enter a formula into the Custom Data validation but am having issues with creating one to do what I need...
  5. W

    Perplexed by simply "IF" statement

    I am using the following "IF" statement: =IF(AND(TrackingYear=2012,MATCH(TrackingProduct,ProductList,0)>MATCH(Q15,ProductList,0)),"Best Quarter (Pre.)","Runner Up")) I keep entering the above without a double closing parenthesis but Excel keeps adding another one, it seems to me to be a very...
  6. W

    Perplexed by simply "IF" statement

    I am using the following "IF" statement: =IF(AND(TrackingYear=2012,MATCH(TrackingProduct,ProductList,0)>MATCH(Q15,ProductList,0)),"Best Quarter (Pre.)","Runner Up")) I keep entering the above without a double closing parenthesis but Excel keeps adding another one, it seems to me to be a very...
  7. A

    Automate referencing worksheets

    Hi Folks, I'm having trouble with how to program a maco that will automate the reference of sequential worksheet names in serveral forumlas in a 'calcs' worksheet The 'calcs' worksheet contains six columns (A to F)... each with a different formula. Each row in the column references a...
  8. H

    calculating multipul amounts under same heading

    hi i am using excell 2008 for mac, I am imputing data into a chart where I have product sku's then number of items recieved on a specific date. I then have a long list of sku's and amounts. Is there a way excell can add up all the amounts or the same sku numbers?? SKU Code Decription...
  9. M

    Need formula tweaking slightly to work, help pls!

    Hi I had some help earlier off a thread, and just have one more question pls I want to acheive the following: I am using conditional formatting to turn a cell green and want to turn it green under all these conditions: Cell B201 having numbers <!--[if gte mso 9]><xml>...
  10. T

    Add copy a new row

    Hi there, I'm having a little trouble and looking for some assistance. Basically on the top of my worksheet I have a button 'Add Record'. Once clicked I want the spreadsheet to copy the contents of lets say B7:Q7 (including borders and cell colours.) from one worksheet (Sheet 2) to another...
  11. H

    Combining a SUM & TEXT formula

    I have the following formula =TEXT('Non Productive Aux'!B25/86400,CHOOSE(MATCH('Non Productive Aux'!B25,{0,60,3600},1),"hh:mm:ss","hh:mm:ss","[hh]:mm:ss")) which I now want to amend and insert the following into the formula above replacing the bits I have made bold =SUM('Opmis MPP...
  12. B

    IF function - Please Help

    This is a sample of the data set I am working on. <TABLE style="WIDTH: 184pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=245 border=0 x:str><COLGROUP><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3181" width=87><COL style="WIDTH: 54pt; mso-width-source...
  13. J

    Time Conversion

    I have an spreadsheet that is monitoring the productivity of agents, as well as the time that it takes to complete each task. My workforce keeps time as .50 = 30 minutes. So 7 and half hours is actually 7.5. Agents are putting the actual time of it took such as 15 minutes however I would like to...
  14. H

    Vlookup Change (sheet) Range

    Hello, Currently I have a list of names on sheet 1. (named: names) assume each name has a sheet that is named after it. (for the most part true) I need to vlookup data that exists in each sheet (it moves around). I also have more then 500 names that change constantly so manually selecting...
  15. C

    Turning raw data into formulas

    We rececently added an SAP expense forecasting tool, which runs using Excel. While the tool is still being developed to forecast, I am using SAP & hard-keying in data to create a actuals+forecast view. Trouble is, when I "refresh" the SAP app. all of the data I hard-keyed in changes (this is...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top