What i want to do is really simple.
I have column B with 50 numbers. I want to set up column C so that in
C2, if B2=B1 and then it returns a value or something like false. It
really doesn't matter what it returns though.
Then in C3, if B3=B2 OR B3=B1 then it returns the false value
Then in C4, if B4=B3 OR B4=B2 OR B4=B1 then it returns the false.
Then in C5, if B5=B4 OR B5=B3 OR B5=B2 OR B5=B1 then it returns the
Can anyone help please?
I think I could do it with alot of logical statements, but you can
only put 30 conditions into one cell. With a list of 50 numbers t...Landed Costs Setup help
Hello, I would appreciate some advice on landed costs setup.
Let=92s say I import goods from Germany. I use a shipping company
called CargoShipers, Inc. CargoShippers takes care of handling the
shipping costs, duty and inspection fees. So I go into inventory and
setup 3 service type items for shipping, duty and inspection. But
what do I set the inventory asset account to? These are really
Then once I create the service type inventory items, I need to create
3 landed cost ids =96 one for each type and assign those ids to
CargoShippes as the vendor correct?
I have been playing with MS Query in Excel2000, and have
noticed that when I type data that contains both numbers
and letters, query doesn't recognise it and does not
I have tried to format the cell so that it is recognised
as text but still it does not recognise it. It is also
interesting to note that MS Query puts a decimal point and
a 0 behind the data that are numbers.
Please tell me what I have to do to make MSQuery recognise
data that contains both numbers and letters
...Queries returning different formats
I have cut and paste the same expression from a query to another, however
when i do this it changes the format of the information returned.
In the inital query it returns (Hours:Minutes) perfectly, expression is
When I paste it, it returns a decimal value (which I presume is the way
access formats time), and adds '' to the expression i.e.
([EDMain]![EDDischargeDate]+[EDMain]![EDDischargeTime])-([E...The query could not be processed: Error opening data file
Using Excel 2003. Create a chart and have saved it as a web page and
published to a remote share.
When I save it locally, it works fine and is interactive,etc..
When I save it remotely and open the htm file in a web browser, it opens
like the charting area but the data is not present. Gives error below in the
pivot table that appears.
The query could not be processed:
o Error opening data file
Any idea how to fix it ? I want others to access it remotely.
Trying other...convert Days to Years, Months, Days
I want to convert lets say 1890 Days from today to Years Months, Days!!
Ex: 1890 Days = 6 years, 3 months and 23 days
What is the formula???
=TODAY()+1890 and format as a date. for the first part.
Don't know what the Example has to do with the question.
If you don't want the date shown above, then
show what is supplied and what you want preferable with low cell addresses..
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/sea...MS Troub Assis
Dagnabit! I need help on the HELP!!!
I'm not very server tech savvy, but....
can someone give me an example of a server name and corresponding Global
Catalog Server Name?
I have entered the following for the server name (this is for example
and the following for the Global Catalog Server Name:
\Global Address List
When I click on the next button in the Microsoft Troubleshooting Assisstant
during a check for mail delivery trouble, the following error comes back:
Error accessing active directory
Comment: I don't know if my server ...Text cutting off on screen but perfect on print preview HELP
Whats up everyone I am having a weird problem. I have column labels i
Row 1 and Olympic Mean is showning up as pic Mean, the rest is cutof
due to the column size (6.67) Anyway when I print out this workboo
Olympic mean displays properly. How can I get the sheet to displa
correctly? I am currently in page preview.
I have the same labels in another workbook and Olympic mean display
perfect in the other workbook.
This is frustrating me to no end. Please help. Thank you all i
TwEaKFrEaK's Pr...converts queries from access2002 to sql sarver
Is there a tool that converts the queries form access2002 to sql sarver?
Lots of Access Queries should work fine in T-SQL unless you use functions
(Access / VBA inbuilt or custom functions) or Parameter Queries.
I am not aware of any tools to convert these Queries to T-SQL.
Van T. Dinh
"monther" <email@example.com> wrote in message
> hello :
> Is there a tool that converts the queries form access2002 to sql sarver?
Sorry, I don't know of any as I wro...Access Help Forum
Is there an Access Help Forum?
saziz's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=635
View this thread: http://www.excelforum.com/showthread.php?threadid=38569
Here's a page with LOTS of MS Application links (including Access):
Ron Coderre's Profile: http://www.excelforum.com/member.php?action=geti...URGENT HELP!!!!!
I am trying to fix some problems our company is having with the e-mail
we are using Microsoft outlook 2000. the problem is.....
We use the same server for incoming and outgoing mail. eg.
mail.xxxxxxxxx.co.uk, the problem is we can all (8 of us) receive mail but
we can't send it. we have tried the firewall but no ports or programs are
blocked. it must be something in our building as when I went home I set up
my work account on my laptop and could send and receive it from there.
This is urgent, so all help would be appreciated.
John <johnhutchisono2...Help with public folders
Im running windows 2003 with exchange 2003 and when i try
to view the properties of a public folder i created i
get "The operation failed because of an HTTP error 501
(not implemented). ID no c1030af6. If i try to view system
folders under the folder root i get a similar error: The
operation failed because of an http error 501 (not
implemented) verify that the exadmin virtual root exitsts
on the destination server. Id no c1030af7.
I am recieveing an error from the client application,
outlook 2003, specified object cannot be found while
syncing up the public folders
Any help wou...plz help....transfer .aba to outlook
i just had a quick question on .aba fiels
i want ot transfer all my contacts from my really old palm to my new hp
ipaq h1945....i created a address book file...but the only thign they
had was *.aba type
i would like to get teh *.abab fiel into outlook so i can tranfer that
to my hp ipaq
hopefully that made sense
thnaks for the help
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
...Need Help in MS Access & using Themes
Hi every body,
I am a new member in google and google groups.I am from Saudi Arabia
(Qatif) , My House is near the Arabian Gulf.
I am a student in King Fahd University of Petrolium and Minerals in
Saudi Arabia,(My major is Managment Informatiom System),
I am very interesting to join with You and shares information and
I am preparing for project in (a course), and I faced some problems:
1. I want some themes related to FootBall for Access , and How can I
This is what I think about [This is my CustomerID- the initial one
07 01 000...help on sort
I have a sheet contains data in colum A to G and I keep on adding dat
below it. I want to run a macro to sort the data. I need a macro t
find the last row and do the sorting on column C. Hope you got what
Message posted from http://www.ExcelForum.com
If there's no other data on your worksheet, you could just sort A:G.
.sort key1:=.columns(3), order1:=xlascending, header:=xlno
if you can use a column to determine the last used row (I used A in my example):
With Worksheets("sheet1&...MSN Stock Quotes help
I am trying to do something that I assume is relatively simple. Using Excel
2000, I want to import **ONLY** the "Last Quote" stock quote for a
particular symbol. I have tried the "Data | Get External Data | Run Saved
Query" function, using Excel's built-in query for retrieving staok quote
data from MSN website. However, this function returns the entire detailed
quote tables with all sorts of info that I do not need. Does anyone know
how I go about importing only the "Last Quote" data and nothing else? TIA.
In xl2002, you may edit the q...Need help, clueless
I have just started using excel and im running into, what probably is, a
simple problem. This is exactly what I need.
I have two sheets (February & March). I want the number in February B8
to copy into March B3.
Thanks in advance
brian1175's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31818
View this thread: http://www.excelforum.com/showthread.php?threadid=515468
"brian1175" <firstname.lastname@example.org> wrote
i...Printing a Year-End Report Again #2
I was closing the Receivables Management for the year and I accidentally
closed the Receivables Year-End report without printing it. How could I open
this report again? I would like to print and save this report but I am
already done closing the year. I am using Dynamics version 7.0.
...Please help me!
I have an excel file as monthly report. Everymonth I input new value
overwrite onto fields of file (replace old value). But I dont know why
file size is increased after each change time.
Thanks a lot!
khanhtt's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25092
View this thread: http://www.excelforum.com/showthread.php?threadid=386039
Try the following to see if it helps:
2. Copy the wor...userform help
I'm trying to insert data into the first empty cell. My code keeps
overwriting the last entry...could someone help me figure out where I've
Thank you in advance
Private Sub CommandButton2_Click()
Dim rRng As Range
Set rRng = Range("A" & Range("A" & Rows.Count).End(xlUp).Row)
With rRng.Offset(rRng.Count + 1, 0).Select
rRng.Offset(1, 1) = Me.TbDate
rRng.Offset(1, 3) = Me.cboname
rRng.Offset(1, 5) = Me.TbPO
rRng.Offset(1, 6) = Me.TbCustom
Private Sub CommandButton2_Click()
Dim rRng As Range
LastRow = Range("A&qu...RFR Interface Errors HELP!
Help! I keep getting the following errors on our Exchange 2k3 server.
It's running on a Win2k3 DC that is also a Global Catalog server. It's
been in this configuration since Exchange 2k3 was released. Suddenly,
I'm getting these odd errors:
Event Type: Error
Event Source: MSExchangeSA
Event Category: RFR Interface
Event ID: 9143
Time: 7:15:17 AM
Referral Interface cannot contact any Global Catalog that supports the
NSPI Service. Clients making RFR requests will fail to connect until a
Global Catalog becomes av...Conditional Format Formula Help
I have a column of names. Some of these names are in a separate list
and some are not. I have a macro to change the color of the cell of
the names that are not in the list to red. When I find these names
that are not in the list and correct them so that they are now in the
list, the cell color is changed back to white. The problem is in
quickly identifying which workbooks still have uncorrected names in
this column when I open it.
For example: In the CF of D1, If any cell in column D is red, then
change the color of D1 to brown, otherwise, change it to orange
(defa...Check boxes on querys
i have a query about search for if a check box is ticked or not on a query.
On one database if the box is ticked it is shown as -1 when i do a search,
which is great as i can just search for those with -1 in it.
However we have another database designed by someone else where in the
search it is just showing as a box with a tick on it, -1 doesnt work, Is
Null, Is Not Null doesnt work, does anyone know how to define the criteria on
this checkbox that it picks up just those that are ticked/or not ticked?
I am surprised that using -1 in the criteria doesn't work. I...Please Help! COleDateTime in VC++ 6.0
I am using VC++ 6.0 in Win 2000
When I try to use the COleDateTime function in the app
StringTmp = COleDateTime(vExpirationDate).Format(_T("%d.%m.%y %H:%M:%S"));
I get the error msg on some computers
the msg is
"Debug Assertion Failed!
Why this function doesn't work on some computer
Thanks for your post. I reviewed your description carefully, and I think
more information is needed before moving forward:
What's the value for vExpirationDate?
Did you build your program with _UNICODE? What are the computers which ...Min/Max need help
Im trying to put a formula in CL4 for min hours for CJ5:CJ65 & if <=0 have
ALSO in CM4 FOR max HOURS for CJ5:CJ65
For the MIN:
Array entered** :
** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.
For the MAX:
Microsoft Excel MVP
"Mike" <Mike@discussions.microsoft.com> wrote in message
> Im trying...