Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
All Tags » Functions » Formulas (RSS)

Browse Forum Posts by Tags

Showing related tags and posts for the Forums application. See all tags in the site

  • Data lookup

    I have 2 worksheets. WkSht1 has 1 column A Client name Bob Tom WKSHT 2 has two columns Col. B has multiple client IDs per Client in Col. A A B CLIENT CLIENT ID Bob B123 B456 B789 Tom T321 T654 T987 There are variable numbers of IDs per Client I need a lookup to match on the client from WKSHT1 and retrieve...
    Posted to Functions and Formulas (Forum) by Fishin Technishun on Wed, Aug 13 2008

  • Re: Colouring text within a formula

    Hi Nick, Many thanks for your answer, and this is what I had already thought I would have to do. However, if there was a way to do this within a formula, then this would have made it easier, as I have several of these formatting requirements throughout the spreadsheet. Many thanks for your help &...
    Posted to Functions and Formulas (Forum) by nutrastat on Fri, Jul 25 2008

  • Colouring text within a formula

    Hi, I could do with your help again with regards to colouring text within a formula (nothing to do with conditional formatting). In a cell I have... ="INTEGRATED PEST MANAGEMENT "&UPPER(Tab_Name_Accommodation) which is all in black text. However, I want the INTEGRATED PEST MANAGEMENT in...
    Posted to Functions and Formulas (Forum) by nutrastat on Thu, Jul 24 2008

  • Insert Rows and Add Missing Dates

    I have spreadsheets which have dates listed in Column A with other data in subsequent columns. There may be multiples (even hundreds) of one date listed (see example below). 5-May-08 6-May-08 7-May-08 7-May-08 7-May-08 8-May-08 There are also missing dates (e.g. 1-May-08 to 4-May-08). Ultimately, I need...
    Posted to Functions and Formulas (Forum) by theCruv on Fri, Jun 20 2008

  • Forecasting using Trend Function Need to Update Each month with New Actuals

    I have over 25 products where I have 2 years of monthly history and I am using the Trend Array function to forecast the next year. Every month I have a new month of data to add at the end of my actuals where the Trend funtion is located. How can I add my new month of data and not have to create 25 new...
    Posted to Functions and Formulas (Forum) by SCMcManus on Thu, May 1 2008

  • Faster Lookups

    Lately I've been coming across situations where I need to join one or more fields from a large dataset to another large dataset. The obvious answer is a vlookup. However, the speed of the vlookup drops dramatically the larger the datasets, which makes sense, a 100,000 row dataset being matched against...
    Posted to Functions and Formulas (Forum) by zfraile on Thu, May 1 2008

  • convert date result from date serial to conventional mm/dd/yyyy date from conditoinal formula

    =IF((AND(L16="H",H16>0)),(J16-H16+K16),IF((OR(L16="H",H16=0)),(H16+J16+K16),(IF(L16="D",(I16+DATE_TEXT(K16)),IF(L16="C",(H16+J16+K16)))))) When the user selects "d" in L16, the system needs to add a date such as 4/24/2007 in cell I16 and a number of...
    Posted to Functions and Formulas (Forum) by stuthill on Mon, Apr 28 2008

  • Welcome to the Excel Functions forum

    Welcome to the Functions forum. You should post any questions on using functions and formulas in here. e.g. VLOOKUP, SUM, AVERAGE, SUMPRODUCT, INDEX, MATCH, etc, etc. Have fun
    Posted to Functions and Formulas (Forum) by Nick Hodge on Sat, Jan 5 2008
Page 1 of 1 (8 items)
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.