Lockergnome help - Excel - General Discussions

Excel 2007 Solver Internal Error When Generating Answer Re

Hi all Even i have faced this problem But i found the way to work with it when you hit the solver button to solve it gives us the strange message BLAH BLAH An unexpected internal error occurred or the available memory was exhausted 1 open the excel and save ctrl s your file current document 2 open the solver give the input tgt cell deci var etc 3 hit the solver button

Autofilter Problem

Hi all I have a date column with YYYY MM DD format that Autofilter custom option doesn t work on it the format cell shows the column is date format but it seems is not I tried to change format to text general and even custom but nothing changed and still custom option don t retrieve proper filter any suggestion would be helpful Thanks Bijan

Excel formula

Thanks it worked Dave Peterson wrote: > I d use another column > > With your list starting in x2 headers in X1 then duplicate the headers in y1 > and use a formula like: > > = = x2 > and drag down > > Then use this helper column as the advanced filter criteria range > > sleepless wrote: > > > > I have a list of about 400 last names that I want to use to find in

Excel 2007 crashes on exit

I ve been dealing with this problem for a week I ve almost tried to go back on a 2003 version but I rather decided to find help over the internet However most of the people think that the problem is in one file but it isn t For me Gomer gave us the only solution Bluetooth was a problem So when I got rid of the Bluetooth Add in Excel was working and still working just fine Gomer th

Formula for finding an element

You re welcome Thanks for the feedback Biff Microsoft Excel MVP bim bom wrote in message news:he9jqm aa2 1@news onet pl > T Valko pisze: >> One way >> >> Array entered : >> >> =INDEX C1:C3 MATCH 1 IF A1:A3=5 IF B1:B3=6 1 0 >> >> array formulas need to be entered using the key combination of >> CTRL SHIFT ENTER not just ENTER Hol

Confusion with INDEX MATCH

Assuming lst is in col G and j1 is the cell to match col a =INDEX A:A MATCH J1 G:G 0 col a b =INDEX A:A MATCH J1 G:G 0 INDEX B:B MATCH J1 G:G 0 a macro to make a string Sub getdata mr = Application Match Range j1 Columns G 0 MsgBox mr For i = 1 To 4 msg = msg Cells mr i Next i MsgBox msg End Sub Don Guillett Microsoft MVP Excel SalesA

Median of column I if column A numbers match

>I have a worksheet with 13 000 lines of data If the data is sorted so that the items are grouped together: Item1 Item1 Item1 Item2 Item2 Item2 Item3 Item3 This normally entered formula is much more efficient than an array formula on that much data K2 = some item =MEDIAN INDEX Price MATCH K2 Item 0 :INDEX Price MATCH K2 Item 0 COUNTIF Item K2 1 Where: Price

Link Excel Object in Word to Excel

I have a Word document which contains several embedded Excel objects which is sent to 600 clients The clients complete the data collection in the word document and send back We have a Excel worksheet for each client that uses the data in the embedded Excel objects Is there a way to link or transfer the data in the Excel Object in Word to the appropriate cells in the Excel wo

My pictures appear to be hidden on my Excel spreadsheet

try Sub show For Each p In ActiveSheet Shapes p Visible = True Next End Sub gfraga99 skrev: > I created a spreadsheet with pictures in Excel 2003 My computer has been > upgrade to Excel 2007 Now when I open my spreadsheet the pictures I had > added do not appear I know they are still there because they appear on > Print Preview and the Picture Tools menu appears The

2003 Macro in a 2007 World

The code works for me in 2003 Is the password correct? Is the active sheet a chart? Jon Jon Peltier Peltier Technical Services Inc http: peltiertech com hnyb1 wrote: > My company in its infinite wisdom has decided to upgrade some users to > Microsoft 2007 while leaving the rest of us in 2003 I set up a spreadsheet > with macro in Excel 2003 A user has u

counting based on two dates

With start and end dates in cells c1 and D1 try the below =SUMPRODUCT A2:A10D1 If this post helps click Yes Jacob Skaria AccessNoviceButTrying wrote: > I have two columns which both contains dates I want a count based on > criteria from the dates For example > > Start Date End Date > 01 01 08 12 31 08 > 3 15 07

compare for high with two or more cells and then flag

Select cell D5 and D11 at the same time hold Ctrl to select discontinuous cells With cell D5 being the active cell conditional format formula is: =D5=MAX D 5 D 11 Set a format of red backgroun Ok out Best Regards Luke M Remember to click yes if this post helped you Mario wrote: > Hi Guys; > I have this sheet Mario s and Joe picks i need to flag wh

Open file from Jump List

Excel 2007 Windows 7 When I open an Excel file from the Jump List none of the commands on the ribbon work They are not clickable When I open Excel first then open the file this doesn t happen Has anyone else experienced this? Solution? xcu

How to delete rows automatically with values zero out?

Please TOP post when replying to ME Your FIRST example showed ONLY rows that zeroed out It did not show ANY that had the same number and a different col B Sub delnulifiedrows lr = Cells find What:= After:=[A1] _ SearchDirection:=xlPrevious Row MsgBox lr mc = 1 col A On Error Resume Next For i = lr To 3 Step 1 If Cells i 1 mc = Cells i mc And _ Abs Cells i 1

How do extract cells from hundreds of excel files and put

Lots of unanswered but needed information with this question Generally this can be done relatively easily with a big IF and that IF is whether all of the files you d be examining the employee expense reports have the same format content and layout Get in touch with me via email through remove spaces Help From @ jlatham site com and we can gather some more information an

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.