Assign a Value to a Duplicate Entry Within the Same ColumnWithin a single worksheet I have thousand-plus rows of data and one of the
columns within that worksheet I have a series of numbers. After I've
identified the duplicates within that column I want to assign a value based
on the first time that number shows up (in this case by I'v sorted by date),
so the first duplicate would have a value like "1." I then want to assign
the next duplicate(s) sequentially (2, 3, 4, etc.) When finished I would
want a new column of data that would have far more "1s" than "2s," more "2s"
than "3s,"...
Find FirstI am having trouble making this work. I am trying to do a find in a subform.
Dim rs As DAO.Recordset
If Not IsNull(Me.Command33) Then
Set rs = Forms![fAddGroupCat]![fAddGroupCatSub2].[Form].RecordsetClone
rs.FindFirst "[Descr2] = """ & Me.Command33 & """"
If rs.NoMatch Then
MsgBox "Not found"
Else
Me.Bookmark = rs.Bookmark
End If
Set rs = Nothing
End If
Thank you,
Steven
Also: How can you tell it to start at the last record an...
boolean find criteria in ExcelIs it possible to set up the Excel Find and replace to find a or b or c in a
cell of content a,b,c, etc?
Thanks!
Trent
I wouldn't think so.
--
Regards,
Tom Ogilvy
"davista00" <davista00@discussions.microsoft.com> wrote in message
news:A20AE105-09AB-4681-AD60-60E08F0345BF@microsoft.com...
> Is it possible to set up the Excel Find and replace to find a or b or c in
a
> cell of content a,b,c, etc?
>
> Thanks!
> Trent
...
Finding Merged CellsIs there any (easy) way of finding a cell or cells that
have been merged?
I am trying to sort a (very large) spreadsheet but can't
because Excel "...requires the merged cells to be the same
size..."
I can always select all and remove the merge - but I am
wondering why there are merged cells - hence the reason
for trying to find them!
Many Thanks - I like the macro solution - it certainly
works on a test setup - I'll try it on the real
spreadsheet tomorrow
>-----Original Message-----
>Manually, you could divide and conquer. Select half the
range, hit ctrl-1 (t...
Help finding Exchange Server or AdministratorI have been unable to use Outlook because I I can't access an Exchange Server
or get an HTTP address from an. THese are the messages I continue to get,
that doesn't allow me to move forward with use.
Help!
Do you have an exchange server account? If so, contact your email
administrator. If you don't have an exchange account (or if you don't know
if you do, you probably don't) then you may need to create a new profile.
What version of outlook do you have?
If you have an exchange account and use OWA, see
http://www.outlook-tips.net/archives/20030904.htm if you want...
Find duplicate cellsIs there a way to find all the cells with identical entry? I'm trying to
find duplicate information but I don't know what the duplicate entries are.
Find and replace does not have an option to find something like that.
TIA,
cpliu
Hi
have a look at
http://www.cpearson.com/excel/duplicat.htm#TaggingDuplicates
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates
--
Regards
Frank Kabel
Frankfurt, Germany
"cpliu" <chanciusliuDeleteThis@yahoo.com> schrieb im Newsbeitrag
news:Xns94A16109E4C87chanciusliuDeleteThi@130.133.1.4...
> Is there a way to fi...
Trying to find out if I'm hacked.I am a new Exchange 2003 admin and I'm trying to find out if my sever has
gotten hacked. Here are the symptoms:
1. I am getting odd emails from senders liked Bounced Mail and stuff,
saying that I've been sending out massive amounts of spam
2. My server is emailing me alerting me that store.exe is allocating more
memory than normal.
Here is what I have done this far:
1. Checked my server's queue to see if there are bunch of items, there are
none.
2. Run my virus scan program several time and found nothing.
So on the surface things seem ok, we are still sending and receivi...
Advanced Find 05-22-06Hi,
I would like to search for services details using Advanced Find and
make/create a report with the resources information. For example... I would
like to know the users that are working on a specified service? or What
resources groups the user belongs and then make a report with that
information.
If i go throw the resource group area i can create a report with that
information, but it doesnt include the user email for example.
Any sugestion how this could be done?
thx
...
Advanced Find in contact's birthday problemHi,
I'm having a simple problem in MS CRM 3.0 regarding advanced find with
Contact's birthday. My filter criteria is Contact's Birthday as entity and
operator "Today". The result is nothing. But when I checked the birthday of
one of the contact, there exists at least one. I noticed that the advanced
find also matching the year. when I changed the birthday from 7/20/1954 to
7/20/2006, the advanced find output the result. How can we go about this
problem?
True, this is one of the thing I hope Microsoft will implement in the
next version (or better service pack :))
...
ADO FIND questionI have a VB program accessing non-indexed tables (by primary key). I'm using
the RECORDSET.OPEN / RECORDSET.FIND syntax, coupled with RECORDSET.MOVENEXT.
I would like to be able to stop the quesry when the last record with my
specified value is found. How can I do that when the field I'm using is not
indexed (even though it's a key field)?
Any insight would be appreciated.
Thanks!
A primary key is an index.
I'm not sure that I understand the rest of your question. How is your code
supposed to know that the last record to match your criteria is the last
record without...
Cannot find GWL97.xlawhen I try to open or close a file in other then safe mode
xl flashes cannot find GWL97.xla, I am using office 97,
everything works of in safe mode. Can anyone Help, I am
new at excell, but am used to lotus 123.
"Roger Poor" <r.poor@worldnet.att.net> wrote in message
news:03cf01c347b4$70ecd340$3501280a@phx.gbl...
> when I try to open or close a file in other then safe mode
> xl flashes cannot find GWL97.xla, I am using office 97,
> everything works of in safe mode. Can anyone Help, I am
> new at excell, but am used to lotus 123.
I beleive GWL97.xla is a Groupwi...
DirSync of Novell Connector, doesn't find existing usersDirSync of Novell Connector, doesn't find existing users
...
Macro to find the first cell in a column with different dataHello,
I really could use some of your expert and excellent help with a problem I
am having in creating a macro to perform a search in "Column A" to locate a
change in the data in that column and then move one column to the right and
one row down and type "1" in that cell.
I really appreciate your help, and Have a Blessed Holiday Season.
Perhaps this might also do it here ..
Assuming data is in A1 down, of the structure as below:
1
1
1
2
2
3
3
etc
Put in B2: =IF(A2<>A1,1,"")
Copy down
Kill the formulas in col B with an in-place:
Copy > Paste spe...
finding hidden tab settingsI appear to have some hidden tab settings from text that I have imported from
WordPerfect. How do I find and delete them? I am accustomed to using
"Reveal Codes" and am totally lost. I did save the text as text only, but it
appears that the tabs came over with the text.
...
Multiple Journal EntriesFrequently one of our users gets multiple listings in
Journal from a single event. It doesn't seem to be
related to the event and can be listed up to 11 times (the
record). He is running Outlook 2003 on an XP sp1
Stinkpad. Our network is Novell/MS with Exchange 2000.
We've tried updating client, re-installing Outlook,
uninstalling ActiveSync, uninstalling Palm Desktop and
hotsync, and several other time-consuming non-solutions.
Any ideas? One more thing, he synchronizes all folders
upon disconnection each evening.
Thanks,
Goatscape
...
Rights to Run LoadSimLoadSim 2003 very clearly warns that you cannot run it unless you're a
domain administrator, because it "needs" to create accounts. I have tried it
with my permissions, and I can see that they mean it.
Are there any alternative utilities that don't have this restriction?
Is there any way to tweak LoadSim 2003 so that you can focus it on, say, one
OU in which you have been delegated? Even though this is just a test forest,
getting administrator rights on it can be a chore.
...
Find the top value in a listI have a worksheet created in EXCEL 2003 which i use to record swimmers times
in several lists. One examlpe is in cells D109 to 113. In cells D111 to 113
are recent times and D109 to 110 are empty. As I add current times to the
top of the list. I want to be able to retrive the current value at the top
of the list and show it in D106. D107 & 108 are used for other values. At
present I have the following formula in cell D106
=OFFSET(D108,COUNTBLANK(D109:D113)+COUNTA(D109,D113),0). This works well but
makes updating the list difficult. Is there a simpler way to achive the same...
Can find POP3 server but not SMTP?Hi all
I am having a problem connecting to an SMTP server with Outlook 2000 in
Windows XP, it says that the SMTP server is not found and gives me a
dialogue box to try and reenter it.
The POP3 server is the same as the SMTP server (different ports), and
it finds the POP3 server no problem and downloads mail, but when it
goes to send mails, it tells me that it can't find the server (even
though it just found it). Also I have tried pinging the server, and no
problem there.
I checked the ports - 25 for SMTP, 110 for POP3.
I also verified the following settings were correct by comparing wi...
how to find nodes at xml file without complete load the xml filehow to find nodes at xml file without complete load the xml file
since the file is very big!!
joe wrote:
> how to find nodes at xml file without complete load the xml file
> since the file is very big!!
You can read through the XML document with an Xml(Text)Reader, that is
forward only pull parsing where your code only pulls in the current node.
The documentation is here
<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemXmlXmlTextReaderClassTopic.asp>
for .NET 1.x and here
<http://msdn2.microsoft.com/en-us/library/system.xml.xmlreader(...
How find appointments that *start* 12a.m.?I'm using Outlook 2003. Is there any way to find all appointments that
*begin* at 12 a.m.?
Hint, it is *not* this:
FIND (button) > Options (pull down) > Advanced > (Appointments and Meetings)
> Advanced (tab) > Field (pull down) > Date/time fields > start (...which
only give options like yesterday, today, last week, etc. ... but not a
specific *time* like 12 a.m.)
The reason I need to see these is, I may have some holdover things from
several upgrades and and old Palm that may have been "no time" in the Palm,
but somehow got tagged as 12 a.m. at so...
clearing items shown by the AutoComplete feature in the Advanced Find Dialog boxHi all,
How can I clear the items shown by the AutoComplete feature in the "search
for the word(s)" field in the Advanced Find Dialog box??
Thank You
Max
I found that info in the MRU 1 value in the registry here:
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Outlook\Office Finder
You can try clearing/deleting that value (of course, the usual cautions
apply... export the key first just in case)
"max" <a@b.net> wrote in message
news:D8ymb.486287$4w.57408106@amsnews03.chello.com...
> Hi all,
>
> How can I clear the items shown by the AutoComplete feat...
Lookup / Array Range / find the valueI have seen similiar examples but not that were not using exact matches to
retrieve data. This seems simple and maybe I am over thinking but I have been
unable to crack this nut. I have a table where the first tier sales runs
between 0 and 20k and awards 1K commission. I want to be able to enter the
salse result for various team members and obtain the correct commission
amount based on their sales for the period. How should I complete the
commission formula for this process?
Sales Value Start Sales Value Stop Commission
$0 $20,000 $1,000.00
$...
Function to find hyperlink URLHi,
Is there function to return URL of hyperlink?
I don't want to use macros.
I'm using Excel 2000
Thanks in advance
Nikola Milic
>>Is there function to return URL of hyperlink?
A worksheet function? Afraid not.
--
Jim Rech
Excel MVP
But you could write your own (a userdefined function).
I used ctrl-K (insert|Hyperlink) to create the link:
Option Explicit
Function GetURL(Rng As Range) As String
Application.Volatile
Set Rng = Rng(1)
If Rng.Hyperlinks.Count = 0 Then
GetURL = ""
Else
GetURL = Rng.Hyperlinks(1).Address
...
How to find the right MLM business online that succeeds for you #5U can 2
Hi there,
Building a MLM business can have it's advantages
* Lifetime Residual income
* Financial Security
* Spend more time with your kids
* Travel
* Get out of debt
* Drive a new car
* Purchase a vacation home
* Pay off your mortgage
But to be successful, you must choose the right company.
* Choose a company that is at least 3 years old.
* Choose a company that has a product or service everybody can use.
* Choose a company with a easy to understand compensation plan.
* Choose a company that has a low monthly fee, where most everybody can
join.
* Choose a company that ...
Finding cell text corresponding to the MAXimum figure in a spreadsheet?
Please can anyone help me with this... :)
I've made a spreadsheet with the following attributes:
Cells A1 to A100 contain a figure from 1-100 (a 'desirability' rating),
sorted so that the highest figures are at the top of the spreadsheet and
descend to the lowest figure in cell A100.
Cells B1 to B100 contain the title of a CD album.
Cells C1 to C100 contain the price of a CD album.
I would like to make a formula that searches for the row that produces
the highest result given from multiplying the figure in column A with
the corresponding figure in column C and returns the co...