Re: Massive "FIND" or " Compare cells " then , Delete....
lets say I have in Column A, Dan, John, Bill, Angela, Fred ...many
entries of the same names....
In Column B, I have Nancy, Dan, Steve,
I want to delete all of the "Dans" in both columns ...
Can I do something like: =compare( A1:B20 ) , delete,*.*))
I tried Subsitute, FIND, REPLACE....
I am Confused!!!!
Select A1:B100 (assuming that is your range), do Edit / Replace, replacing Dan
with nothing, then with the range still selected do Edit / Go To / Special /
Blanks, then Edit / Delete / Shift Cells UP.
This assumes you want ...How to find default property for particular object.
is there a way how to identify default property for given object. E.g., I
know default property for range object is value. Where can I find the default
property for other objects?
AFAIK, the only default property for an Excel object is 'value'. If an
object doesn't have a value property then it also doesn't have a default
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
...Finding data in Excel
Lotus had a data find function where you indicated criteria(Same heading as
the database - You could use more than one column) on another part of the
worksheet to search for. You selected / data, find and Lotus highlithed the
row that matches the criteria.
Is there in Excel a simular function?
Cannot remember Lotus, but are you talking about <Ctrl> <F>?
> Lotus had a data find function where you indicated criteria(Same heading as
> the database - You could use more than one column) on another part of the
> worksheet to search for...Clip Gallery can't find files
I'd appreciate any help. I just installed Pub. 98 and it
started indexing my existing clip gallery. Now, it can't
find my old clip gallery files and wants me to update the
location of them since they were moved. Any ideas?
If they are on your system, open the gallery, click import clips, in the files of
type, clip gallery catalogs, browse to the folder.
Mary Sauer MS MVP
"Cyndy b" <firstname.lastname@example.org> wrote in message
> I'd appreciate any help. I just insta...Can't find my financial institution
My financial institution, Hewitt Associates, says that they are supported by
Microsoft Money 2004. They are even listed on the MSN Money website.
However, they are not listed in my Money program and thus can't seem to take
advantage of the online services provided. Any help would be appreciated.
>Subject: Can't find my financial institution
>From: "=?Utf-8?B?aGVyYg==?=" email@example.com
>Date: 12/25/2004 10:03 AM Eastern Standard Time
>My financial insti...Finding text using PowerPoint
What is the easiest way to to find any piece of text in a PowerPoint
Presentation? I would like to search for any text in all types of shapes
(including smart art etc) as well as comments, notes etc. etc. etc. I have
done some research but it seams that there is not a lot of information on
Hope to hear of someone soon!.. please!
Home Tab > Editing > FIND?
john ATSIGN PPTAlchemy.co.uk
Free PPT Hints, Tips and Tutorials
...Finding the position of a certain picture on the screen
I need to make a program in c# that will find a certain picture (not a
big picture, few pixels in a certain formation, which is not
necessarily a rectangle) on the computer screen. I haven't really done
something like that before, so I'm not sure how to do it.
what I had in mind was taking a screenshot (I found a tutorial that
explains how) and then start checking every pixel in the screenshot
until I find one that looks like one of the pixels in my picture, and
then check if there are pixels next to him that are same to the ones
in the picture, and in the same fo...Batch Recover can post incorrect $ if you mark continue
If you have a posting interruption, and your batch goes to Batch Recovery,
you are prompted with the option to continue...which you must do to run an
edit list to see if there are infact errors with your batch. We have
instances where Continue will allow the system to post to the GJ amts that
dont match AP. I opened a support incident, and was told that "This logic
seems sound: no posting errors = correct amounts, posting errors = incorrect
amounts." and the process was functioning as designed. I might agree
,however, the "Batch Recovery Process" is there to help...How to find which day of the week, this year, a birthday fall?
I have a database with employee birthdays. (I enter all the birthdays as
mm/dd/1900 so no one knows how old anyone is.) I have a query I use to
inform the managers what birthdays are upcoming in their department. It so
happens that 2007 had the same calendar as 1900 so I didn't realize I wasn't
pulling the day of the week the birthday falls for the current year.
Is there an expression I need to build or a particular format I need to set?
I was using the number format dddd, mm/dd.
Using DOB as the employee's birthday:
Format(DateSerial(Year(Date),Month(DO...Using OWA how can I find out the size of my mailbox?
I use OWA at University.
How can I easily verify the size of my mailbox ?
...How do I find a copy of Publisher 2002?
I am looking to order a new copy of Publisher 2002. I have a new project
that my client wants to do on Publisher. I have not yet upgraded to XP and
am still on Windows 98, so Publisher 2003 won't work on my (yes I know)
outdated computer. How can I find a new copy of Publisher 2002 which will
work on 98? I'm uncomfortable ordering from some of the unknown sites that
come up in a google search. Any suggestions?
Ebay? Or you could try Sams Club, BJs, or Costco. They may have some older
software. We have a buyout company called Ollies in this are. (Their motto
is "G...Finding the difference in days between two dates?
I was wondering if anyone could let me know how I can find the difference in
days between two date fields, would appreciate the help.
Just try this.
Enter two dates ( 01/08/2003 and 21/08/2003 )
In another cell subtract the two dates, but format that cell as "General".
If all is well, just must find a 20 in that cell.
Or is it too simple and not what you want ?
More Excel ? www.rosenkrantz.nl or firstname.lastname@example.org
"Damon" <email@example.com...Can't find Australian Banks Online
On the list of financial institutions I can only find
American banks. I also have Australian accounts that I
would like to add. Could you please advise if this is
I am using Microsoft Money 2004.
You can add foreign banks to money by selecting the not
held at a financial instution option when setting up the
accounts. The drawback to this is that you cannot link
foreign banks to online services and you probably won't be
able to download statements from their website because
most foreign banks (with the exception of canada) don't
support money. This ...find and replace or ?
I have a spreadsheet I've been updating which originally utilized a helper
column with a date in it. Another column contained a rather long formula
which referenced the cell in the helper column with a relative reference. I
put the value that was in the helper column in a different location and
wanted to update the formula to accommodate an absolute reference to the
newly relocated value. Find and replace worked fine for the first instance
of the formula, but I had to change the cell reference in the "find" box to
update the formula in the next instance. I know I can ...making your own menus on excel?
Is it possible? I'd like to make one where you can open up various
submenus, and eventually select an option that has a macro
attached....(like eg the 'all programs' menu that branches off the
'start' option on windows. SURELY that's possible!
TAL27's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30145
View this thread: http://www.excelforum.com/showthread.php?threadid=498749
Here is an example
'If you put code in th...Finding the Value in the "last" cell?
I have an excel file that has a vba macro that grabs data from
someplace else every few minutes and writes the data to the next empty
line on a sheet "n". SInce the macro just appends the info to the
sheet when event x is triggered I never know what the last line (row
number) of the sheet will be. I need to have cell a1 (for example)
give me the data is whatever is *currently* the most recent (or latest
appended) data from column E. Thus, if the macro five minutes ago was
on row 245 and E245 had the text, "FRED" and now event x triggers the
macro so a new line of data is w...how to make cell content to flash
I need content (text) of the cell to flash under certain conditions.
I know how to do it in Word, can't find it in Excel.
Sorry, Woytek - Excel does not support Animated Text.
> I need content (text) of the cell to flash under certain conditions.
> I know how to do it in Word, can't find it in Excel.
It can be done using VBA code but its a really bad idea.It produces jerky
unpredictable flashing and while its running nothing at all else can be done
until its stopped. Its nothing like the built in function in Word. My advice
is to ...I wish IM would let you create a batch of any reoccurence status
In Integration Manager I would like to be able to create an AP batch of
'weekly' status so that I can reuse document numbers for garnishment
reference numbers...it seems IM will only let you create a batch of type
single-use, so I have my users creating a batch of type weekly before
integrating so that they don't get an error on every line item that the
document number already exists.
We decided it was more efficient to integrate garnishments from that
spreadsheet that changes frequently than to edit a reoccuring batch which is
what brought this up.
Thi...Trying to make a duplicate roster with a button.
Previously posted in wrong forum.
Thanks for the help guy
virtex's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1488
View this thread: http://www.excelforum.com/showthread.php?threadid=26517
...How to make a workflow wait until the next 600AM, or the next Mond
Has anyone figured out houw to make a work flow wait untill a specific time
of day, regardless of the date? ie: I want to send an email out at 6AM, but I
don't care what date, just the next time it's 6AM.
As a follow up, how about waiting till Monday if its during a weekend.
Steve Noe, MCBMSP(2xCRM), MCT(CRM), MCTS-SQL
On Feb 14, 10:48=A0am, Steve Noe <Steve...@discussions.microsoft.com>
> Has anyone figured out houw to make a work flow wait untill a specific ti=
> of day, regardless of the date? ie: I want to send an email out a...How to make a Sales Process Die?
We had a sales process set up, and then decided it was not what we wanted.
I deactivated it, and deleted it in workflow manager.
Unfortunately, the opportunities set up under this process cannot be
dissassociated form the Sales process, and there doesn't seem to be any way
to purge the Sales process from these records.
It also causes some strange results on the Opportunity by sales stage reports.
Anyone know how to purge a Sales process Completely from the system??
Only way around this would be to recreate the opportunities. I do not know
what affect deleting the sa...I have question.. I have problem with Cells.find
I have two file (p1.xls , p2,.xls). When I work in file (p2.xls) i need to
in second file(p1.xls). Then write value from Cecha in the ActiveCell of
that Cecha is found
I have button and code:
but this code does not work how I want !! because search in file p2....
(it work on inversely)
What I should modify ?? that it search in p1.xls ???
Sub CommandButton3_Click() '------>in file p2.xls
Dim szukana As Range
Dim Cecha as String
Cecha = InputBox("Enter the name", "Enter value")
If Cecha = "" Then Exit Sub
i can't modify smartlist reports is there a way to modify reports from
smartlist. can i modify smartlist reports in version 9 or in the succeeding
If you are talking about creating you own smartlist reports, you can use
Smartlist Builder. This will allow you to create your own smartlist, as well
as use SQL Views to pull into Smartlists.
If this is not what you are looking for, can you please explain a little
more about which reports you want to modify in Smartlist.
> i can't mod...How do I make multi column stacked graphs in Excel
See the links on Jon's page for Cluster Stacked charts.
Ed B wrote:
...Make outlook default mail client
How do I make sure the Outlook is my default mail client? I'm using Outlook
Disclaimer: Any comments made are personal and do not reflect the thoughts
or policies of this company.
Control Panel - Internet Options - Programs - pick Outlook.
Brendan MAther wrote:
> How do I make sure the Outlook is my default mail client? I'm using
> Outlook 2000 SR-1
"Lanwench [MVP - Exchange]"
<firstname.lastname@example.org> wrote in message