Search results

Howdy. Are you using this as a dynamic named range? Or just in the Pivot Wizard? ________ Cheap Glass Pipes

Well, in MS thinking all dates are serial numbers, today 02/13/2008 is actually 39491. 01/01/1900 is day 1. Therefore, 00/01/1900 is day 0. Hence the result. ________ RANGE ROVER

Can you post a sample of the workbook? ________ Nevada medical marijuana dispensaries

Should it be this? =IF(H2="00/01/1900","",H2) ________ VERMONT MEDICAL MARIJUANA

What formula are you using? ________ Colorado marijuana dispensaries

Okay, using the data in your OP, I set up a Data worksheet (which will draw from the linked sheet in Access), with several dynamic range names. I also included an extra column for lookup purposes (Col A). Data =OFFSET(Data!$A$1,0,0,COUNTA(Data!$A:$A),COUNTA(Data!$1:$1)) DataLU...

If it isn't the left most column for criteria, then VLOOKUP won't work. Far more flexible is INDEX/MATCH for finding specific items because it can use any column for reference. But if you want subtotals, then with one criteria, use SUMIF, and if two criteria, use SUMPRODUCT. Each of them can use...

Okay, perhaps in 2010 or 2011 I may try Office 2007. :D ________ 6r transmission

I don't have 2007, but in 2003, there are a couple of ideas: 1. On the draw tool bar, there is a white arrow, and by pushing it, it allows you to select all objects. 2. There is a distinction between the objects created from Control toolbox and from the Forms toolbar. Is that still true for...

Howdy, Jamie, and welcome to the board. How did you make the drop downs? Data Validation? Forms combo box? Control toolbox combo box? If it is Data Validation it shouldn't cause that. Can you post a small sample? ________ Dodge 500 history

Dynamic Named range: Let's say it starts at A1, then MyRng would refer to: =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1)) The first COUNTA counts the number of used rows and the second counts the number of columns. As long as you never delete A!, this will always include...

Howdy, and welcome to the board. I tend to add another XL worksheet, that pulls the data from this original one linked to Access. That way I can set it up anyway I want. The best thing to do is (dynamically) name the range of the worksheet that has the link to Access, which makes it easier to...

Glad it worked. And good show by coming back with the results! ________ HAWAII MARIJUANA DISPENSARIES

Try hitting CTRL + ~ and see if that resolves it. (It is a toggle, so hit it again, if formulas appear rather than results.) If not, sometimes, you will have to replace that cell with a blank one somewhere else. Put the formula in another cell somewhere, and see if it works. If it does, drag...

Okay, use this: =IF(OR(ISBLANK(B3),ISBLANK(F3),ISBLANK(K3),ISBLANK(L3)),"Create New","") ________ GL1100I

Howdy. Never mind., I should have read more closely. Let me look at the formula. ________ New Jersey Marijuana Dispensaries

Howdy. There are at least three ways to handle it. 1. Doing calculations in Pivot Tables with formulas can be a challenge and I normally don't recommend it. To do that, once your Pivot table is created, then on the Pivot toolbar, click on the dropdown on the left and choose Formulas >...

Howdy. In VBA use TypeName to determine data type. ________ MEXICOCITY HOTEL

Cross posted ________ TOYOTA F ENGINE SPECIFICATIONS

There are commercial applications that propose to do that. However, most forums refuse to promote them. ________ Colorado dispensaries