Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. S

    Calculate amt due

    ...Settlement #2: =INDEX(Table1[Settlement '#2],MATCH([@CustID],Table1[CustID],0),1) Collection Amt.: =SUMPRODUCT((Table1[CustID]=[@CustID])*(Table1[Collection Amt.])) Amount Due: =IF(([@[Settlement '#1]]+[@[Settlement '#2]])-[@[Collection Amt.]]=0,"no amount due",([@[Settlement...
  2. S

    Excel Unique-Filter issue

    This is a better solution that can accommodate TEXT or NUMERIC lookups, although one ought never mix TEXT & NUMBERS in the same table column. I dummied up some data, but I used TEXT rather than DIGITS in the ColourID COLUMN (Colours A) to demonstrate the multiple lookup criteria method via...
  3. S

    Excel Unique-Filter issue

    ...for help. BTW, using tables without Headers ought to be a capital offense, punishable by 40 lashes with a wet noodle. D2: =SUMPRODUCT(($G:$G=B2)*($H:$H=C2)*($F:$F)) You can't use INDEX & MATCH if you have multiple criteria. But the question I'd pose is, why are you putting that...
  4. S

    Find unique rent amount and date this was first charged

    Hi, Rent goes up and down. I set up a small Structured Table with Date and Rent and then added a Chg column to display the British date - pounds sterling whenever the Rent <> Previous Rent value. Then used the UNIQUE() function to capture the unique values in the Chg column. Caveat: the...
  5. S

    Excel Pivot Table - Combine Values into a single row

    As mintjulep has stated, it ALL depends on "the underlying data" Data is $money. Show me the $money!
  6. S

    Extract lines from table into new table

    I hope your "spreadsheet" is a table and better yet, a Structured Table via Insert > Tables > Table. Please display the structure of your table.
  7. S

    What has happened here to Tek-Tips??

    A breadcrumb is one of a series of hints or tips toward an end.
  8. S

    What has happened here to Tek-Tips??

    "Thanks combo, I'll check out some of your "mentions". MAYBE this MIGHT grow on me?! I'm old school....darnit!" Laurie, "old school" darning what? Socks? Thought you were a knit picker with that workbook full of patterns???
  9. S

    Office 2000 XL

    FYI: Do you know that anyone can access a free online stripped down version of Excel (or any other office app) from your browser? I've been using such access for the past 8 or 10 years or so in my iPad, where I do most of my work, from the comfort of my EZ chair. The things that I cannot do...
  10. S

    What has happened here to Tek-Tips??

    Which MS Access forum? There are quite a few. Look under... Home>Forums>Software >Programmers>DBMS Packages
  11. S

    Count areas within a range

    DrSimon, I really like words. They are rather essential, especially The Word. Even as a boy of 3, I am told, I was associating words in, for instance, "The Night Before Christmas" like "...not even a mouse" became "...not even a pussycat or a mouse" So germane just came to me as relevant in...
  12. S

    What has happened here to Tek-Tips??

    Laurie, we are all getting accustomed to this new format. Welcome to the blind leading the blind.
  13. S

    Use of Trig functions in VB 2010

    Hi, The domain of y = arcsin(x) is and its range is I had to look this up since it's been a mighty long time since I used these trig functions in my slipstick. So naturally, values of x greater than 1 or less than -1 will return an error.
  14. S

    Are you interested in this forum?

    I check this forum from time to time. I'm not a big puzzle guy but will occasionally give one a try. I thought that the puzzle about escaping the island in the middle of the pond grabbed my interest, for instance. So I think it's a healthy forum for Tek-Tips. But I would not be a contributor...
  15. S

    Testing

    Andy, either the right-hand most "landscape" icon to get a file image or just copy n paste an image as you would text.
  16. S

    Find a number between two sets of numbers.

    Hi, Welcome to the new Tek-Tips. Try this SQL where NUM is the number you referred to. SELECT Job_ID FROM yourTableName WHERE Range_1<=NUM AND Range_2>=NUM
  17. S

    Division of currency formula with/without rounding

    Hi, Welcome to the New Tek-Tips. If your value is in A1, the expression below in the Formula Bar gives you one values in B1 and the other value in C1. Row 2 shows the FormulaText in columns B & C. Rows 3-6 show the progression of the formula calculation in column B Hope that helps. EDIT...
  18. S

    FAQs - anyone know where they are for VFP

    Go to your Profile Member Profile (first on the left) lists each of your Forums and Stats. Some Stat Values are Linked!!! WoooHooo
  19. S

    FAQs - anyone know where they are for VFP

    Griff, Whatever Forum you are in, Clock the FAQ in the banner above. I haven't found a list of my FAQs by Forum
  20. S

    FAQs - anyone know where they are for VFP

    Each Forum had associated FAQs Each Member could see a list with links of their FAQs

Part and Inventory Search

Back
Top