Another multiple criteria/column question
Ok, first post and pretty much a new user to Excel. I have two sheets
that I am working with, trying to recall data from one to the other
that meets criteria. In a nutshell:
Sheet 1 contains a column of unique values (col A), cols C,D, and E are
where I want to insert the formula to find data on Sheet 2.
Sheet 2 contains 4 columns, A contains multiple occurrences of each
value (from Sheet1, column A), each with its own timestamp in column
On Sheet1, in column C, I want to find a value on Sheet2 in column A
and return the timestamp in column D. I know I can use VLOOKUP for
=VLO...How to shift address listings from row list to columns?
I have a mailing list with name, address, city, state & zip with each item in individual rows like a list of labels and a few empty rows of space between each listing. How do I create/transfer this list into columns accross so I can sort by city or zip? Thank you!
If your data is nicely grouped,
with each group in 5 lines, viz:
then an earlier suggestion given
which worked might be worth a try:
Please reply in newsgroup
<at>yahoo<dot>com for email
--...Excluding hidden columns and rows when copying to another workbook
When I print part of a worksheet that has hidden columns and rows - the hidden columns and rows do not print. That's what I want. Now--I'd like to take that same data and copy it to another workbook excluding the formulas and hidden columns and rows so that the new file contains only the data as was printed. How can I do that?
Select your range including hidden rows and columns then Edit>Go
To>Special>Visible cells only>OK
Now do your copy/paste.
Gord Dibben Excel MVP
On Fri, 6 Feb 2004 10:16:07 -0800, "PJ" <email@example.com>
wr...Outlook Web Access attachment problem
We have a program that will generate a .snp file and then email it to
whatever recipient it needs to go to. If they receive the email in Outlook
it will allow them to open the file properly with the Snapshot viewer.
However, if they go to the same email in OWA and try to save the attachment,
it attempts to save it as an .mdb file. Why would OWA ignore the original
extension and try to give it a different one?
"Joe Giddings" <firstname.lastname@example.org> wrote in
> We have a program that will genera...Sorting with Column has Formula
I never imagined that the formula in the column would affect the sorting
order in any way, but it does in my case.
Below is the formula in that I have in Col I, and I'd like to sort it in
Ascending order, but the result is that it sorts with all the empty rows on
top and the one with the result from the formula at the bottom. I assume it
consider the "I" in the "IF" function in the formula, but I'm not sure.
Can anyone tell me how to fix this please?
#1",IF(...mail sending problem
I am very new in the exchange server just now I have deployed
Microsoft Exchange Server 2003 at my organization now i have some
problem in that .
I am able to send mail outside the domain except yahoo .whenever I am
sending mail from my exchange mail id to any yahoo mail id it is
showing me mail has been sent but on yahoo id it is not delivering
even I am not getting the DFR, second I wants to know that can we
take the backup of single mail box (boxs) and please tell me step by
step how can we take backup (at least the location )
Thanks in Advance
The most probable reason is t...Windows Welcome Screen Login Looping Problem
Up until now no startup problems whatsoever with my system. Today, I press
the start button and it boots fine to the Windows' Welcome Screen. When I
click on my account icon (no password ever entered) it tries to login (I see
my desktop for about 4-5 seconds) but it comes back to the same Windows'
Welcome Screen after about 5-10 seconds. My significant other also has an
account icon and when she tries to login from the welcome screen she can't
get pass the screen either and gets the same 5-10 seconds looping problem
that happens to me. System specs: Dell Deminsio...keeping page, insert etc dropdowns open & having page below it
how can i keep the drop downs open & have the page below it. It was that way
& I must have hit the wrong button or something.microsoft word 2007
"billy" <email@example.com> wrote in message
> how can i keep the drop downs open & have the page below it. It was that
> & I must have hit the wrong button or something.microsoft word 2007
Ask in a discussion group for Word. Here's how to find it.
In the...Incoming mail server problem
I use supanet for the internet and recently had to clear off a load of
viruses and worms from my computer. Computer is clean now. I've run up to
date spybot. adaware and cleaned all viruses with Mcaffee internet security
as well as running stinger. Sasser, and W32 pate.b were included. Have also
completed all windows updates.
Everything is working fine now except my email. When I restart the computer
my incoming mail server keeps changing from pop.supanet.com to a strange
number. 9eg 17.02.01.10 or something similar) It also changes the user name
from 3612 to firstname.lastname@example.org (It adds su...Varying column widths
I have 2 excel sheets - one is 20 columns wide the 2nd is 7 columns wide.
The 20 column sheet has a general information section at the top that I would
like to add to the 7 coulmn spreadsheet. However, when I copy and paste it
"spreads out" or goes way beyond the width due to the number of columns. I
have tried paste special object and entering the excel sheet that way and it
doesn't fit properly and too many cells are shown. Any other way to do this?
If you only want it up there for appearance purposes, you can try:
Copy the selection.
Click the cell where you want t...retain only rows with condition that cells in column H containing "AU"
I have a large database containing columns with one column specifies
the product name. In one instances, I need to retain only rows with
condition that cells in column H containing "AU" of the entire string
in the cell. Delete those rows without it. The problem is , that the
AU of the string can appear in any position, not a fixed position.
Is there any simple way of doing it?
You can use AutoFilter. Choose the command Data, Filter, AutoFilter. Then
open the autofilter drop down in the column H and choose Custom and from the
first drop down, t...Problems performing a restore to a SAN drive
We recently move our message stores to SAN. I've tried to perform a restore
to a recovery storage group on the SAN and am not able to do it. We use
Ultrabac as our backup application, but I've tried NTBackup also and am
getting the following errors in the App logs:
Information Store (3576) Callback function call
ErrESECBRestoreGetDestination ended with error 0xC7FE1F42 Database not found.
Failed to find a database to restore to from the Microsoft Active Directory.
Storage Group specified on the backup media is
Database speci...Equivalent Column Break
In MSWord you can insert a column break when doing newspaper columns. If I
have two text frames connected, and I am almost at the bottom of one but want
Publisher to start at the top of the next one, how do I insert a 'break'? or
do I have to press return until it move the text.
(1) You could shorten that column so that your text breaks where you want it
(2) Or you could check the Help file and search for "insert break".
Insert a column break
You can insert a column break anywhere in a text box. If the text box
contains more than one column, the ...Hiding Column and Row Bars.
I know theres a way to costumize the way you view an excel page by hiding
toolbars, but is there a way to hide the rows and column bars just so all you
can see is the actual page.
E.G. is there a way to Hide the top bar that defines the colums "A", "B",
"C","D" and Rows 1,2,3,4,5.
Go to Tools>Options>View, there are a number of options you can play with
(remove nothere from the email address if mailing direct)
"tamato43" <email@example.com> wrote in message
I am trying to compare 2 columns of numbers so that I can identify and
delete numbers no longer required. Can anyone help me find a formula for
Need more information like a sample of the existing data plus a sample of
what you want left. Maybe an explanation of the criteria for what needs to be
"Dave T" wrote:
> I am trying to compare 2 columns of numbers so that I can identify and
> delete numbers no longer required. Can anyone help me find a formula for
> this please?
> Many than...Disallowing duplication of nmbers in a column
Is Excel capable of disallowing the same numbers in a column? I have a
column in a sheet that invoice numbers are entered into. I would like that
column to alert or something if duplicate numbers are typed in.
Have a look here:
"Barb1" <Barb1@discussions.microsoft.com> wrote in message
> Is Excel capable of disallowing the same numbers in a column? I have a
> column in a sheet that invoice numbers are entered into. I would like
> c...XMLA .NET connection problem
Hi, After install msxml 4.0 and XMLASDK 1.1, i proceed to configure the datasource.xml file, as follow:
<DataSourceDescription>Microsoft Analysis Server 2000 on local machine</DataSourceDescription>
<ProviderName>Microsoft XML for Analysis</ProviderName>
</ProviderType>...Problems with DATE data type
I've got a little problem with the next macro in Excel.
The problem is that I must look for some information in a data bas
using as filter a specific day an hour in the year.
I get the date and the hour using a form and then the macro calle
"Busqueda" receives the value.
I've programmed the macro using MSQuery just to see the necessary cod
and the problem has appeared when I've tried to include the para
called "Dia" in the SQL code.
I've tried using " & Dia & " but it doesn't work and I don't know ho
to include my param...Publisher 2003
I'm attempting to print a calendar and I keep getting the message, "Cannot
load the printer driver." I have no idea what that means other than I'm
unable to print my calendar. Anyone have any ideas? I get the same message
whenever I try to print a card I've created. HELP!
The computer has been chucked out the picture window and the birds are
nesting in it. *sigh*
> I'm attempting to print a calendar and I keep getting the message,
> "Cannot load the printer driver." I have no idea what that means
> other than I'm una...How to merge columns and rows into one cell besides using Merge and Center Icon?
I had posted this question before, but I couldn�t find this thread in
any of the pages up till page 17. So I�m posting again.
I want to merge all rows and columns starting from A1 to J2, with no
lines in between into one cell. My text data value are in D1 and D2
respectively. Using Merge and Center Icon will only retain the
upper-left most data, resulting the data in D2 to be deleted. So how to
merge all rows and columns into one cell and yet prevent the data in D2
to be deleted?
Any help will be greatly appreciated.
~~ Message posted from h...Reinstall problem
I have a CRM 1.2 MSDN installation. I ran add/remove programs to
un-install. Everything seemed to uninstall just fine. I then ran the
installer again to reinstall. I wanted to use the existing database. I
select the: "Connect to an existing database" options, click next then select
my SQL server from the list. I then get a message:
Setup could not find any valid Microsoft CRM databases on the server you
have specified. You must select a different server.
I know the databases are there. I can see them in enterprise manager. The
system was working fine except for ...deleting duplicate value in columns
What is the best method to delete rows containing dulicate (same number)
numbers in a column (Excel 2000)? The workbook has over 30,000 rows which
makes it impractical to sort and then delete the duplicates page by page.
Thanks in advance.
have a look at
Jim Brokenshire wrote:
> What is the best method to delete rows containing dulicate (same
> number) numbers in a column (Excel 2000)? The workbook has over
> 30,000 rows which makes it impractical to sort and then delete the
> duplicates page b...Problem w/ Task Manager
This is a multi-part message in MIME format.
I am running a laptop with WIndows XP SP3. I am not sure what changed or =
happened but my task manager now only shows the processes tab. The tabs =
are mising for me to change views as well as the title bar for my task =
manager windo and the menu bar i also gone.
How can I correct it?
charset="iso-8...Mac problems opening excel files when connected to two windows shares
Operating System: Mac OS X 10.5 (Leopard)
I'm noticing a strange problem when I try to open excel files when I connect to a second windows server share. I'm getting a cannot open excel file error. Not sitting at my work mac computer at the moment so not quite sure that was the exact error. <br><br>This error is occuring on both leopard and snow leopard with Office 2008 for mac. <br><br>The two windows servers are being connected to by smb://server1/common and smb://server2/common. <br><br>If i connect to each one i...An error number : 424 problem
I'm having trouble with an attachment field.
On a report I can see the picture and the filename of the selected attachent
Now in a SQL UPDATE string that i'm making I always get the error 424 Object
Here is the line where it happens :
'mySQL = mySQL + ", scan_g = " & prn_du_pied_g.FileName
scan_g is a Text field
prn_du_pied_g is an attachment
All I want to do is to use the filename of the attchment.
How do I solve this
Thank you for the help
"ericb" <firstname.lastname@example.org> wrote in message