Find cell value within table
I would like to find if the cell value of A1 exists in table A2:AA450
I have tried with ISNA and Match but Match does not seem to work as I have
more than one column and row:
Match(A1,A2:AA450,0) returns #N/A
Maybe =countif() would work:
> I would like to find if the cell value of A1 exists in table A2:AA450
> I have tried with ISNA and Match but Match does not seem to work as I have
> more than one column and row:
> Match(A1,A2:AA45...Using this News Group
I would appreciate it if someone could tell me if I have a setup problem on
my computer or there is sometimes a problem with this news group when I
access it IE7.
After I sign in and see an item that I want to reply to, I press on reply.
After I clicked on the reply sometimes the window pos up and I am all set to
reply the way I expect other times I get no response or I just get the same
message that I was looking at.
Anyone else experiencing this issue?
"neil154" <email@example.com> wrote in message
news:A345E68D-C3B9-4FD8-8211-CACE1374C389@microso...Subreports containing Pivot tables and charts
I have a main report that contains subreports. One of them has a pivot table
and another has a pivot chart. When I try to export them to MS Word, the
pivot table and chart don't show in the word document....
Any pointers to what could be the problem is very much appreciated...
Thank you very much,
...trying this out
This is a test posting.
On Tue, 13 Nov 2007 16:06:51 +0800, "hmmmm" <firstname.lastname@example.org> wrote:
>This is a test posting.
Please use microsoft.public.test or microsoft.public.test.here for your
testing. This is a working newsgroup. If you have questions about an Access
database, please post them.
John W. Vinson [MVP]
...Recorded macros not working using the shortcut keys
I have recorded two macros that work fine except they do not run using
the shortcut keys I defined. I've stepped through the macros and the
shortcut keys are in the scripts, but I can only run them by pulling
up the list of macros and selecting the macro and clicking run.
I'm using Office 2007 in XP.
When you pull up the list of Macros and select your macro, go to the
options box and create a shortcut key.
On Fri, 13 Feb 2009 06:11:40 -0800 (PST), CurlyDave
>When you pull up the list of Macros and select your macro, go to...Need to compare 2 tables and only pull certain records from one ta
I have a monthly sales file that contains several invoices that allows
duplicate records of parts. My second table is a different sales file that
also contains several invoices and allows duplicate records. I want to match
from the second table as a basis. How do I pull matching invoices from the
two tables without pulling all the data from the first monthly sales file?
FROM SecondTable INNER JOIN FirstTable ON SecondTable[Invoices] = (SELECT
FirstTable.[Invoices] FROM FirstTable GROUP BY FirstTable.[Invoices])
ORDER BY SecondT...I am trying to round up to the nearest 25 cents
I am trying to round a money value to the nearsest 25 cents and it keeps
rounding to the nearest dollar HELP
In article <2DB8F007-1E27-4A48-923B-C7D4D0238B5E@microsoft.com>,
sypher <email@example.com> wrote:
> I am trying to round a money value to the nearsest 25 cents and it keeps
> rounding to the nearest dollar HELP
"sypher" <firstname.lastname@example.org> wrote in message
> I am trying to round a mone...Trying to clear up Received but not invoiced report
I am trying to clean up the received not invoiced items. The problem
began with entering a purchase order and then not matching the invoice
to the items received agaisnt the purchase order. SO we thought that
doing a returned transaction entery would solve the problem. The only
thing is now the return shows up on our Received/ Not invoiced report.
And the report is becoming a huge mess and difficult to use. What is
the best way to clear up items that have been received but were not
matched and already paid through the invoice entery?
There is a knowledgebase article on this very thing av...C++ Version 6 app using c++ version 8 dll
My company is in the process of migrating to Visual Studio 2005. For now
only new development is happening in 2005, leaving existing programs in
I have developed a MFC version 8 dll. A version 6 application needs to link
to this new dll. The problem I am having is related to STRINGS. The dll
exports a few functions that have strings as parameters. These function
generated linker errors.
TestDlg.obj : error LNK2001: unresolved external symbol "int __cdecl
Test(char const *,char const *)" (?Test @@YAHPBD0@Z)
Test.obj : error LNK2001: unresolved external ...Do i have to use an HOTMAIL account for Windows Live Mail?
I'm so frustrated! I just got a new website for my business and I am trying
to set up my e-mails through windows live but it keeps sending me errors. I
am inputting all my information as the guy told me to but it still isnt
working. Apparently my e-mail will work in OUTLOOK though. Can anyone tell me
if i have to use an hotmail account or if i can use my own such as
Please post the error message in its entirety. You can left click on it to
highlight and then right click to copy and then paste it into this thread.
MS-M...send/receive (2nd try)
New computer. Microsoft XP Home. Microsoft Office XP
Small Business 2002. Earthlink dial-up account. Two e-
mail accounts. After opening Outlook, 1st send/receive
(option 3, all accounts) usually prompts for both
passwords, downloads messages, all good. Next time,
though, no prompt for account 2, error cannot connect to
server, account 1 usually gets messages. Every five
minute send/receive option eventually degenerates to
cannot connect to server errors for both accounts.
Meanwhile internet browsing slows to a crawl. Any ideas?
...How do I cancel a msg Outlook keeps trying to send unsuccessfully?
How do I cancel an "in process" email Outlook keeps trying to send
unsuccessfully due to a huge email message I tried to send with way too many
attachments? It's stuck in "send" mode, and as a result, I can't send any
emails because Outlook cannot get past trying to send this message. How do I
cancel a pending outbox transmission while it's trying to send? I've tried
everything I can think of to no avail. Please help!
Angelczech wrote on Fri, 12 March 2010 07:32
> How do I cancel an "in process" email Outlook keeps trying to send
...Join same field on two tables
Forgive if this is really stupid. This is what I am dealing with in
terms as simple as I can come up with:
I have one table with multiple records (country names) and multiple
fields (over 20). I have a second table with that contains only a
limited number of records (all of which are also represented in the
other table) with only two fields (also represented in the other
table). I need to know if it is possible to make the information from
the second table "join" with the first table and display the data from
both tables in one column.
Does that make any sense?
You can combine da...Count of unique values in Pivot Table
I have exported values from a defect tracking system into excel
Each defect is categorized in one of a couple of hundred different
I want to somehow display the count of the unique categories (and not the
number of defects asssociated with each category).
Is there a way to do this using Pivot table functions -- as opposed to
exporting the list, using advanced filters, etc.
Thanks in advance
Check Debra Dalgleish's site:
> I have exported values from a defect tracking system into ...VLOOKUP use column name not number
Is there a way to use VLOOKUP to search for a column name and return the
value in that column, rather search for a column number.
Thank you, Kathy
> Is there a way to use VLOOKUP to search for a column name and return the
> value in that column, rather search for a column number.
Use INDEX/MATCH. Look here:
Something like this...
Microsoft Excel MVP
"kathy" <email@example.com...trying to insert a 0 in front of zipcode
Hello, I do not use excel at all so i have no clue!
I have a list of daycares that i want to create mailing labels with...about
700 of them but the problem is my zipcode column there needs to be a zero in
front of all 700 zipcodes how to i insert a zero in front of them without
having to type it into each box? the other question is can i print labels
directly from excel or do i have to go thru ms word?
One of these
1) format the cells with custom format 00000
2) format the cells with Special / Zip Codes
3) format the cells as Text
4) begin all zip codes with an sin...error message when trying to install WMP 10 or 11
My operating system is Windows XP Home Edition 2002. I'm trying to download
either WMP 10 or 11 and I get a message saying it was not possible to
complete setup, see webhelp for more assistance, however there is no
additional information when I click Web help. the Error message is 8007F0DA.
Can anyone help me? Thanks.
On Tue, 30 Mar 2010 07:54:01 -0700, Nate
>My operating system is Windows XP Home Edition 2002. I'm trying to download
>either WMP 10 or 11 and I get a message saying it was not possible to
&g...Try or TRY
Will there be any opitmization or ... when we use INT or TRY macros instead
of int or try ? Which one is better to be used?
"JSmith" <firstname.lastname@example.org> wrote in message
> Will there be any opitmization or ... when we use INT or TRY macros
> of int or try ? Which one is better to be used?
Jeff Partch [VC++ MVP]
FYI, TRY ...< and > not showing in pivot table
I have created a pivot table placing a date field in the column box.
have given a date range to display (5/1/2004-12/31/2005). All of th
months within this range are displaying fine but I also need a colum
for the <5/1/2004 and >12/31/2005. These show up under th
PivotTableField popup in the Hide Items box but even though they ar
not highlighted they don't show up on the table. I am running Offic
97. Any help would be appreciate
Message posted from http://www.ExcelForum.com
Is there data for those date ranges for the selected row fields?
Reds < wrote:
> I have created a...Money 2004: Got an error attempting to use ePay
I recently purchased MS Money 2004 Deluxe. I decided to use the MSN Bill
Pay (I have never used it before). Tonight I sat down to pay a couple of
utility bills. When I did each generated the following error message:
"Your payment was not processed for the following reason: An Internet
communication error occurred. Please try your call again later.
What does this mean? And what about the bills I attempted to pay? Are they
paid, or not? And if not, then how do I get them resubmitted to be paid?
...Help with Function: Between Time
Why this function is not working?
If a time follows between 12AM and 3PM it should show Day shift, anything
else Night Shift
If Time > #12:01:00 AM# < #3:00:00 PM# Then
MsgBox "DAY SHIFT"
MsgBox "NIGTH SHIFT"
If Time > #12:01:00 AM# AND Time < #3:00:00 PM# Then
MsgBox "DAY SHIFT"
MsgBox "NIGTH SHIFT"
Note that you need to repeat the entire comparison.
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
Bre-...error message when trying to delete messages in inbox
I cannot delete messages in my email inbox. When
attempting to delete messages, Outlook says "The messaging
interface has returned an unknown error. If the problem
persists, restart Outlook. I continue to get the message
even though I restarted Outlook. My mail works fine, but I
just cannot delete anything. Does someone know a solution?
Can you delete them if you hold shift as you delete? How many items are in
the deleted items folder? Are you using any type of AV scanner on the
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coa...Spelling in new Security Tables in GP v10
There are a significant number of spelling mistakes in the Dynamics SY09000
and SY09100 tables in GP 10.0. These are the new Security Role and Task
Master tables. Please correct these for future releases.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www...Help in Creating Relationships in a table
This is a follow to a previous question concerning relationships in a table.
These are my tables I have in my database.
(ohter info relating to the student)
Category (e.g. School, Community, Individual, Peers, Family)
Issues (text, e.g. lack of role models)
CaseNoID <link to Cases Table>
IssuesID <Link to issues Table>
...Date format wrong when using shortcut key
I use Word 2007. I set the default date format by clicking Date & Time in the
Text section under the Insert tab on the ribbon. I choose the format I want
and click Default. I make sure the “Update automatically” box is not checked.
Then I click OK. The date is inserted in the format I chose and it does not
automatically update. Everything works fine up to this point. My problem
comes when I then try to insert the date using the keyboard shortcut
Alt+Shift+D. According to several Word 2007 discussion groups, when
Alt+Shift+D is used the date should be inserted with the default...