Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA)
Hello Excel Problem Gurus,
First of all, let me thank you in advance. I find it exemplary that
you all can devote time to helping others who are having issues with
their work. Hopefully one day I can be at a mentor level, and help
Hope you can help! I have an issue where I don't know how to write the
formula that I need without going over on the nesting. The current
formula that I have is as follows:
Data",IF(V7="Yes",&qu...Can the data in a chart table be right justified?
Ecxel 2003 and previous versions of the product center the data in the data
columns. Can the data in the columns of a chart table be right justified?
In article <DABF738B-6C0D-458B-B082-FA9BD8F126A7@microsoft.com>, =?Utf-
8?B?c2FtIGVhZ2xl?= <sam firstname.lastname@example.org> says...
> Ecxel 2003 and previous versions of the product center the data in the data
> columns. Can the data in the columns of a chart table be right justified?
Have you tried to format the table? If yes, and you haven't been
successful it is probably because XL allows very limited cust...Data migration - Adventure Works
I have a company where the adventure works db has been used and had a
lot of data populated into the system. We have now purchased MSCRM and
have obtained the company reg keys.
What is the easiest way to get the data from the 1 system to the next?
We will be establishing a new AD domain and users for the new
Data Migration Framework?
Microsoft CRM MVP
"funboy...Label a chart of counts with other percentage data
Here's the data:
Group 2005 2006 2007 LTM Data
A 19.4% 22.8% 21.2% 19.9% Profitability
A 6 7 7 7 Count
B 9.5% 31.6% 30.4% 30.7% Profitability
B 2 3 3 3 Count
C 22.4% 23.6% 16.6% 17.6% Profitability
C 15 16 17 18 Count
D 19.2% 20.5% 15.9% 13.7% Profitability
D 8 8 9 10 Count
I have successfully generated a stacked bar chart that shows the counts per
group by year.
Now I would like to include a label for each group to show profitability for
each group in each year in the 4 stacks. How would I do that?
--...Creating a chart based on the data in an embedded worksheet
I have a worksheet with several embedded worksheets. I would like to
create a chart based on the data of one of the embedded worksheets
without putting the chart in the embedded worksheet. I have tried
unsuccessfully to do this. I just wondered if anyone knew how to do
You're embedding worksheets within worksheets? Why? Why not just insert
the worksheets in line with the main worksheet? To open or edit the
embedded worksheet, the parent Excel has to open another instance of
Excel, and the chart on the outside of this other instance will never be
able to acce...Can't re-enter a previously deleted User ID
We changed the spelling of a User ID (applewicks to appelwicks) and then
deleted it (since he couldn't remember his password and the button for
password was greyed out so we couldn't change it.) And now we can't re-enter
the same user ID even though it doesn't appear in the window any longer.
Here is the error we get: ODBC SQL server driver: The log in appelwicks
already exists. Thanks!
I believe you have to delete the old ID through Enterprise Manager as well.
> We changed the spelling of a User ID (applewicks to appelwicks) and then
...Setting Defaults in New Item Wizard
How can I set a default value in the New Item Wizard? I want to always use a
barcode type that is about 10 down from the top and I want Taxable Item to
always be checked. Help...
Good question, I need an answer too.
"A StanTech Associate" wrote:
> How can I set a default value in the New Item Wizard? I want to always use a
> barcode type that is about 10 down from the top and I want Taxable Item to
> always be checked. Help...
You can set the default sales tax under Manager, File, Configuration, Sales
Tax, Default item tax group.
To set a default barcode type yo...Calculating on alphabetic cell content
A selection of 4 different letters in a column representing different values
to be used in a formula shall be run through. The calculated result of each
cell in the column shall be placed in the cell next to the read one that
holds the letter.
Thanks in advance.
i think you're after the COUNTIF function
with your column of letters in A1:A100
and the letter you're interested in in C1
then in D1
this will count the number of times the value in C1 occurs in your range.
If this isn't what you're after, could you type out a few examples of your
...Freeze the side column/top row & scroll others
what is the function to set (lock in or freeze) the first column and / or top
of a spreadsheet, so the words and numbers remain in the same place as you
scroll the other columns and rows.
(so you can add more columns..yet keep the main information in the first
In older versions of Excel, it is under Window.
In 2007 version of Excel, it is under View.
You first select a cell, then activate the command. Excel uses the selected
cell's upper left corner to define the freeze point.
Play with it. You can also Unfreeze panes that were fro...new activity not in the appropriate queue
I installed the Rollup 3 for MS CRM 4 and since then all created activities
are redirected to the users assigned folder in queue and not in progress(my
current activities) folder!
It's not logical because a new activity is not yet assigned to a different
user to be in the assigned folder !!
I can't believe this is on purpose and I DON'T have a workflow on this.
Can someone tell me how to fix this?
...Scroll Wheel effecting a form
Is there any way to keep a mouse scroll wheel from having an effect on a
This is a single form for data entry and if are part way thru the form and
for what ever reasom use the scroll wheel all the fields on the form are
effected (they dissapear - like going to the next new record).
My suggestion to get a mouse without a scrool wheel was not met with
Any help here will be appreciated.
Thanks in advance
The scroll wheel is moving you through the records. Nothing except your
view of the records is disappearing. The records are still there. I
wouldn't think y...Data validation list from another worksheet?
Is it possible that the value list for data validation be populated fro
puneetarora_12's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1840
View this thread: http://www.excelforum.com/showthread.php?threadid=38572
Sure is! Use a named range as described here:
"punee..."external data sources" and "external data ranges"
what is the difference between these?
i have run the vb macro code on http://support.microsoft.com/kb/330383 to
check if i have any external data sources or data ranges but there are none.
the reason i need to know is becuase i'm working with office sharepoint
server 2007 and i cannot access a file thru the web access web part because
"The workbook that you selected cannot be loaded because it contains the
following features that are not supported by Excel Services:
External data ranges (also called query tables)"
...hyperlink open in a new page
After reading all the other posts, and inserting "HTML Code Fragment" here's
my prob. I don't want folks to see the actual HTML text. I got a pic of a
calendar, and, I want it to simply open my yah00 calendar in another window.
I've figured out how to patch a pic to a link, but (of course) I want it to
open in a new window, again, without the HTML text being visible.
What am I missing?
Reference: Create a hyperlink in Publisher that opens in a new window:
Use the ECMAScript code approach, and insert ...ANN: New version of Database Workbench, the multi-DBMS IDE now available!
Upscene Productions is proud to announce the next
version of the popular multi-DBMS development tool:
" Database Workbench 4.0 Pro"
With this version we're reached a milestone: Database Workbench
is now fully Unicode enabled and offers new tools to increase
There have been numerous improvements to existing tools and the user
interface making it even better than before.
For more information, see http://www.upscene.com/
Database Workbench supports:
- Borland InterBase ( 4.x - 9.x )
- Firebird ( 1.x, 2.x )
- MS SQL...Updating a workbook from many workbooks.
I am using excel 2003. I have a report workbook that has 27 other workbooks
that it gets information from. What is the easiest way to update the report
workbook with out me singularily opening each of the 27 other work books.
The are all under the same folder on the same drive. including the report
You have not said what you want to do when all of the books are open.
The following code opens all 27 workbooks for you. If you could post
more information we might be able to get you a more specific result.
Change the file path to suit.
Mar...Source data, in Chart Menu, is grey and not accessible.
I set up a pivot table and designed a chart, saved and closed out of the
workbook. Upon returning to work on this project, when selecting the chart
menu to work with my source data, the source data is grey and not accessible.
What might be causing this and can I correct it?
It's a pivot chart. As soon as it's created, it's linked permanently to the
pivot table, and you cannot change the source data. you cannot add more data
that's not in the pivot table to the chart, nor can you remove data that is
in the pivot table from the chart.
Jon Peltier, Microsoft...Excel 2007
Anyone else had problems with Excel 2007 corrupting workbooks when
using the Analysis Toolpak. All formulae requiring the toolpak are
replaced with #N/A (ie XIRR, EDATE).
Man, this sucks.
Congratulations MS on releasing a "Professional" version of your
software that is so much less easy to use than the old version.
Charts look nice (although with some of the most useful features
removed), but the menus SUCK. Hide the ribbon and use keyboard
shortcuts and you might as well use the mouse because the ribbon has
to be displayed each time you use the keyboard shortcuts.
Excel 2007 su...Missing Data Options
I am trying to use Tools - Options - Chart. I want to use the "not
Plotted" option. When I click on it my chart does not change. This
happens after I've selected the chart and then trying to make these
What am I doing wrong?
I want to create a chart that ignores missing data, and gives me a
trend line based on the data I have.
I've had my nose in my Excel "bible" but can't find the answer.
I greatly appreciate any tips.
jimsmith888's Profile: http...Losing New Mail Merge Template
I'm trying to create a new mail merge template from a word doc. I get to the
window: "Microsoft Dynamics CRM Mail Merge for Microsoft Office Word". I've
tried the "Organization" and "Personal" mail merge template options and go
through the process of creating new, picking the doc (xml), uploading,
picking data fields. After I "save and close", I never see the new template
on the list. What am I missing here?
My goal is to have a template that users can easily access to do mail merges
based on a contact record or a report or view of con...Extracting data and returing to colums.
I am about half way there, but I need some more help.
These are web inquires that parsed out in the same colum and repeat th
same way all down the page.
I want to be able to use the fields as guidelines to pull the dat
adjacent to it and sent to the new colum. In a way it is transposin
all the data, but I need to pull all the first names of these peopl
and have them align in the first colum. Same for Last name, business
So if the information that I have come across like this in th
spreadsheet, I just want the customer infomation to move to th
appropriate colums like the third example...how do I convert Mozilla thunderbird data to outlook 2010?
Converted from an old Outlook to Mozilla Thunderbird years ago. Like new
Outlook and would like to switch back. Can't seem to see a conversion utility
I suspect you export from thunderbird to a format Outlook can import, eg csv
(assuming pop mail)
"Mishka" <Mishka@discussions.microsoft.com> wrote in message
> Converted from an old Outlook to Mozilla Thunderbird years ago. Like new
> Outlook and would like to switch back. Can't seem to see a conversion
>...O/L 2002 SP3 Contact access
Have relocated PST file to new computer, running same version and system.
Contacts selection window shows contacts sorted by FIRST names though have
selected last names in tools/options/preferences/contact options
Have 3 contact sub folders which are inaccessible on contacts selection
popup window..This worked fine before migration.
All/Any help sincerely appreciated.
If you have Contacts in the Contacts folder but they are not accessible when
you click on the To button, check these settings:
Make sure the Contact folder is enab...Graphing daily data
I am trying to graph daily data for a month in Excel 2007 that groups like
days (Saturdays, Sundays, etc) in the same series, while still showing
individual values and dates. Any ideas on how to accomplish this?
Use your worksheet to pull the relevant data together into a series. Do the
data manipulation in your worksheet, then the chart plots the series which
you have generated in the worksheet.
"Fozzie" <Fozzie@discussions.microsoft.com> wrote in message
>I am trying to graph daily data f...Pivot Table Data field
I am importing the data from Ms Access, and creating Pivot table.
Row, Data and Columns have drop down manus where you can select and
In Row and Columns when if i unselect any values in drop down menu and
go back values are still there. However, With Data when i unselect any
values it vanish i am unable to retrive it back. Please any one let me
know if i unselect any values from the Data dropdown menu they still