I have theis table
sereial room type Name JoinKey
1 DBL absfcii 1
2 DBL gfgfh 1
3 SNGL kkjjjk 2
4 SNGL sdjfksd 2
The Question Is
How can i count DBL in JoinKey 1 as (ONE) Only
How can I count SNGL in JoinKey 2 as (ONE) Only
This SQL will do it. It assumes that the tablename is tblRooms.
Note that you should not have a field named NAME. Change it to something
I also ...using a date in vlookup
i want to perform a vlookup using the Now() function to generate the
lookup value (A1), the 1st column in the table [col B] array will be
all the dates in a year listed consequtive,, and the 2nd column being
a value assigned to each day in the 1st column [B]. My formula is
vlookup(A1,B1:C367,2). The result I get is "#N/A. What am i doing
NOW() returns both the date and the time, so you would be better off
using TODAY(), which only returns the date.
Another problem might be that your dates in column B are really text
values that just look like dates - see what happe...File Share Witness
Please help me understand something - I think I get the concept of using a
file share witness in CCR, however, I have read that it is suggested that
this server also be a Hub Transport Server. How can this be if a Hub Server
is not cluster aware? Isn't the file share witness server configured to be
part of the cluster?
On Jan 31, 12:25 pm, PM <P...@discussions.microsoft.com> wrote:
> Please help me understand something - I think I get the concept of using a
> file share witness in CCR, however, I have read that it is suggested that
> this server also be a Hub Transpor...Recovery Partition Question
A friend had a system crash and resinstalled windows 7 using the factory
disk. They selected the option to create a recovery partition. All was well
but they were not paying attention after it was created and when they went
to install programs and save programs they saved and installed them on the
recovery partition. It is now almost full. Can he remove or delete files he
does not need ? If so what should remain? Also is there a way to block this
from happening in the future.
...Moving mailbox question
I am moving mailboxes between exchange 5.5 to Exchange 2003. I've noticed
after the move, in Exchange 5.5, the mailbox still exist. Shouldn't the
mailbox be deleted or removed from exchange 5.5?
how, exactly, are you moving them?
Susan Conkey [MVP]
"sean" <email@example.com> wrote in message
>I am moving mailboxes between exchange 5.5 to Exchange 2003. I've noticed
>after the move, in Exchange 5.5, the mailbox still exist. Shouldn't the
>mailbox be deleted or removed from e...CRM3.0 Question on Activity
I am using CRM3.0. I have the following case.
1. Create Campaign
2. Add contact to campaign list
3. Create Campaign activity - Phone call
4. Distribute activity
5. CRM User will make phone call
6. When contact is interest, CRM user will make a "Free Trail" for contact.
I am having troble in step 6.
So far as I know, I have two choices for "Free Trail".
A) Service Activity
If I choose to create a service activity, then I can not link up the service
activity with the campaign or phone call.
If I choose appointment, I can set "regarding"...2 more questions
First of all thanks to all of you who helped me with my workbook.
I have 2 more questions to ask:
1. cell F2 has a SUM formula. I would like the formula to go automatically
to F3 but this ONLY if A3 is not empty and to F4 if A4 is not empty and so
on. Is it possible?
2. at the end of the day all data inserted in Sheet 1 go automatically to a
hidden sheet and is deleted from sheet 1. is it possible to create a macro
or whatever which can restore the SUM formula in F2 etc (as above)?
Thanks again for your help
Try this in F2:
And drag down to...vlookup excel and access...
assuming i have this code, is possible to use this vlookup withnthe
adta into mdb access?...
Private Sub TextBox25_Change()
Dim CODICE As Integer
Select Case Me.TextBox25
Me.TextBox4 = ""
Case 1 To 8
CODICE = Val(Me.TextBox25)
Me.TextBox4 = Application.WorksheetFunction.VLookup _
(CODICE, Worksheets("TABELLA").Range("Q2:R9"), 2, False)
Inested column Q and R in excel i have created a mdb into:
and into this mdb have inserte a table U...Drop Down Question
At one point, I think I read dynamic drop down would be possible with crm
3.0. Is this true? If so, can you link me to some documentation or sample
code in how I can do this? Let me describe what I’m trying to accomplish.
I’m looking to propagate a referrals drop down based on the challenges
records in a custom entity I created. So, the parent drop down would provide
a list of the distinct challenges. When one is selected, it would fill the
referral drop down with all the referrals available with a challenge type of
the parent drop down. Possible?
Thanks for your help!
Could somebody that's a little more into payroll than I am help me out
At the end of the year, does the previous payroll year have to be
closed and the W-2's printed before checks for the next year can be cut?
Microsoft SBF Specialist
8/22/2007 10:26:03 AM
You do not have to print W2s before you process payroll runs in the new year.
You do have to run the routine to create the year end file before you process
W2s or do transactions in the new year. The year end processing articles have
a lot of details on steps.
Ch...Vlookup within a vlookup
I am trying to lookup a cell within a table - but the table to use is found
in another table.
Cell B2 is a dropdown box allowing one of the choices in colum f below.
Column G represents which table to use for the initial lookup based on your
choice in the drop down dox.
column f column g
Alt A 30 Yr fixed30
Alt A 15 Yr fixed15
All I get is an error - can someone help ?
It sounds like you would need to use INDIRECT within the lookup formula
that thread shows the way to do it exce...Lost on Vlookup, match, etc....
Can someone walk me through this please?
I a workbook that imports a years worth of data from filemaker to be
analyzed and charted in excel.
It contains several sheets, but I am concerned with worksheet 1 (daily
data) and worksheet 2 (bodyweight). Daily data contains the raw data I
pull in from Filemaker. It results in a table with a row for each day
of the year. It has 12 columns, but in this instance, I am only
interested in 2 of the colums Column F, (Date), and Column R
(Bodyweight). There is only one entry per week for body weight.
The bodyweight sheet has 3 columns (week #, date, and w...Column width and pasting sections in excel? Formatting questions
I am trying to make a spreadsheet in which I need to have varied column
widths in different sections, one under another. (they don't need to relate
directly, and no major equations going on)
How do I go about splitting the sheet or whatever I need to do so I can
manipulate columns differently based on the row I'm in?
Column widths apply to the whole column.
You may be able to use merged cells to give the appearance that you want, but I
try to stay...VLOOKUP in VBA
On the worksheet I can insert in a cell
=VLOOKUP(C5, Hobokee.xls!AcsLow, 2)
and it works perfectly, looks up the value in column 2 of the range named
AcsLow in the same workbook.
But elswhere I want in a macro to lookup the same table and assign the
result to a variable BalAmt.
BalAmt = VLOOKUP(AccNum, Hobokee.xls!AcsLow, 2) does not work.
It gives a function not defined error on Hobokee. If instead of Hobokee I
put Workbooks("Hobokee"), it gives function not defined error for VLOOKUP
which it changes to VLookup.
I have been overVLOOKUP in the Help file and see nothing wrong.
W...GAL Name Resolution Questions/Tweaking
OK I'm almost ready for our upgrade to Exchange 2003.
When testing here is what I experience.
1) I type in the To field of a new message the name of a distribution list.
When I click on the check names button or hit Alt+K, up displays the name of
the list as well as all the list members asking for a selection. In other
words I type "down", I want the list/group to resolve to Downtown and not
would you like Downtown, Julie, Joe, Amy, George, & Mary.
2) When typing in Mo, in the To field of a new message, it only compares
names in the GAL and excludes the sender'...OWA and SSL question
HI, is it just as safe/secure for users to connect to my
OWA server on Exchange 2003 with a SSL 128bit certificate
issured by my internal CA server than it is by an
external company like Verisign?
In the last exciting episode, "AW"
>HI, is it just as safe/secure for users to connect to my
>OWA server on Exchange 2003 with a SSL 128bit certificate
>issured by my internal CA server than it is by an
>external company like Verisign?
Can your internal CA be trusted? If so, yes.
"AW" <anonymo...VLOOKUP problem
I down a list of top 100 stock symbols to Excel and place them in Column
A and their rank in Column B (1-100). the next week I download a new
list of the top 100 stock symbols and their rank to Column C and D
respectively. then I create column E using the function
=VLOOKUP(C4,A:B,2,FALSE) Which tels me the rank each stock had last week
and if a stock is new this week it puts "#N/A" in the appropriate
cell in column E. How do I get the Vlookup function to put "NEW" in
column E if the is new to the list and wasn't in the list last week?
We are running Win2k3 ent. and Exch 2003 ent with three F/E OWA servers and
four B/E servers. We have two domain trees in a signle AD forest. Can one
(1) of the Backend servers run two (2) "Recipient Update Services", one for
each of the two domains?
On Tue, 8 Mar 2005 22:55:24 -0600, "Clayton Sutton" <firstname.lastname@example.org>
>We are running Win2k3 ent. and Exch 2003 ent with three F/E OWA servers and
>four B/E servers. We have two domain trees in a signle AD forest. Can one
>(1) of the Backend servers run two (2) "Recipient Update ...Email account question
I am new to Outlook having recently switched my email from AOL to Outlook
2003. I have set up a primary and 3 secondary email addresses, but all of the
incoming emails are all going to the same inbox. Don't each of the email
addresses have their own mailbox? It seems odd that everyones emails should
all be coming to the same box. Is this the way Outlook works, or am I doing
something wrong? Have looked all over the "help" section but can find no
answers. Any help would be appreciated. Thanks, RC.
You can use rules or Search Folders to move messages to separate folders.
Would like to post data from one worksheet to another.
Could you provide a few more details about what exactly you want
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"dr" <email@example.com> wrote in message
> Would like to post data from one worksheet to another.
...combobox and vlookups?
I am trying to add a combobox that when you select from the dropdown menu,
the columns nextdoor automatically pull up corresponding data that is related
to the selection from the dropdown list. Does this make sense? What do I do
to set this whole thing up? (I don't know code).
Message posted via http://www.officekb.com
You shouldn't need code for anything you described here. Set up the combobox
with the list fill range, if any. Set the linked cell to the desired cell.
Then, use the VLOOKUP command in another cell to look for the linked cell
from the combo box to lo...Yet another macro question
This is what I get for trying this on my own. I just want a macro that will
insert 2 blank rows at the current cursor position.
' qrow = ActiveCell.Row
Rows(qrow & ":" & grow + 1).Selection.Insert Shift:=xlDown
This should be close...
> This is what I get for trying this on my own. I just want a macro that will
> insert 2 blank rows at the...VLOOKUP
This is a multi-part message in MIME format.
I use the VLOOKUP function to pull basic data from external data sheets,
currently an example of my command looks like this:
=VLOOKUP($A5,'[RT NP 67 MF.xls]ODD'!$A$1:$S$250,$L$1,FALSE)
The "$AA%" is the data I am looking up and the "$L$1" is a variable to
the column I am wishing to insert.
The question I am trying to get an answer for concerns...Was this post helpful to you?
Just curious about the Yes, No selection on the question, "Was this post
helpful to you? "
In a case where I posted a question and received numerous helpful responses,
which collectively provided the final solution, do I select Yes for each
response that was helpful, or just select Yes on the very last post when the
topic has ended?
On Sun, 12 Aug 2007 13:44:01 -0700, Petermgr
>Just curious about the Yes, No selection on the question, "Was this post
>helpful to you? "...Urgent Question
using stacked column chart (Excel 2003), does anyone know how to mak
the total appear at the top of the bars (without using text boxes)?
JKU821's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1658
View this thread: http://www.excelforum.com/showthread.php?threadid=31452
You already asked in the right place which is charting. Pls do NOT