Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Browse Forum Posts by Tags

Showing related tags and posts for the Functions and Formulas forum. See all tags in the site
  • Using a sum formula with a condition

    Dear all! I have a database that contains product information and sales of these products. Some of the products are still in the store assortment, some of them are already "old" ones and will be soon deleted from the assortment. There is a column in my database indicating the status. E.g. active...
    Posted to Functions and Formulas (Forum) by laguerriere on Tue, Nov 26 2013
  • Re: Multiple Logic-Test IF THEN Statement

    Curtis, Thanks for the formula... Put it in and it seems to work somewhat...a value is being returned. There is a problem, though...maybe I am doing something wrong.... What it is doing is that no matter what cell number I put in for A or B, the value returned is always Z1. Any thoughts what's going...
    Posted to Functions and Formulas (Forum) by steve.sin on Sat, Mar 16 2013
  • Value Comparison Formula

    Excel 2003. We are capturing grades for site reviews based on the scale listed below. On the report we need to indicate how the current grade compares to the grade from the previous period. Score Grade 1 F 60 D- 64 D 67 D+ 70 C- 74 C 77 C+ 80 B- 84 B 87 B+ 90 A- 94 A 97 A+ If the grade improves or declines...
    Posted to Functions and Formulas (Forum) by taino8632 on Tue, Aug 3 2010
  • MATCHING TEXT OF TWO COLUMNS AND WRITING VALUE FROM THIRD COLUMN

    I am hoping someone can help. I need the formula to do the following: Column A Column B Column Ctext text number (acct ID) I want to match the text in ENTIRE Colimn B to ENTIRE Colimn A (named account name), when there is a match by account name, write the ACCOUNT ID FROM COULMN C tHANKS!
    Posted to Functions and Formulas (Forum) by MPowell on Tue, May 18 2010
  • Re: excel challenge issued by my boss (help)

    To simplyfie bentleybob's suggestion you can have a look at this add-in: http://www.mrexcel.com/chal/pareto.zip All of the formulas in B are =RAND() functions. Click the checkbox to recalc, and a whole series of dynamic range names cause the chart to redisplay sorted values. It also make it possible...
    Posted to Functions and Formulas (Forum) by wendel on Mon, Aug 24 2009
  • VLOOKUP, IF, AND FORMULA

    I'm hoping you can help me with a formula. I have a workbook that has 3 tabs. The first is the main log, the second I want to extract certain information on a line that's tied to 2 criteria (product name and tract number) and the third I want to have extract based on 3 criteria (product name...
    Posted to Functions and Formulas (Forum) by cpcourtney on Thu, May 21 2009
  • Alternative solution to using Array Formulas?

    Hi, I've need to derive counts on a large spreadsheet. In the dummy example below, I need to know how many male poodles? How many desexed females etc? Sex Breed Desexed Male Poodle y Male Poodle n Male Alsatian n Female Cairn Terrior y Female Cairn Terrior n Male Smthfield y Female Alsatian n I've...
    Posted to Functions and Formulas (Forum) by jmason72 on Thu, Jan 8 2009
  • 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
  • How Excel solves all my problems

    Last week I was on holliday and we had to divide 3 bottles of wine among ten friends. We could have written our names on little papers and draw 3 names from the lot, but why do something like that when you have a computer with excel. So I wrote a array function that returns a permutation from a set of...
    Posted to Functions and Formulas (Forum) by kaak on Thu, May 8 2008
Page 1 of 1 (9 items)
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.