Recent content by SkipVought

Here's a solution using Structured Tables. First convert your table on Sheet 1 to a structured table via Insert > Tables > Table... Here are the formulas Settlement #1: =INDEX(Table1[Settlement '#1],MATCH([@CustID],Table1[CustID],0),1) Settlement #2: =INDEX(Table1[Settlement...

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

Your question and requirements ought to be clear, concise and complete with respect to each item required. However, you failed to include any information regarding the data on your Colours sheet. In most instances, a picture pretty much worthless but a sample workbook would be most helpful if...

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

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

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

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

"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???

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

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

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

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

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.

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

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