Pages

Search

Excel Help Forum - Excel General: Multiple criteria search between two numbers using VBA

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Multiple criteria search between two numbers using VBA
Hi ! I want to search multiple criteria from sheet2 and sheet3 falling in a range between two numbers and copy-pasting on active sheet1. Herewith I am attaching sample. Can anybody help me? Thank You. Raindrop

Excel Help Forum - Excel General: Matching Two Columns

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Matching Two Columns
Hello, I have two tables that contain data relating to people and I'd like to join those tables together. The name of each person is one of the columns contained in each table, so I'd like to use a VLOOKUP to match the rows appropriately. However, I'm running into a weird problem where even when I...

Excel Help Forum - Excel General: Two decimal places.

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Two decimal places.
Does anybody know if there is a way to format a spreadsheet so that regardless of what is entered onto it, it will be rounded to two decimal places? The gist of this is that a reporting tool I use returns results - excel based, but then need to be paste specialed as values. The result of doing...

Excel Help Forum - Excel General: Need help making four page excel from scanned in form

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Need help making four page excel from scanned in form
Hi I am completely inexperienced here and need someone's guidance please... At work I am wanting to scan in a form we use all the time and then make it an excel so I can type input once and it will make 4 copies w/each speadsheet labelled accordingly. I have scanned it and it was saved as pdf...

Windows 7 - Sorry

Windows 7 - Sorry


Sorry

Posted: 15 Feb 2010 11:11 AM PST

relic wrote: 

and forgotten

Who is Frank the Wank?

Posted: 15 Feb 2010 10:22 AM PST

Alias wrote: 
Who exactly are you trying to fool, fool? You're like a little boy who
when he closes his eyes thinks no one can see him.

You are a known and admitted liar, cheat, and a thief and a bigoted
atheist asshole POS loser who is afraid of me and unable to defend the
honor of his supposed family.
Oops!

Microsoft's new 'phone home' anti-piracy practice unacceptable, sayscritic

Posted: 15 Feb 2010 10:14 AM PST

On 15/02/2010 11:26 AM, Alias wrote: 

If people truly valued security and confidentiality, they would not be
using MS-Windows anything.

who is this lying sack of useless shit cody, aka alias?

Posted: 15 Feb 2010 09:56 AM PST

Frank <cum> wrote in news:4b7995f7$x-privat.org:
 

No. I was just describing the outcome of you 'OOPSing' all over the
place.
 

No. I just saw an opportunity to make fun of you, so I took it.
 

Failed 2nd grade math I see.......OOPS!! LOL!!......Moron.

And I see you *still* have c*m in your e-mail address....OOPS!!!! LOL!!!

(And still in your hair, your bowels, etc.....)

WinXP Pro to Student version Win 7 Ultimate

Posted: 15 Feb 2010 09:11 AM PST

relic wrote: 

Thanks everyone, I'll tell him he can get it ordered :o)


Laptop antitheft software

Posted: 15 Feb 2010 07:04 AM PST


"LSMFT" <com> wrote in message
news:com... 

If I was to steal your notebook, the first thing I would do would see if
there is a factory-installed recovery partition and use it to wipe your hard
drive and bring it back to factory condition. So much for the software.
I believe there are some that have anti-theft devices built into an on-board
chip that would prevent anyone from doing that, but if you ever forget your
password, you have to buy a new motherboard. IBM, maybe?
--
SC Tom

Windows 7 restore point disabled by administrator

Posted: 14 Feb 2010 06:06 PM PST


"Indrek Aavisto" <com> wrote in message
news:com... 

If you're on a Domain, check with your IT department. They have the Power.

look at how cody, aka alias lies...!

Posted: 14 Feb 2010 03:50 PM PST

Alias wrote: 
Who exactly are you trying to fool, fool? You're like a little boy who
when he closes his eyes thinks no one can see him.

You are a known and admitted liar, cheat, and a thief and a bigoted
atheist asshole POS loser who is afraid of me and unable to defend the
honor of his supposed family.
Oops!

Excel IT Pro Discussions Forum: In a formula is there a command to send text to the next line?

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
In a formula is there a command to send text to the next line?

I know how to do this when typing in excel however is there a formula to do this in the formula line?

So if the formula I currently have is:

