Search results for query: *

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.

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

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

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

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

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

This is your best description of your source data. "I have actually got 3 tables in my power pivot data model 1. Label (Unique across 23 and 24 Years) FYI the "label" column is actually a column of part numbers 2. 23 Sales data Label , quantity and price by invoice 3. 24 Sales data Label...

So... With the suggestion above, OFFSET(), it sure would be helpfull, to YOU, if you would provide a testset as requested before, in order that we (the royal we) could actually see and understand and might then offer cogent and relevant suggestions rather than trying to divine your intent and...

You can "float" a range formula in Excel via the OFFSET() function. Here's one way: 1) Anchor the function and make every subsequent result relative to A1. That's the first of 5 arguments. 2) Vary the Row & Column offsets, arguments 2 & 3 to get to the Upper-Left cell of the intended floating...

I guess we're fighting germane warfare. What happens in Vagueness, stays in Vagueness! Sorry. Skip, [glasses]Just traded in my OLD subtlety... for a NUance![tongue] "The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein You Matter... unless you...

BTW, the answer to your first question... =AREAS((A2:B3, A5, B8:B9)) returns 3. DUH! I never found AREAS() to be very helpful. Skip, [glasses]Just traded in my OLD subtlety... for a NUance![tongue] "The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein...