Pages

Search

Excel Help Forum - Excel General: INDEX+MATCH with multiple criteria across both rows and columns

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
INDEX+MATCH with multiple criteria across both rows and columns
Hi everyone, I have a spreadsheet where I'd to match four criteria (on a single row), against one column criteria (the year). This wouldn't be a problem if the data was arranged in the usual fashion where every criteria including the year is it's own column. As I'm dealing with a large...

Excel Help Forum - Excel General: using defined array names from a cell containing text of just the array name

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
using defined array names from a cell containing text of just the array name
hi i was wondering if there was a way to use cells containing just text of the name of an array (previously defined by me) as the array to look in, within a vlookup? ex. array name = cats_1 text within A1= cats_1

Excel IT Pro Discussions Forum: File Slow to open and Changes to cells are slow

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
File Slow to open and Changes to cells are slow

We use an Excel file that takes 9 seconds to make a change to a cell.  Also takes several minutes to open....using Windows XP; Office 2007  latest patches

No Impact from the following

So far, I've got to FILE Types and changed xls and xlsx files to NO DDE and added back "%1" the end of the command line.  When I check the type again....DDE is checked again....so not sure what is happening there

start Excel in Safe Mode     start ; run excel /safe

carl

Excel Help Forum - Excel Charting & Pivots: Software for FAST plotting charts from dynamic excel data?

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Software for FAST plotting charts from dynamic excel data?
Hi! I am looking for a software that can take dynamically updating data in excel worksheet every second and plot graphs from it. Here is my working conditions: 1. Data supplied from the monitoring instruments is updated dynamically for about 300 (unique IDs) x5 (5 criteria for of the 300...

Excel Help Forum - Excel General: Your expert help needed please...

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Your expert help needed please...
Hi I really need your help! I have an excel document containing contact information for businesses including web addresses. I have been working on the sheet and now when I try to work on it I get a pop up dialogue box, windows log in; please enter log in credentials for truffaut.com ...

Excel Help Forum - Excel General: Matching a cell against a pre-defined table and returning an adjacent cell as...

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Matching a cell against a pre-defined table and returning an adjacent cell as a result
Hi, Apologies in advance as i am sure the answer to my problem is on here already but i have tried a search and cannot find it. See spreadsheet attached. In column C, i have a list of countries in random order. In Columns A and B, i have an alphabetical list of countries and country codes...

Excel Help Forum - Excel General: Transfering formulas from one worksheet to another???

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Transfering formulas from one worksheet to another???
I have created a large set of forumlas in a a worksheet. They were created right next to the set of data that I was using for my formulas so that I could refrence it. Now that my set of formulas is quite large, I want to MOVE them to a seperate worksheet so that I can set it up nicely for printing,...
Subscribe to: Posts (Atom)