=IF(ISBLANK('Copy from PLM'!D1),"",IF('Copy from PLM'!D1="1st","123 Easy St         San Diego, CA 99999       888.888.8888   877.888.8888 fax",IF('Copy from PLM'!D1="2nd","789 Easy St          San Diego, CA 99999            888.888.8888   877.888.8888 fax")))

If "1st" is entered in 'Copy from PLM'!D1 then result would be:

123 Easy St
San Diego, CA 99999
888.888.8888   877.888.8888 fax

instead of: 

123 Easy St         San Diego, CA 99999       888.888.8888   877.888.8888 fax


Dustin Shepard

Excel Help Forum - Excel General: Showing the increase in the value of a cell

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Showing the increase in the value of a cell
I have data in cell A1 which is linked to an external source and is constantly updating with a new value, is there a formula or macro I can use to show me the increase in value within another cell, here's an example Cell A1 current value 100 auto updates to 180 after 15 seconds the result I want...

Excel Help Forum - Excel General: How to create a drop down menu/box

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
How to create a drop down menu/box
Hi Please help me in learning how to create a drop down menu/box in a spreadsheet. Thanks

Upgrading Std to Ent Edition - Microsoft Exchange

Upgrading Std to Ent Edition - Microsoft Exchange


Upgrading Std to Ent Edition

Posted: 08 Apr 2004 12:26 PM PDT

Are you talking about the technical installation, or the licensing? I'm
wondering the same thing, with the licensing.. I haven't even installed my
standard yet.. but looks like you have to toss it!

"Matt" <microsoft.com> wrote in message
news:1758501c41d9f$5d5b5a10$gbl... 


E-mail Delay Times

Posted: 08 Apr 2004 05:26 AM PDT

I am also wondering if we are still blacklisted out there
somewhere... Cause if a person replies to an e-mail sent
by someone onsite, we get that one right away. But if the
e-mail is a "new" e-mail sent to us from off site it
delays.




 
and 
the 
timestamps are 
problems 
block list 
listed for 
they could have 
it. They could 

Exch 5.5 - blocking mail with false address

Posted: 08 Apr 2004 04:31 AM PDT

"Robin C" <microsoft.com> wrote:
 

You cannot get exchange 5.5 to do a directory lookup and only accept
mails for matched addresses. For that little gem, you'll need the
current version of Exchange

Mark Arnold MCSA MCSE+M MVP, org
FAQ: http://www.swinc.com/resource/exchange.htm &
http:http://www.swinc.com/resource/e2kfaq.htm

Exchange 2003 8331 Error

Posted: 07 Apr 2004 11:59 PM PDT

As a work around you can reboot the box. This will allow the process to
begin again. It should stay up and running for a while and allow your users
to be stamped by the RUSS.

Definitely call into Microsoft Support to get the fix, however if it is
going to take a while before you can do that you can do the workaround.

--
Hope that helps.

-------------------------
Jaclynn Hiranaka
Enterprise Messaging Support

This posting is provided "AS IS" with no warranties, and confers no rights.
© 2003 Microsoft Corporation. All rights reserved.


"Chris" <com> wrote in message
news:phx.gbl... 
response. 
RUS 
being 



Outlook 2003 Message-ID madness!

Posted: 07 Apr 2004 06:34 PM PDT

No, that's a fine answer. It pointed me in the right direction! Just seems
silly to remove something like that, even if it is technically optional..
how hard is a checkbox to enable/disable it? anyway, just ranting..

Since you posted that, I have been trying to make it work. I confirmed that
sending mail through myrealbox.com (my mail provider) with Outlook 2003
results in no message-id (already knew that!).

I setup the SMTP service on W2K. If I send the same message from outlook to
'localhost', it then relays it on, and in the process it DOES add the
message-id header. So, this could be a good temporary solution.

But, I would want the SMTP service to receive from my clients on port 25 as
usual, then forward the mail to my existing server which is on another port
on the LAN. It would continue to receive from the 'net on the WAN
interface. The 'smarthost' setting seems to work good for this and I can
set another port no problem. I just have to figure out how to make it send
on SSL.. this is because with my current server, I can set the port for SMTP
and SSL SMTP separately, and select which interface each is active on, but I
can't set different ports for one service on two interfaces. :(

Thanks for your help.

