Pages

Search

Excel Help Forum - Excel Programming / VBA / Macros: Weighted Random Number Generator Code Needed

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Weighted Random Number Generator Code Needed
Hello, I am running an excel based Jeopardy game and need a way to randomly choose three winners based on their number of entries gained throughout the game. I need a code which is able to take in columns of information (example below) and randomly pick three student numbers, taking into...

Excel Help Forum - Excel General: How to copy a formula to multiple cells without filling blanks cells too..

Feed2Mail notification - new post on Excel Help Forum - Excel General
How to copy a formula to multiple cells without filling blanks cells too..
Hi, I'm attempting to use a concatenate formula on a list of keywords, however some of the keywords are blank. Is there any way I can get my concatenate keyword to not appear in these fields. I'm attempting to insert a '+' symbol before every keyword but I have 8000+ keywords. E.G. ...

Excel IT Pro Discussions Forum: Excel ODBC / TNSNAMES issue...

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Excel ODBC / TNSNAMES issue...

Running Windows 7 SP1 (32-bit), Office 2010, Oracle Client 11g, and two System DSNs that point to Oracle databases.  I can resolve both ODBC conenctions via a command prompt and tnsping, and I can connect to the ODBC connections via TOAD for Oracle.

Where I'm stuck is that when I attempt to connect within Excel / Power Pivot, it returns a TNS listener error.  The issue is user specific as I can switch users and connect via Excel with no issues.  Looking for a user-specific setting, registry setting or even a cache setting that may store this info.

Fuel

Excel Help Forum - Excel Programming / VBA / Macros: Copy and Paste Filtered Data

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Copy and Paste Filtered Data
I need to copy all the filtered data only from "Sheet1" over to "Members" currently I am just having it select and copy / paste, but this takes a great deal of time. I've looked through some forums to try and figure this out, but can't seem to locate a helpful answer, any ideas? This is what I...

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...
Subscribe to: Comments (Atom)