Search results for query: *

CautionMP, Thanks for the suggestion but I think that will only give me the top 10 SINGLE tags. I am looking for the tag pairings which I was able to get by creating a query and joining the table to itself with and expresion that took the tag from table1 and concatenated it (with a space in...

I have a table of data in Access 2003 with columns "Company" and "Tag" as follows: Company Tag ABC media ABC showbiz ABC TV ABC entertainment DEF media DEF entertainment DEF radio GHI software GHI enterprise...

Corgano, I am going to post this question to the MS Access Other topics forum. Would you mind suggesting a way in Access to "chew up and spit out" what I'm looking for? I tried following your Excel Example but I wasn't even close to successful. I have imported the data to access and I assume...

Corgano, That sounds like an interesting idea. I know how to import the data to access, but then what? Any suggestions? Thanks and best regards, -Lloyd

Glenn, Thanks for the suggestion, I tried it but that tells me what I already know (how many tags per company and how many times a single tag has been used). Also, I have over 700 tags and the pivot table can't show that many columns. Thanks and best regards, -Lloyd

Glenn, Yes you've got it. I want to count how many times ANY combination of two tags appear within a company. I have done the pivot table with company and tag and count of tag simply gives me a count of how many times a single tag has been used. What I want is how many times a tag has been...

Geoff, thanks for the response. That would give me the pairings of Companies to Tags. I am looking for the pairings of tags within each company. Each company has several tags associated with it. I am looking for the most frequently paired tags by company (i.e. how many times does media get...

I've been using pivot tables but to no avail. There are over 400 unique tags and 140 companies. I'm not sure how I would accomplish the "pairing" using a pivot table. I was able to determine the most widely used tags (individually) however I need the most frequent pairings. Any ideas on...

I have a list of data "Company" and "Tag" as follows: Company Tag ABC media ABC showbiz ABC TV ABC entertainment DEF media DEF entertainment DEF radio GHI software GHI enterprise GHI programming What...

Have a look at this site and scroll down to "Running Total In" http://www.contextures.com/xlPivot10.html Thanks and best regards, -Lloyd

Why not just use the Data\Subtotals and count the records in column 3 and check the "Page break between groups" check box? Thanks and best regards, -Lloyd

xlhelp, Thanks for the direction to the site. There's some really great stuff there, however, I wasn't able to determine how any of those solutions would hide ONLY the subtotal on the Qty column while leaving all other subtotals in tact. Am I missing something? THanks Thanks and best...

Ok, I found a partial answer to my question. If I right click on the Company field and in Field Settings instead of "Automatic" subtotals I switch to "Custom" and select "Sum" the calculated field "Cost/Sh" no longer shows subtotal. The Qty data field subtotal may be one I'll have to live with...

I am using Excel 2003 SP2 and I have a pivot table in which I have placed some conditional formatting for the subtotals. In short the data looks like this: Company Position Qty Cost/Sh Cost ABC Company PFD C 500 $1.00 500.00 PFD D 250...

Try this "=+R[" & i & "]C[-10]" Thanks and best regards, -Lloyd

Go to the 1.1.1 line and select Format then Bullets & Numbering. Click on Customize and check the item in "Start at" to make sure it is in sync with the rest of your document. Thanks and best regards, -Lloyd

outofmemoryerror, Try this Sub Mail_Item_with_Voting_Buttons() Set myOlApp = CreateObject("Outlook.Application") Set myItem = myOlApp.CreateItem(olMailItem) myItem.VotingOptions = "Yes;No" myItem.Display End Sub All you would need to do is replace the "Yes;No" string with...

Zathras, Thanks for the quick response. I can rearrange them no problem, however, perhaps I wasn't really clear. I am trying to do this with VBA. Can I still use the "Worksheetfunction.vlookup" on the array variable? Thanks and best regards, -Lloyd

I am using Excel 2003. I need to find an item in an array. Basically I have a two dimensional array with 2 "columns" and 10 "rows". "Column" 1 contains ranks as integers and "Column" 2 contains company names. What I want to do is lookup the company name in "column" 2 and return the...

sounds like he forgot the combination to his safe Thanks and best regards, -Lloyd