"neo [mvp outlook]" <mvps.org> wrote in message
news:phx.gbl... 
to 
anymore. 
MS.. 
an 
it's 
part 
is 
Only 
of 
service 
on 

can't 
get 
message 
got 
are 
compliant - 
2003 
clients? 


Need help to stop relaying on exchange 5.5

Posted: 07 Apr 2004 01:31 PM PDT

Matt,

thanks for replying. I looked at IMS and 'always send notifications when
NDRs are generated' was not selected. We have selected 'multiple matches for
an email address has occurred' . I did google search and it seems your
right. It just so happens I downloaded trial of surfcontrol for web and
email filtering. Problems with spam has kept me from setting up surfcontrol.
Hopefully I'll have surfcontrol setup tmrw.

--will





"Matt" <com> wrote in message
news:1a60501c41d9c$34dfea90$gbl... 


Restore Public Folder

Posted: 07 Apr 2004 11:48 AM PDT

Hi willie:
I am having a simular problem like this. I have a tape back of the Public folder store, and I restored it to the originial place of the exchange server by the "Brightstore backup" from CA. For some reason, the exchange can not mount the public folder store any more. Is there anyway I can get the public folder back? Thanks a lot!

individual mailbox size

Posted: 07 Apr 2004 10:41 AM PDT

Interesting point about Outlook's performance.. a question in that regard..

when using Outlook with Exchange, aren't searches et al. processed on the
server, a-la client-server architecture? So, although it is 'relatively'
slower as the store grows, it should still be faster than an outlook client
with a PST file, right?

Thanks
Jason


"Alex Seigler [MSFT]" <microsoft.com> wrote in message
news:phx.gbl... 
mailbox 
rights. 


Exchange 2003 problem

Posted: 07 Apr 2004 01:25 AM PDT

Many thanks to you both. 
Contact Microsoft 
confers no rights. 
wrote in message 
attributes on new 
System Attendant 
other Exchange 
and confers no 
caught 
info on 
with no 

Upadate described in Microsoft Knowledge Base Article 817809 needed

Posted: 06 Apr 2004 11:10 PM PDT

I've tried to call support (in Russia) and the
conversation was the following:
Support: What is you product and what is the product
number
Me: I'm using trial version of Exchange and interesting
in buying ...
Support: Sorry, since support is not free, we do not
provide it for trial products
 
call in, and since 
calling support and 
know. 
confers no rights. 
specified at 
2003? 
our 
not 

Excel Help Forum - Excel General: How to change a template that is in many files

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
How to change a template that is in many files
Hi I have made a spreadsheet template that I "save as" many times with different names. ie:Sales - Jan , Sales - Feb , etc If I change a cell format in the template , is there a way I can do the same to all the other files without opening each file individually and changing it. Please...

Excel Help Forum - Excel General: Need to look up a name in one column and return a maximum value from the next...

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Need to look up a name in one column and return a maximum value from the next column
I have a list of names of different people in one column. Their names occur more than once in the list. The list is not sorted alphabetically. In the next column are values for amounts they have spent on different occasions. I want a formula that helps me to identify the maximum value they...

Excel IT Pro Discussions Forum: Pivot Tables

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Pivot Tables

I've created a pivot table for one of our clients with a DSN connection back to their ERP data in SQL 2008.  At a high level, the pivot tables are pretty amazing, but I've reached two hurdles that I can't figure out if there is a solution.

We are dealing with payroll check details.  For each check, there is a record for every type of pay an employee receives.  The power is that we can filter to user-specific types of pay for user-specific periods.  My challenges:

  1. Is there any way a user-specified column can be added to a pivot table without breaking the link to the source data?  For example, if we filter to 4 check dates and are displaying hours worked for each pay type as a column with a row total for all pay types, and want to get an average number of hours worked (row total / 4)
  2. Is there a way to filter the data based on a total value?  For example, in the above scenario, where we want to display only employees that worked an average of 30 hours or more per week.

I've noticed the PowerPivot add-on.  Curious if that adds a more dynamic user-friendly front to the pivot table functionality that would allow the above changes.


Cindy

Unable to get Asian IME to show asian characters... - Microsoft Office forums

Unable to get Asian IME to show asian characters... - Microsoft Office forums


Unable to get Asian IME to show asian characters...

