Lockergnome help - Excel - Worksheet Functions

How to insert the tab name in a cell

Hi You may download and install this addin and then use the sheetname function http: www download com Morefunc 3000 2077_4 10423159 html Regards Ashish Mathur Microsoft Excel MVP www ashishmathur com Kate Bj wrote in message news:E001DBFA D13A 42CC A942 7C5CE58FC9D0@microsoft com > Could anyone please tell how I add the tab na

Too many IFs but what do i use?

Im pretty rubbish when it comes to excel but i have a basic code that was working fine but i need add more IF statements too it but i cant =IF B5=1 Sheet2 B 2 IF B5=2 Sheet2 B 3 IF B5=3 Sheet2 B 4 IF B5=4 Sheet2 B 5 IF B5=5 Sheet2 B 6 IF B5=6 Sheet2 B 7 If anyone can help me it would be great :D Sam

VLOOKUP would begin one row below what the first one found?

Hi Mike Thanks a zillion it worked i did not press crtl shift and enter thanks Regards Leong David wrote: VLOOKUP would begin one row below what the first one found? 21 Nov 09 Hi Mike Thanks a zillion for the suggestion But it did not work got NUM error for the first formula after changing AV to aston villa and over for the second formula which should output

Pivot table

Vinit Yes Just drag the button of interest onto the data area again as many times as needed and set that instance to the desired value count average max min HTH Bernie MS Excel MVP Vinit wrote in message news:BEB75F96 5E79 468A 97A9 E8841111279E@microsoft com > Hi > > Can I use the same value from data range in the pivot tab

How to change amount in figure to amount in words?

function showing amount in wds in excel wksheet Loti wrote: How to change amount in figure to amount in words? 22 Jun 07 I want a formula on how to change translate an amount in figure in a cell to amount in words on the other cell within the excel sheet How do I do this? Like for example: In cell D3 I typed 6000 on cell D4 it should be Six thousand So I would have to typ

format

If desired send your file to my address below I will only look if: 1 You send a copy of this message on an inserted sheet 2 You give me the newsgroup and the subject line 3 You send a clear explanation of what you want 4 You send before after examples and expected results Don Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin rr com

Counting Unique Names

Thank you so much for your help Karen Mike H wrote: > Karen > > For this ARRAY formula to work there must be no blanks in the rrange > > =SUM IF FREQUENCY MATCH F1:F100 F1:F100 0 MATCH F1:F100 F1:F100 0 >0 1 > > This is an array formula which must be entered by pressing CTRL Shift Enter > and not just Enter If you do it correctly then Excel will put curly brackets >

How do I link cells from one excel worksheet to another?

I had to enter to make the information show on target sheet in workbook David Billigmeier wrote: > Type an equals sign in the cell you want the information to end up in click > over to another worksheet and click on the cell you want to reference > Excel will automatically enter it in > > > Regards > Dave > > > stb wrote: > > > I want to link the totals o

Can t solve simple? problem Can some genius out there help

Excel 2007 Added to my previously suggested macro method: Mathur s simple SQL procedure: Modified and illuminated http: www mediafire com file jjwutgjwdhm 11_18_09b xlsm

Find Function behaving differently in different spreadsheets

The FIND function is one of the odd ducks in Excel It seems to have a memory for the advanced parameters that were last used Even when using VBA to execute the FIND any parameters you do not specifically set will use the settings from the last time the search was conducted This means that unless you set some macro to do a default FIND function when you first open Excel no

link values from same cell of 20 worksheets into column on

See this: http: www mrexcel com forum showthread php?t=428957 Biff Microsoft Excel MVP Ashish Mathur wrote in message news:218A5ED7 22F9 4C20 A5F7 A540675A83FC@microsoft com > Hi > > Try this > > 1 Open a new worksheet and name this Summary Position this sheet as the > first sheet > 2 Now create a name Ctrl F3 called sheetname a

How to stop scrolling in side by side comparison?

