Some Example's 13

[Wray69]

Don't know if these will actually help anyone or not but here are a couple of files that I made to help out people I work with.

The first one is some working examples of some simple functions such as VLOOKUP's, Different array formula's and some other commonly used functions.

http://home.attbi.com/~wray69/EXAMPLES.xls

The Second is a spread sheet that looks up what time zone US and Canadian Telephone are in.

http://home.attbi.com/~wray69/Area_Codes.xls

Hope these can help someone out.

Regards -

Wray

 

[ladyck3]

WOW, this is FANTASTIC information.... the Area Codes list, where did you get the source data from...the example file ROCKS!!!!

Y'all should check this example file out! GREAT WORK!!

 

[Wray69]

Thank You ladyck3, I cant remember where I got the source data from, I searched on google for it. Been trying to find a data source that is updated that I can link to.

Cheers,

Wray

 

[SF0751]

Great examples; star-worthy!

A good source for up-to-date area codes is the North American Numbering Plan website (

http://www.nanpa.com).

However, as its name implies, it only contains information for North America.

Susan
Under certain circumstances, profanity provides a relief denied even to prayer. - Mark Twain

 

[IFRs]

I must be somewhat dim - I can not see the data on the Area Code worksheet. Where is it?

 

[dawnd3]

Thank you for sharing the worksheet with the different formulas. That can be very useful!!!

Dawn

http://www.calliopeconsulting.net

 

[Wray69]

IFRs,

The data on the area code sheet is on a hidden sheet. The workbook is protected, if you would like to get to the data the password is cameron.

Cheers,

Wray

 

[fredk]

Wray - Good stuff -Much appreciated!

Fred

 

[Wray69]

Thanks Fred,

Im glad people can get use out of it...

Cheers,

Wray

 

[JerrySpringer]

Hi Wray,

I love this area code spreadsheet alot. Its going to assist me in calling my clients so much.

JS

 

[jimbo62]

My gratitude as well....

Thanks,

Jim

Jimbo

 

[Wray69]

I moved states so have a different ISP now, I will get the files reposted soon at a new address.

Cheers,

Wray

 

[ladyck3]

Everyone requesting these files, you will find them zipped and available at the following website:

http://members.fortunecity.com/ladyck/excel/xlsample.htm

Enjoy....

Any comments or concerns should be addressed to the author, Wray69...who now OWES ME <Grin>

 

[smiley0q0]

thanks lady...

i think that deserves a star!

 

[Wray69]

Thanks Ladyck3,

I apreciate you posting those files. Here is a star to show my gratitude....

Cheers,

Wray

 

[Edrondol]

I'd be more appreciative of the link if it hadn't had six pop-ups and attempted to load Gator on my machine.





-Dave

Any dog is just a dog. But if he has you
by the butt he's MR. Dog!

 

[ladyck3]

Well I'm sorry for the link, I put it on a site that I have access to from work...

My apologies to the popups.... I'll see about moving it tonight....

 

[ladyck3]

To those who were perturbed with the popups, I once again profusely apologize... here is a link to my real website, look to the technical resources area in the upper right:

http://home.earthlink.net/~ladyck3/

 

[sawedoff]

The area code lookup isn't infallible. Unless I am looking at the formulas wrong, it looks like the file makes the assumption that all of the US observes Daylight Savings Time, which those of us in Indiana know is not true.

Sawedoff

Give me ambiguity or give me something else.

 

[alsoknownas]

tho nice, it would've been better to have the user type in the City then display the area code...