Posted: 04 Apr 2004 01:54 AM PST

FINALLY, I got it to work! It looked like I had to add more keyboard
layout/IME options for "Add Input Language" screen. I guess the defaults
additions were not enough because I didn't see all those fancy features
in Language Bar for Chinese language. I don't remember having to add a
lot of options for Windows 2000 with Office 2000.

How come there is no writing option like English with its drawing pad
option? It is greyed out.


On 4/4/2004 2:00 PM PT, CS wrote:
 
--
"I go out of my way to avoid stepping on ants." --Terry McGovern,
daughter of Senator George and Eleanor McGovern, subject of the book
"Terry by her father"
/\___/\
/ /\ /\ \ Phillip Pi (Ant); The Ant Farm: http://antfarm.ma.cx
| |o o| | E-mail: netANT or com
\ _ / Remove ANT if replying by e-mail from a newsgroup.
( )

Frontpage2000 & office2003 ??

Posted: 03 Apr 2004 12:22 PM PST

DL wrote: 

Thanks........I wasn't sure if it would cause any problems by doing that.


Upgrading Off2K to Off2K3 sometimes requires Off2K CD's

Posted: 02 Apr 2004 05:41 PM PST

We're using the Enterprise Pro version of Off2003, so, Publisher IS in
there, but, FrontPage isn't ,but, I am using a link to install it, as well
as OneNote at the same time as the main suite.

Maybe that's it, though, although ALL our machines have FrontPage, so, I'd
think it'd happen all the time...

Thanks!
"Milly Staples [MVP - Outlook]" <org>
wrote in message news:phx.gbl... 
in 
asked: 


I installed SP3, I have an activated product, but I can't find my install CDs

Posted: 02 Apr 2004 01:14 PM PST

But, this is why I activated it! Doesn't that guarantee uniqueness,
and that I've paid full price? Don't they want me to install their
frequent security patches? Why make it hard?
Pah!
ion

customizing office 2003 Pro... removing update ability

Posted: 02 Apr 2004 12:37 PM PST

Thanks for the reply....I've looked through policy
settings are can't seem to lock down where I'd make this
modification.....if you have any pointeres, that would be
great. Thanks

 
Office. Likewise  
policies as well. 
intact. Due to 
to my personal 
sam asked: 
i'm 
help..thanks  

Office XP License Transfer

Posted: 02 Apr 2004 10:21 AM PST

Do NOT post attachments to this group. If this is an actual Microsoft
Patch, then post the URL so folks can read about what it does and decide if
they want to install it.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.

After searching google.groups.com and finding no answer, C Gregory asked:

| Just apply this official MS patch.
|
|
|
| Bob Woolston wrote:
|
|| I would like to know how to transfer my Office XP from my
|| old compter (Win2K SP4) to my new computer (Win XP Pro SP1).
|| Thank You


Office 2003 GPO worksheet

Posted: 02 Apr 2004 08:12 AM PST

Yes

"Milly Staples [MVP - Outlook]" <org>
wrote in message news:phx.gbl... 


MS Office 2003

Posted: 02 Apr 2004 05:37 AM PST

Thanks Milly Staples that makes sense to me so I will
leave it alone
Have a good one 
included with Office  
did not remove  
intact. Due to 
to my personal 
Ralph asked: 
mgs  

registration / activation

Posted: 01 Apr 2004 10:49 PM PST

Ah, the piracy accident :) ! Sort of an accident on purpose....


"C Gregory" <com> wrote in message
news:com... 


Normal File

Posted: 01 Apr 2004 06:13 PM PST

Thank you. It solved my problem
"Ian Baird" <microsoft.com> wrote in message
news:phx.gbl... 
http://service1.symantec.com/SUPPORT/nav.nsf/b69c799adfa31ecc85256aa30052f4d 
3fa476a20285256ad3007d8cf1?OpenDocument&prod=&ver= &src=sg&pcode=&svy=&csm=no 
cpmsftngxa06.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTN GXA05.phx.gbl!TK2MSFTNGP08 
phx.gbl!newsfeed00.sul.t-online.de!t-online.de!newsfeed.wirehub.nl!news2.eu 
ro.net!62.253.162.219.MISMATCH!newsrout1.ntli.net! news.ntli.net!sn-xit-02!sn 

