Feb 28,2008 ---> 2008-2-28
Feb 1,2008 ---> 2008-2-1
"����" <email@example.com> wrote in message
> Feb 28,2008 ---> 2008-2-28
> Feb 1,2008 ---> 2008-2-1
See your other post
> Feb 28,2008 ---> 2008-2-28
> Feb 1,2008 ---> 2008-2-1
Highlight the cell, right click in the mouse, cell format, custom format and
> Fe...Vlookup edited
Hello all you wonderfulhelp,
Is it possible to avoid "NA" when using "vlookup" function. I need info
it brings results.
Gary''s Student - gsnu200851
Example of using ISNA rather than ISERROR which hides all errors.
Gord Dibben MS Excel MVP
On Thu, 7 May 2009 09:26:02 -0700, israel <firstname.lastname@example.org>
>Hello all you wonderfulhelp,
>...Find and replace 03-04-10
I'm trying to scan a field in one of my tables and find a specific character
and remove it. However, the character is a " so I'm having difficulty. The
field I speak of of contains the sizes of our material so the values look
1/3" and so on.
How can I find all of the " in my feild and remove them? I don't want to
replace them I just want to remove them.
Create a query, and in the Criteria row under the problem field, enter:
Allen Browne - ...Formula needed 01-22-10
I need a formula that will look in one column range for a certain value and
for another value in another column range and when they are both found in the
same row, will count the number of occurances. Help!!!!
> I need a formula that will look in one column range for a certain value and
> for another value in another column range and when they are both found in the
> same row, will count the number of occurances. Help!!!!
Omit the "values to be summed".
=SUMPRODUCT(--(A2...SendTo PDF Not Working on GP 10
I upgraded a client from GP 8.0 to GP 10.0. Since the ugprade, they are
unable to use the SendTo PDF option from within GP. We have tried
reinstalling Adobe and that hasn't changed anything. The users can see the
PDF being created but a blank email doesn't open from their email client as
it used to. The client is on version 10.00.0991 and I thought this issue was
to be resolved in 10.0 SP 1 but obviously it hasn't been for us. The client
is also using Outlook. Is this still a bug with 10.0 or are we missing
I am on Adobe Acrobat Standard 8.0 with Microsoft ...Lost contact list 04-22-10
I amusing Windows live mail...it had no problem picking up my contacts from
Now that I syncronized messages from my Hotmail e-mail account and my Telus
email account into Windows Live, my contact list is only the two contacts
from the hotmail account. All the rest are gone. They are still in the
Address Book, but I cant access them
How can I get it back into Windows Live Mail ??? Help please.
You signed into the Hotmail account when you started Windows Live Mail.
This is optional and not at all related to getting your mail.
When you sign in, WLM sync...Outlook 2003 03-17-10
1. Process will complete mailing address to sent item means anything ?
2. Repairmail up screen time that does not match the running because of what ?
3. The move affects the computer to send mail or receive ?
On 3/16/2010 8:19 PM, supatsiri wrote:
> Dear Sir,
> 1. Process will complete mailing address to sent item means anything ?
> 2. Repairmail up screen time that does not match the running because of what ?
> 3. The move affects the computer to send mail or receive ?
> Best Regards,
What is your native language? Please post ...vlookup problems with left
I'm using vlookup,i have a 10 digit number which i have to mach with 9 digit
number (last digit is some kind of control digit) and when i use left to
take only the first 9 digits
i get #N/A
if i manuallly delete the 10th digit i get mached data.
is there a problem with using left on vlookup?
=left() returns text. That will never match a real number.
I'd take the integer amount after dividing by 10.
But if you're really only looking to see if there's a match, you could use:
...vlookup help linking data between worksheet
I have a master list of students (about 200+ )in one worksheet. On the
succeeding worksheets are the attendance for seminars. We have more than 20
seminars in a year. Because of the large no of attendees per seminar, I
usually type out a list of the students who came for each seminar, so there
will be 20 +attendance worksheets.
Not all students will come every time and there are new ones for each session.
To update on master list, I will sort each sheet by surname, print it out and
type in separate column (date) for each session and typed "P" for present
and &quo...disappearing e-mail 04-21-10
This has happenend several times: Vista; When I open my e-mail, some email
just disappears, it's not in any folder, it's just gone. I''ve read other
threads that say make sure you are are set to show all messages and I am.
"Trish1856" <email@example.com> wrote in message
> This has happenend several times: Vista; When I open my e-mail, some
> just disappears, it's not in any folder, it's just gone. I''ve read other
> threads that say make...Join based on next closest value (like Excel VLOOKUP)
Trying to do something similar to a VLOOKUP (Excel) in an Access 2003 query.
I have the following tables:
I need a query that takes JOBS.Quantity, looks it up in COSTS.Quantity and
find the cost for the NEXT LOWEST quantity. (Example: Job B has a quantity
of 256 and the next LOWEST quantity from COSTS is 200 so Job B costs $1500.)
The results should be as follows:
This would be ...Mail Merge 03-12-10
I have a log that has multiple lines with the same individual that I am
trying to merge into one page per individual in word, I have to do a more
advanced mail merge.
Assuming you are using Word for the mailmerge and Excel for the source see
these sites for help.
Gord Dibben MS Excel MVP
On Fri, 12 Mar 2010 08:33:01 -0800, Brooke
>I have a...Dynamics GP 10 Reporting Question
I heard reporting in GP 10 is upgraded. Does anyone know if it will be
anything like Rockton Software Dynamics Report Manager where you can send any
report to like Sql reporting services or crystal?
I haven't heard anything at all that reporting in 10.0 will be changed.
While I guess it's possible, I would assume for now that there won't be any
big changes in general. I would expect more MS Office & SQL integration in
the next version for sure, but I can't see everything rewrit...Home based Job For Indian
Want the pleasure of life, don't worry, work 1-2hours/day and earn Rs.
10,000-15,000/month online from your home/cafe/office
For details write # firstname.lastname@example.org
Please write the subject of mail as: "Job Inquiry"
...Date and Time 05-14-10
I have cells in a worksheet that are formatted as date but still show as date
and time. How do I pull out the time.
04/07/2009 1:00:00 AM
I have tried the =left() and also =right () formulas with no luck.
Date and time are just numbers underneath the formatting.
04/07/2009 1:00:00 AM is 39910.04167
Format the cell to General to see that number.
Use Data>Text to Columns and delimit by decimal point.
In third step choose the right hand column and "Skip"
Re-format the cell.
Gord Dibben MS Excel MVP
On Fri, 14 May 2010 14:30:0...pick a number from 1 to 10
i want to create an asp.net web page that allows internet users to pick a
number from 1 to 10. how do i manage users picking the same number? (if 2
users somewhere happen to be selecting the same number and the same time). Is
this a concurrency issue?
On 19.12.2009 19:01, rodchar wrote:
> i want to create an asp.net web page that allows internet users to pick a
> number from 1 to 10.
You may use ten links or buttons. But what should happens after they
"picked" a number?
> how do i manage users picking the same nu...Excel
Help, my formulas does not seem to calculate negative numbers. If a= 91 then
result is 30 days.
You need to give the formula a complete cell reference A1, or A2, not just A.
Also if you want -90 to return "-90days", and -60 to return "-60days", then
you will need to replace "<" with "<=" like this:
using the "customization" in "Settings" showed me an "E-mail" entity,
althought there is no way to setup where to display it ("Areas that display
this entity") and I'd like to find out how to adapt this!!
Thanks for your helpfull reply,
Email enitity is a type od Activity, there is no way to modify display area
for activities in user interface.
You can try to modify sitemap.xml, but you will need some knowledge...
"Sture Van de moortel" wrote:
> using the "customization" in "Settings" ...Query help please 04-08-10
I have two combo boxes. Location and Super1
The location box lets you select a location where a staff member is working
at.For example U3 B-days.
The Super1 box lets you select their supervisor who works U3 B-days. As it
stands right now it will work. The problem is that it will show all
Supervisors through out the whole place.
I found a way where I can select from the Location box where it will pull up
just the supervisors for that location in the Super1 box. That works so far
Now, where the problem comes in is when the staff member is a supervisor. For
Staf...Linking cells 01-22-10
My excel skills are lackluster at best, but I am trying to link specific
cells in 2 different spreadsheets and could use some help.
What I would like to do is automatically update a column in one file when I
enter info in another column in the other file.
Basically I need the date to update automatically to show the last pick up
date for specific suppliers.... for example, if we pick up from XYZ company
on Jan 1, I need that date linked to that client, and then we pick up again
from XYZ company on Jan 21, I need the date updated to Jan 21 on the second
Hope this m...xldialogprint arguments 01-25-10
Are there any arguments that I can pass in the .show method. I am
specifically looking for a way to hide the print preview button.
I don't believe you can hide the print preview button. You can though preset
most of the options by passing the relevant arguments.
range_num, from, to, copies, draft, preview, print_what, color, feed,
quality, y_resolution, selection, printer_text, print_to_file, collate
"TWR" <TWR@discussions.microsoft.com> wrote in message
=IF(ISNA(VLOOKUP(B2,'TableB'!$Y$2:$Y$100,1,FALSE)), "",Column A in
This is the code i have.
I want to search tru all column B in table A. If i find an identical
value in table B i want the field in table A to show the corresponding
field in Column A in table B.
Also if there is 2 occurences of column B in table B, i want the field
in table A to show both values.
Any ideas? (if u can understand what im asking)
Hazy's Profile: http://www.excelforum.com/member.php?action=g...encryption 03-16-10
I remember there're some products for encrypting the VBA codes (Excel
macros). Has anyone ever used that?
Many Thanks & Best Regards, HuaMin Chen
...Rounding Problem 05-14-10
I have been reading through previous posts, and nothing I have tried is
working. I have changed the field i want to round to 3 decimal places in the
BE table. It is now Double, Standerd, 3 places. When i open up the form, its
the same, but its still rounding it. Not sure why or what to do. Everything I
have tried fails. PLEASE HELP!!
Nevermind, I figure it out, ha...It seems like I try everything and can't get
it, but as soon as I post that I need help, I figure it out, hahaha.
> I have been reading through previous posts, ...If(vlookup statement
I have three columns that I need to return a vlookup value.
A B C
8 2 PSS
I want to lookup column A in my table to return the name, if not then lookup
B and return the name, if not then lookup C, otherwise give me "Part 1 -
Other". In this case none of A, B, or C is found so my result should be "Part
1 - Other". My lookup table is below:
CLASSIFIERID GENERICATTRIBUTE1 GENERICATTRIBUTE2
ANH Part_4 Athena Part_4 Athena
21 Part_4 Specialty Part_4 Specialty
24 Part_4 Specialty Part_4 Specialty
CR Part_4 Specialty Part_4 Specialty