Pages

Search

Excel Help Forum - Excel General: Multiple sumproduct criteria

Feed2Mail notification - new post on Excel Help Forum - Excel General
Multiple sumproduct criteria
First off, let me apologize if the title is misleading. I could not think of a proper way to label or search what I am trying to accomplish. I have attached a sample document to help illustrate the tab layouts. The goal is that if an ID listed on the Search tab under Column G has "SHOW" listed...

Office IT Pro General Discussions Forum: Comctl error on Access 10

Feed2Mail notification - new post on Office IT Pro General Discussions Forum
Comctl error on Access 10

Access 10 database Comctl.ocx comes up with OLE Server error, which prevents the control working.

I have successfully re-registered the controls, mscomct32.ocx, mscomctl2.ocx and comctl.ocx, but the listview function in the application still doesn't work.

The application is running on windows 7

Excel Help Forum - Excel Charting & Pivots: Multiple graph in a single chart using dropdown list

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Multiple graph in a single chart using dropdown list
Hello All, I have a raw data and from the data i have created n no of tables based on pivoting different combination of fields/Columns.Now my manager asking me to give the common single dynamic graph which holds all the graph and he should select which type of graph he want. I came to know...

Excel Help Forum - Excel Programming / VBA / Macros: VBA to Concatenate Variable Range

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
VBA to Concatenate Variable Range
*Dear All,* I have a problem with a worksheet that my company accounting system exports every month. Attached : sample of the worksheet. In column ( F ) , I need a macro to do the following calculations: 1- Check for the Title – if it begins with "Cost Center" 2- Check for the Title – if...

Excel Help Forum - Excel General: Importing data and update, query?

Feed2Mail notification - new post on Excel Help Forum - Excel General
Importing data and update, query?
Hi, I'm looking to create a "tool" with information coming from two different documents (excel), one with price info etc and one with sales figures etc. These individual documents are going to be updated now and then (and need to stay as seperate documents), and I want the combined "tool" with...

Excel IT Pro Discussions Forum: Find different words in a specific column in a table

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Find different words in a specific column in a table

How to find brand names?

In column A I have product descriptions. These desriptions contains different product specifics, each product are unique, each produkct has it's own row. The brand names I want to find will be found on several products/rows. 

In column B I have a number of words, in this case brand names. All brandnames are unique, there are no duplicates, each brand name has it's own row.

I would like column C to specify if it in the A column with product descriptions finds any of the brand names in the list column B.

/Freddie

Excel Help Forum - Excel Programming / VBA / Macros: Find cells from different workbook ,and workbook name is also from different ...

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Find cells from different workbook ,and workbook name is also from different worksheet.
hi all I have a problem here, i have gotten a task in that i have to find cells(values) from different workbooks. and the names of workbooks are not to be given in macro. the names and Paths have to be get from a different worksheet.....if some one have the idea ......then please help me
Subscribe to: Posts (Atom)