SQL in Excel data
Is there a possibility/way to run an SQL query in an excel data sheet?
I have quite some data like the sample below, now i would like to have the
sum of spending for each person. Like it is possible in Access.
Advice would be appriciated.
You could use a formula like this ...Creating a group of cells. Need Help Please.
Havn't used excel in a while and I need to create a group of cell
corresponding to an input of a min and a max.
Here are the details. On one sheet I have a box where you enter th
min and a box where you enter the max. In another sheet I want
column starting at A2 to output (MIN,A2+1000,A3+1000,....MAX) ho
would I do this
Thundersixx's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3055
View this thread: http://www.excelforum.com/showthread.php?threadid=50207
Name the...How to get XML data out of an XML file
I am trying to retrieve the Parameters first or second (0, 1 ,2) node from
the following XML file:
<?xml version="1.0" encoding="utf-8" ?>
There will be more data than just a name for each Parameters node. Here is
Dim node As XmlNode = xmlDocument.SelectSingleNode("/P...cell looses name after sorting
Can someone help me with the following problem in Excel 2000:
in a table I have attached serveral cells with unique cell names, the
values in these cells are used in other sheets.
the problem is that when I sort the table, the cell names stay in the
original rowposition; they are not sorted! while their values are. So
Cell names get different values, and other calculations on my other
sheets get messed up!
How can I make the cell names relative instead of absolute?
thankx in advance,
Message posted from http://www.ExcelForum.com/
"jimfx >" <<jimfx.109zcv@exc...SUMIF function not calculating from closed worksheet
We recently upgraded from Microsoft Office 2000 to 2007. Prior to the upgrade
each department would access a spreadsheet that would load data from a
common lookup spreadsheet
The loading process was performed as follows:
The lookup file and each department file would be opened to update the link
for that month and then saved and closed. When the department head would
open the department file, a question would appear asking if they wanted to
update the link, if they answered no the spreadsheet would open and display
the calculated data. If they answered yes, the file would o...Two mailboxes for one user account after mailbox moved to a new server
After moving a user's mailbox from a Exchange 2003 to a new Exchange
2003 server, Outlook has listed two mailboxes with same name in the
"All Mail Folders"area. The Outlook profile only has the user mailbox
and no other mailboxes added to it. The user can send and recieve email
just fine. The mailboxes seem to be clones of each other. New mail show
up in the mailboxes at the sametime.
How can I get Outlook to only show one mailbox?
Any help would be appreciated,
...Pulsar Women's Crystal Accented Dress Two-Tone Stainless Steel Watch #PEGA16
Best deal: http://bestdeallocator.info/index.php?id=B001L1RZ8C
This ladies' two tone, Pulsar fashion watch features a white dial CrystallizedTM with 22 Swarovski crystals. Watch is water resistant up to 30 meters.
This stylish timepiece features a two-tone bracelet and case. The mother-of-pearl dial is accentuated by gold-tone hands and markers. 22 Swarovski® crystals sparkle on this classic watch. 30M water resistant.
Pulsar Women's Crystal Accented Dress Two-Tone Stainless Steel W...Comparing first and last names in two lists
I have two data sources that each contain about 8000 names in seperate
fields for first and last name. I can put them on seperate worksheets
or append one to the other. I need to make them match and find out
where they don't. Messed with consolidate but not sure if that will
work for more than one column at a time. FYI data set one is from a
school transportation database and data set two is from the main
student database from the same school district.
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages dir...Locking cell color while allowing data changes in cell
In excel 2000, I created an attendance worksheet for my
classes.(Alphabetized names down left vertical column. Dates across
top of horizontal row.) I added a different color to all cells in
every other row to make for easier reading of each student's name and
absences. Every other row stays with a white background.
My question: I wondered if it was possible to lock row colors while
allowing data to change on top of them. If a new student is added to
my class in alphabetical order, the alternating color pattern is often
lost. It is a pain to rechange row and cell colors.
Any shortcut ...How refresh imported data automatically?
In Excel, I've imported data into a worksheet. I know I can click Data..
Refresh Data to requery the source, but I want to be able to do it in a more
Is there some sort of macro I can write when opened or something?
Select the cell the data starts in, select Data/Import External Data/Data
Check the box "Refresh on file open" and anything else that needs checking
Other than that, you could record a new Macro that selects your cell,
refreshes data, and assign the macro to a keystroke, or even an icon.
...How do I break URL address over two lines?
I am trying to enter website addresses into footnotes and Word automatically
forces the footnote onto a separate line. I need to conform to certain
aditing requirements and want the url to start right after the citation and
continue on to however many lines are necessary, but not leave a gap because
it starts the url on a separate line in the footnote. Help please.
In the edit hyperlink dialog, put the URI in both the Address and Text-to-
display boxes. That way you can use a space or linebreak to wrap the display
text to the next line without affecting the hyperlink ability. Hyp...Question About Missing Data
So, this is probably really easy, but I just want to ask and see if I may be
missing something here. Some data on vendor numbers changed. Let’s say IBM
used to have a vendor number 12345 and now it’s vendor number is 56789. I
can identify IBM as IBM, but I really want to use the number, not the name.
Should I set up a table that ties the numbers together, so that Access knows
12345 = 56789? Or, should I do some kind of Update Query and change all
incidences of 12345 to be 56789? Or, is there some other, method, like a
‘best practices for missing data’?
...Outlook Data Files #4
I've done some reading but I'm still confused about the use of Office
Outlook Personal Folders File (.pst) versus Outlook 97-2002 Personal Folders
File (.pst). I understand the basic "Office Outlook Personal Folders File
(.pst) to create a new Outlook 2003 .pst file. Click Outlook 97-2002
Personal Folders File (.pst) to create a new Outlook .pst file that is
compatible with earlier versions of Outlook."
When we have upgraded to Outlook 2003 or set up a new PC with Outlook 2003,
when adding PST's you can chosse either of the two file type options and
browse to chos...New Named Range Created Each Time Data Imported into Excel via Macro
I have noticed that each time I import data into an Excel spreadsheet
via a macro, a new named range (for the same range) is created. This
does not pose a problem, but after a while, I'll have a huge number of
named ranges that will never be used. Why does Excel name the range
and how can I stop this? I noticed in the recorded macro, there was a
line .Name = "drd_5". I commented this out to see what would happen,
but it just renamed the range "ExternalData_5". The next one was
You could refresh with differen...More than 7 If Functions Example is IF(A2="Bongaigaon", B2*40, ..
i want to use if Command in which 19 times If Function to be used for Example
of the Function is
=IF(A2="Bongaigaon", B2*40, IF(A2="Dhemaji", B2*100, IF(A2="Dhubri", B2*50,
IF(A2="Dibrugarh", B2*65, IF(A2="Golaghat", B2*50, IF(A2="Guwahati", B2*20,
IF(A2="hojai", B2*50, IF(A2="Jorhat", B2*60, If(A2="Kharupetia", B2*50,
up to 19 times
Hi - You really need to create a table with the 19 names in one column and,
in the column to the right, the vaues associated with each name. That would
...How do I combine two worksheets into one graph
I have two worksheets on an Excel spreadsheet. I would like to take both
worksheets and place in one graph. Any suggestions?
Make a chart with data from one sheet. Then copy the data on the other sheet, select
the chart, and use Paste Special from the Edit menu to add the copied data as New
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
> I have two worksheets on an Excel spreadsheet. I would like to take both
> worksheets and place in one graph. Any suggestions?
...Find what control is using a data item
I built a form, then deleted 2 columns from the source table and now I get a
popup asking for the value of those 2 columns. The problem is, I don't use
those columns so I need to find what on the form is refferencing the deleted
I have looked at the control drop down on the properties window and the tab
order window and can't find a control with either one of the missing column
How do I determine what is trying to refference the deleted columns?
I found the problem, the column was still referenced in the underlying query
that fed the form.
I'm new to this forum and to to Excel (2000) and not sure that I'm
asking this question correctly but here is what I'm trying to do.
The data on my work sheet is pasted from another sorce and includes
information: name, ref #, time, date. I use this information looking
up the status of an order and enter a "status note" in 5th (last)
As the day progresses, the source that the data comes from is copied
and pasted under the current list I already have going and much of the
data on the lower list is a duplicate. How can I merge the to list so
that I hav...ROUND Function with other function
I have this formula:
and the results shows me for example: +11.6 but what I really want t
show is +12.
I've been trying to put the "Round" function at a few places in th
formula but it doesn't work.
The closest I got was with this formula:
where it showed me 12, without the "+" sign before....
Can anyone help me ?
Outapin's Profile: http://www.excelforum.com/member...auto fill in data when changing fields
i new to crm 4 and i would like to; once i selected the account i need it to
grab the main phone and put it in the phone field, and could you tell me
where i need to do this, thanks
you can modify the mappings of the corresponding relationship
> i new to crm 4 and i would like to; once i selected the account i need it to
> grab the main phone and put it in the phone field, and could you tell me
> where i need to do this, thanks
In Excel 2002 is there a way of sorting sheets other than by dragging?
See www.cpearson.com/excel/sortws.htm for sample VBA code to sort
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"rifleman" <email@example.com> wrote in message
> In Excel 2002 is there a way of sorting sheets other than by dragging?
"rifleman" <firstname.lastname@example.org> wrote in mess...Pivot Table data values
I need make a pivot table using the values as the data. I used to be able to
do this, but now it only sums, counts or calculates. Is there a way to
return the data values?
...How can I use a form (Excel) to add a column of data to the right.
How can I use a form (Excel) to add a column of data to the right of a list?
It's a simple matter to add a column to the left of a list by writing a
macro that inserts a column and then pastes the values. However I want to
have the data pasted on the right of a list, if only so that I can easily run
a chart from it.
...Can I insert Google Calender data into Publisher document?
How can I configure my Publisher document to use the data from Google
Calendar? I would like to use the RSS feed from Google Calendar.
Creating an RSS Feed
Mary Sauer MSFT MVP
"thpope" <email@example.com> wrote in message
> How can I configure my Publisher document to use the data from Google
> Calendar? I would like to use the RSS feed from Google C...Preventing outside work to send email to a distribution group
I want this distribution group for internal use only. How
can I stop the outside to send message to this address.