the 


Office 2003 issue

Posted: 01 Apr 2004 12:22 PM PST

The side-by-side scenario with the Assistant is fairly buggy (we're looking
into it).

You might find that turning off the Office Assistant in both XP and 2003
reduces the incidence of problems.

Sorry for the trouble.

Eric Lawrence
Program Manager
Assistance and Worldwide Services

This posting is provided "AS IS" with no warranties, and confers no rights.


"Alys" <com> wrote in message
news:google.com... 


Office XP vs Office 2003

Posted: 31 Mar 2004 04:33 PM PST

Windows 2000 is no longer shipped either. Once Microsoft comes out with a
new version of a product, they stop production on previous versions.
Windows XP is still shipping in the Home and Professional versions and
Windows 2003 server is also shipping.

Companies that purchase new equipment but have standardized on older
versions perform what is called a downgrade of the license to allow them to
run Windows 2000 and Office 2000/XP. Very few companies downgrade to Office
97 as it is now unsupported by Microsoft.


--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.

After searching google.groups.com and finding no answer, dt asked:

| Milly, I appreciate this may be not the correct group for this one but
| similarly what is Microsofts stance on the continued production of
| Windows 2000 & Windows XP clients?
|
| Dave
|
| "Milly Staples [MVP - Outlook]"
| <org> wrote in message
| news:eqeAd$phx.gbl...
|| They no longer produce Office XP. They only produce Office 2003.
|| Any availability of Office XP is due to warehoused stock. Microsoft
|| does not ship Office XP since last year when Office 2003 was
|| released.


Excel Help Forum - Excel General: INDEX+MATCH with multiple criteria across both rows and columns

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
INDEX+MATCH with multiple criteria across both rows and columns
Hi everyone, I have a spreadsheet where I'd to match four criteria (on a single row), against one column criteria (the year). This wouldn't be a problem if the data was arranged in the usual fashion where every criteria including the year is it's own column. As I'm dealing with a large...

Excel Help Forum - Excel General: using defined array names from a cell containing text of just the array name

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
using defined array names from a cell containing text of just the array name
hi i was wondering if there was a way to use cells containing just text of the name of an array (previously defined by me) as the array to look in, within a vlookup? ex. array name = cats_1 text within A1= cats_1

Excel IT Pro Discussions Forum: File Slow to open and Changes to cells are slow

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
File Slow to open and Changes to cells are slow

We use an Excel file that takes 9 seconds to make a change to a cell.  Also takes several minutes to open....using Windows XP; Office 2007  latest patches

No Impact from the following

So far, I've got to FILE Types and changed xls and xlsx files to NO DDE and added back "%1" the end of the command line.  When I check the type again....DDE is checked again....so not sure what is happening there

start Excel in Safe Mode     start ; run excel /safe


carl

Excel Help Forum - Excel Charting & Pivots: Software for FAST plotting charts from dynamic excel data?

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Software for FAST plotting charts from dynamic excel data?
Hi! I am looking for a software that can take dynamically updating data in excel worksheet every second and plot graphs from it. Here is my working conditions: 1. Data supplied from the monitoring instruments is updated dynamically for about 300 (unique IDs) x5 (5 criteria for of the 300...

Excel Help Forum - Excel General: Your expert help needed please...

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Your expert help needed please...
Hi I really need your help! I have an excel document containing contact information for businesses including web addresses. I have been working on the sheet and now when I try to work on it I get a pop up dialogue box, windows log in; please enter log in credentials for truffaut.com ...

Excel Help Forum - Excel General: Matching a cell against a pre-defined table and returning an adjacent cell as...

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Matching a cell against a pre-defined table and returning an adjacent cell as a result
Hi, Apologies in advance as i am sure the answer to my problem is on here already but i have tried a search and cannot find it. See spreadsheet attached. In column C, i have a list of countries in random order. In Columns A and B, i have an alphabetical list of countries and country codes...

Excel Help Forum - Excel General: Transfering formulas from one worksheet to another???

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Transfering formulas from one worksheet to another???
I have created a large set of forumlas in a a worksheet. They were created right next to the set of data that I was using for my formulas so that I could refrence it. Now that my set of formulas is quite large, I want to MOVE them to a seperate worksheet so that I can set it up nicely for printing,...