Think this is probably an easy question but I just can't seem to figure out
how to do it.
I have 7 columns of data see example below. I want to compare the data in
each column and come up with a separate list of all the names and how many
time they occur.
Column 1 Column 2 Column 3 Column 4 Column 5 Column 6 Column 7
Jo Ben Ben Jo Frank Henry Jo
Ben Frank Henry Marge Frank Ben
Henry Frank Frank
Such as a list now saying
I have around 200 items in each column but not each column has them all in
the s...converting data into dozens
Hi, does anyone know an easy way of converting numerical data so that
it calculates the results in dozens?
For instance, if i wanted to add 3doz 11 and 2doz 3, it will result in
simple in principle, but have found no one who can come up with a
formula for this.
Hi, how is the data arranged, i.e is 3doz in cell a1, and 11 in cell b1 etc?
>Hi, does anyone know an easy way of converting numerical data so that
>it calculates the results in dozens?
>For instance, if i wanted to add 3doz 11 and 2doz 3, it will result in
>simple in principle, b...Send data from a cell to a table
I have created a template excel sheet that I want to use to keep track of
patients for a friend in the medical field. The friend will open the sheet
and save it as the patient's last name. My problem is that he wants a
billing sheet each day. I think that the solution is to have a cell in the
template sheet that submits data to the next available cell in a table in a
"master" excel sheet ... a sheet that keeps a running total of all entries.
If such a cell were to exist in the template file, it should be copied to all
new patient files. I'm not sure if this makes ...Pull data from existing entries for a drop down box
I have a database that I put information in everyday with prospective bid
invitations. There are times I get the same invitation from several different
general contractors. I would like to be able to use a drop down box or as I'm
typing the information will query the existing data and auto populate, kind
of like Excel does.
If you are saying you have duplicated information in your table, that is not
a good design. You need to move this information into a separate table e.g. a
general contractors table. Your tables would be:
We added an eXtender window to the Manufacturing Bill of Material window -
we need to include several key fields (PPN, CPN, BoM Type) -
When we create a view based on this window, the key fields all get
concatenated into one.
Is there a way around this? I need each of the individual key fields.
Splitting them based on a fixed length per field is not an option. We are
Thank you for any help you can provide.
You need to use EXT00100 table to split out key fields.
On Sep 28, 12:39=A0pm, Maria <Ma...@discussions.microsoft.com> wrote:...Data Validation on Cells
How can I restraint the user from entering odd numbers in the cell?( but I need the outcome to be in multiples of 5).
select the cell that you want to put the validation on and choose
data / validation
choose custom and type in the formula box
where A1 is the current cell
copy & paste special - validation as necessary
"ringo tan" <ringo email@example.com> wrote in message
> How can I restraint the user from entering odd numbers in...Data type issue in excel sheets
I'm looking forward to valuable suggestions from experts,we are trying
to port data from excel sheets to SQL Server2000,all the data gets
transferred except one column.During import, the data type for that
column shows as double BUT ACTUALLY THAT COLUMN HAS TEXT DATA.we tried
changing that type to text/general it shows in excel as changed but
while import shows type as DOUBLE.we are not able to make out where
its type is set as double and even if that is the case how it accepts
text data in that particular column??
Can anyone please enlighten us on this problem??we hav ego tstuck wit...Spurious Duplication
Using Outlook 2000...
On creating a new appointment, Outlook created about 20 instances of the
appointment, all on the same date, all at the same times. I deleted each
extra appointment, one at a time, until the intended single instance was
displayed, and thought no more about it. It has now happened several times,
and I can find no peculiar circumstances relating to them. I don't even know
how to create the problem.
Any ideas please ???
...How to Foolproof data entry? DataForm
I am trying to make a worksheet protected from users manuall
I would like them to ONLY be able to Add/Edit data through the Data -
Does anyone know if there is a way to only allow inputting/editing o
cells to only be done by Data -> Form?
(if you protect the worksheetm DataForm won't allow Add/Edit either)
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
Not totally sure about forms, but i presume there is some sort...No data showing in query
I am new to Access and am using Access 2007.
I wanted to create a query to bring data together from several tables to
complete forms and form letters.
I used the Query Wizard to create a query which selected data from the
different tables. It worked fine and I was able to complete a form in Word.
I have now used the the same process using the same tables for a couple of
other queries but now there is no data in those datasheets. Anything I'm
missing here? Thanks.
There are three ways of creating a query. The query wizard, which you've
used, is at one end of the &q...How do I format the Auto Date font that is inserted
Sorry to bother with such a minor thing....
When creating a page that is captured from the web, a date and
time is already inserted at the top of the page... which is
The only problem is that it is so tiny and light colored font
that it is hard to see.
Is there a way to change that font?
PS- I just started using Onenote and it is a great program!
I just love it. Perfect for what I need.
I see the answer in a previous post.
Sorry, I thought I had read all the previous post headers.
"Nancy" <firstname.lastname@example.org...Data List
I have a workbook with multiple sheets. I want to have all my Data Lists for
drop down menus on their own seperate worksheet within that workbook. It
says in Excel instructions that it can be done but when I try to do it I get
a pop up that says I can't have my data in a seperate worksheet. Is there a
way around this? Thanks for any light.........
If you give that range a nice name, you can have it on another sheet.
Debra Dalgleish shows how:
> I have a workbook with multiple sheets. I want to have all my Dat...data entry help
I have a UserForm I am using to enter data for a monthly mileage
program. The form has 1 combobox and several textboxes. Data will
go into cells Sheet1!A8:F30. The combobox will be used to select one
of several routine routes I take. The textboxes are for Date,
OdometerStart, OdometerEnd, TotalMiles, Home/WorkMiles, and
BusinessMiles. The Combobox has a rowsource to Sheet2!a1:a8.
There are 3 things I need help with. First, I would like excel to
start putting in data at Sheet1!a8 the first time I open the template,
and then find the first empty row for each following entry. Second,
when...Summarization of Excel data
I need to summarize (subtotal) rows in an Excel spreadsheet. The subtotal command gets me part of the way there, but I need more functionality. I have 1000 records that I want to subtotal amount by customer number. But, I also need the customer name, address, record count, etc. in the subtotal record. I would like to be able to use an sql statement to do it, but don't know if possible. Any ideas?
I don't know, but it sound like a job for a pivot table to
me. As long as your dataset isn't dreadfully huge, I
think it would do the trick.
Try DATA, SUBTOTAL
This will m...Autofilter on date fields should refelct the underlying data (rat.
I have a sheet with a list of dates formatted "ddd dd mm yy". It would be
useful to be able to jump to a particular date using autofilter, but the drop
down box offers the various dates in an order determined by the formatted
version of the date (all Fridays, then Mondays, Saturdays, Sundays,
Thursdays, Tuesdays and Wednesdays). It would be more helpful if the drop
down box looked at the underlying date data and ordered the alternatives
Format them as "dd mm yy ddd".
>I have a sheet with a lis...Labelling data points in a scatter chart
I'm having trouble editing data points to include text labels on what these
data points represent. I'm using a scatter chart and have plotted the points
to be just where I need them. I now need to attach text to each data point
describing what it represents. Is this possible?
There is no built in way to link data labels to cells. But with the aid of
this free addin you can do it.
Andy Pope, Microsoft MVP - Excel
"iaintw" <email@example.com...Importing data into public folder
I have 3 calendars that i am trying to import into the public folder and i
am not sure how to go about doing this. The 3 calendars are in .pst format
but i do not know what program i should use to import the calendars. I have
used exmerge before for importing pst files how ever i do not know how to
use it to import calendar's into a public folder.
On Mon, 27 Nov 2006 11:35:48 -0500, "Jef A" <firstname.lastname@example.org>
>I have 3 calendars that i am trying to import into the public folder and i
>am not sure how to go about doing this. The 3 calendars are...data type mismatch
I am working on a report that should return only current members.
In the CommitmentDate table, each time a member renews, their renewal date
is entered along with the enrollment period which is typically one year.
I created a query to give me the date to which the membership is valid. So
if a member renews 7/29/2009 for one year, the query returns 7/29/2010 as the
"valid to" date. Another column sorts them into "current" or "expired"
members based on the current date. The query is working and it follows:
...Spurious data being inserted in field
Periodically, some of the records in one table have one field updated to the
It is the most bizarre thing I have ever seen. We have checked all our
servers and stored procedures for any occurrence of this value in scripts or
ASP pages but none exist. We're fearing SQL injection or similar but in our
application this field is only updated from one place and it's tight against
If it was a hack we would think the value might be something else, so we're
presuming some sort of corruption or sim...Problem writing Outlook data to Access table
I have been able to affect outlook and pull information from outlook and
display it via MSGBOX and now a form. But it does not write the data to the
table I created for it. I tried many ways to get and write the data, but
nothing shows up in the table. What is wrong??
Private Sub cmdSaveNewRecords_Click()
Dim objApp As Outlook.Application
Dim objNS As Outlook.NameSpace
Dim objFolder As Outlook.MAPIFolder
Dim objDummy As Outlook.MailItem
Dim objRecip As Outlook.Recipient
Dim objAppt As Outlook.AppointmentItem
Dim strMsg As String
Dim strName As...Table Data Missing
I'm using Excel 2007.
I have created a table with customer numbers, names, status, and several
other columns. I named this table including the header row
'Mortgage_Pay_Table'. Excel automatically named the table EXCLUDING the
header as 'Table4'. This table has 37 rows excluding the header numbers from
100 to 136 in the first column. This table is formatted correctly for visual
appearance, ease of data entry, and printing.
I am trying to make a near 'duplicate' of this table on another sheet that
would be hidden to generate raw data for analysis w...Transfering data between sheets
Hi! Here is a tough one to crack!
I want to transfer data from a particular cell in one sheet to a
particular cell in the new sheet which I start a week later. That
means- I need a function that will get data from the last sheet i.e.
(n-1) to nr. (n) sheet which I establish subsequently every week.Each
new sheet is numbered as (n+1)
Hope I have explained it such that you can understand my query!
This macro adds a sheet at the end of a workbook, then copies the valu
of cell A2 in the previously last sheet into cell A1 of the newly adde
n = Sheets.Count
Sheets.Add aft...TO field no longer parses names correctly
I have some email distribution lists that I keep in plain text in this
Smith, John; Cooper, Katy;
I've always been able to copy and paste the plain text into the TO
field, clicked on Check Names, and they would all be underlined,
meaning that Exchange had looked them all up and verified them in the
corporate address book.
But now when I do that, it gives me an error message "Outlook found
more than one Smith". If I click "Cancel", the TO field will convert
all the commas into semicolons and really be messed up.
Anyone know why this happened? Thanks.
On Feb ...Get data from a Delphi grid data
I have to write an MFC application that capture data from the Exe
application that was created by Delphi , this control name is TStringGrid, it
looks like the CListCtrl in MFC.
I could capture the windows handle, the control handle. but I did not know
how to get data from this cotrol because this control dont use the massage
like the CListCtrl in MFC ....
Anyone knows how to solve this problems??
...Data from Access query to Excel
To pull data from an Access 2003 database, I have created
the queries in Access, then import into Excel. The
problem is that all the numbers that are pulled into
Excel are text and need to convert them into numbers to
run formulas on. I have converted a few sheets by hand,
but, some have will over 50,000 rows. Is there a
function to select all number colums (the colums are the
same through out the sheets) and convert?
There are instructions here for converting text to numbers:
You can select all the columns, and only the num...