Luke OP must have something else happening When I use compare side by side I can set the windows to sync or not using the toggle button on the side by side toolbar OP s not sync is not working I don t know why I cannot replicate the behaviour Gord Dibben MS Excel MVP On Wed 18 Nov 2009 13:24:03 0800 Luke M wrote: >I

Multiple If Then Statement based on ranges

Just add another IF test: For a return of blank: =IF ISNA A1 IF For a return of 0: =IF ISNA A1 0 IF Biff Microsoft Excel MVP Julie wrote in message news:E1681425 6769 4DDF A865 E0798C1E98C9@microsoft com > What if A1 is N A and you want it to kick back blank or 0? > > > Teethless mama wrote

i want to set conditional format to cells containing odd n

Hi Click on the first cell say A5 press Alt O D In Excel 2003 select Formula is in the drop down In Excel 2007 press New Rule and select the last rule type In the formula bar type =isodd a5 and then click on the format button to select the desired format Now click on OK > Apply > OK Copy and past the conditional formatting by using the paint brush Regards

Date is displaying 00 Jan 00 when I type in 11 16 09

But I don t think that gives the symptoms whch the OP reported David Biddulph Jan wrote in message news:d913fb74 b2c4 426c 9760 ea8ea049bc35@a31g2000yqn googlegroups com > On Nov 17 7:53 am Clark wrote: > > When I type in a date field in my excel file the date 11 16 09 it is > > displaying 00 Jan 00 instead of 16 Nov 0

How to Handle Remote Tech Support

chris@lockergnome.com (Chris Pirillo) — Mon, 13 Jul 2009 06:30:00 GMT

Using GoToAssist is the easiest way to view and control another person's computer online. Use it to provide instant technical support to family, friends and customers. Start a session with just one click, and instantly connect with the other party.

Network Tools for Windows

chris@lockergnome.com (Chris Pirillo) — Mon, 25 Feb 2008 06:30:00 GMT

You need these network tools, no matter which operating systems and networks you have to support. SolarWinds ipMonitor: Affordable Network Monitoring for SMBs. Get turnkey network, server and application availability monitoring with SolarWinds ipMonitor v9.0. This easy-to-use, reliable solution for SMBs delivers out-of-the-box availability monitoring so you always know exactly what's up with Active Directory, DNS, Exchange, FTP, Web, IMAP, MS SQL Server, and SMTP. Download your free trial today. Or, try their totally free tools! And, through 2/29, save 20% when you purchase ipMonitor 9.0.

Get Your Own Web Site

chris@lockergnome.com (Chris Pirillo) — Mon, 25 Feb 2008 06:30:00 GMT

Starting at just $3.99/month, web hosting from GoDaddy includes 99.9% uptime, 24/7 support and free access to GoDaddy Hosting Connection, THE place to install over 30 FREE applications sure to help you get the most from your hosting plan and Web site. Enter code CP2 at checkout, and save an additional 10% on any order.

Plus, as a friend of Chris Pirillo, enter code CHRIS7, that's C-H-R-I-S and the number 7, when you check out, and save an additional 10% on any order. Get your piece of the internet at GoDaddy.com.

VMware and Parallels for Virtual Machines

chris@lockergnome.com (Chris Pirillo) — Mon, 25 Feb 2008 06:30:00 GMT

It doesn't matter if you're running on Windows or Mac OS X - every power user needs either Parallels or VMware (or both). There's never been an easier way to test software without destroying your primary operating system's stability. Think of how many times you wish you could press a 'reverse' button on your computer. Plus, there's no easier way to try new Linux distributions - see what all the fuss is about. Run Windows in OS X, run Linux in Windows, but the best way to do either is with VMware and/or Parallels.

Coupons for Online Shopping

chris@lockergnome.com (Chris Pirillo) — Sat, 12 Jul 2008 07:56:13 GMT

This feed is fueled by Lockergnome Online Shopping and Coupon Codes

Before you shop next time, see if we have a coupon first.