Hi All, Is there any way to put a Vlookup formula with multiple criterias? I've over 45,000 rows in Col 'A' - 'E'. I want G1 to return value of D1, if (E1...

Using Excel 2003. I am copying/pasting data from one excel spreadsheet to another - each have name/address/zip code field. Here's the problem - I have...

How do I get Microsoft Excel to display times on the Formula Bar in 24 hour time with miliseconds? For example, in a spreadsheet cell I have entered a...

I have selected a column, choose Format, Cells, Special, Zip Code, but some of the cells continue to show up in error checking as "text". The spreadsheet is...

I want to color a cell based on the value of that cell being greater than zero and another cell not being equal to "x". I've used conditional formatting with...

I am working in Excel 2003 and need to insert lines sometimes one, two or 3 between rows with data. I am now doing it manually which is very tedious. Is...

I need to use an excel macro to close a word file....any suggestions?

When I want to format a cell or column and I click to highlight it the next two cells or columns to the right get hightlighted as well. I have to use my...

G'day all I have been using Don Guillett's excellent code (copied below) to create a automatic Table of Contents. Is there any way to automatically include...

I'm having a few issues sorting rows in multiple worksheets. I have 6 worksheets with Names in one column and employee numbers in another. I have these...

I have the formula =10/counta(E6:E15 ). This gives me 10/10 if E6 through E15 are filled. How do I make this formula: =10/counta( E6:E15 but exclude the...

I want to divide a number by counta for certain cells (which would yield a number). For example, =10/counta(A1:A4) would equal 10/4 if cells A1 to A4 are...

How do I find if on cells value matches another cells in a range of cells. For example I have data in column G from 2 to 65000 and H from 2 to 65000. I...

I run average time it takes to do tasks. The formula for my end product is =IF(I5="","",N5-I5+(N5I5)). If the time in I5 is 23:40 and my time in N5 is 00:20...

My formatting for dates for next month in my table are suppose to be GREEN, however it does not format those dates GREEN. Does it have to do with the change of...

Can I toggle between sheets in a workbook without having to click them. I'm referring to the "Alt Tab" I can do to switch applications. I was wondering if...

I have 2 columns of numbers. I want to highlight the 4 lowest numbers in the 2 columns. For example, a1=90, a2=100, a3=0, b1=100, b2=100, b3=0, b4=0, b5=0....

I have excel 2007 and run a query out of Oracle. The dates appear as YYYYMMDD and I need for excel to recognize this as a date.

I know how to turn off gridlines for an entire worksheet, but is it possible to turn off for just a portion of a sheet? I am pasting a link into PowerPoint...

I have used Page Break Preview to adjust where the page breaks are in my document. I now want to revert to where they would happen automatically, but can't...