General

vLookup, color as a value
I want to specify a text color as the look up value in the vLookup Formula. Is this possible? Do I need the code of the color? Thanks in advance Regards, Emece.- ... 29 Mar 2010 05:52

vLookup, Look up Value
Hi, I have problems when the look up value in the vLookup formula is a date, and the cell has a differente format. For example, I specify 03/03/10 as the look up value, but the cell has short date format, so the real value in the cell is 03/03/2010. As a result, the formula displays #N/A. How can I solve ... 28 Mar 2010 21:12

SUMIF with NAME RANGE
Really need some help with this one as I am stuck. I am trying to use a drop down box and a name range to get monthly totals and can't figure it out. Here is what I have: 2 Sheets: Monthly Report Sum By Month On both sheets I have Agent IDs in Row $B. On my 'Sum By Month'! sheet I have money earned in col... 28 Mar 2010 20:06

excel sorting
I have a text spreadsheet of 5,000 names and addresses. Column B needs to restricted to only 16 characters in that column. How do I send the records to the bottom of the page (or delete them) that have data that exceeds 16 characters in Column B? ... 28 Mar 2010 19:00

Index / Match / value in a range?
Hi there, I have three colums of data in a worksheet from A1 to C5, example; Column A Column B Column C ABC 5/2/10 02:00 Dog DEF 5/2/10 02:15 Cat ABC 5/2/10 03:47 Mouse GHI 5/2/10 01:20 Bird ABC 5/2/10 00:11 Horse ... 28 Mar 2010 21:12

Track Changes Colour
Hi Can anyone please tell me how I change the colour that track changes displays in in Excel 2003? Mine is currently displaying changes in Navy which is difficult to identify when everything else is black. Thanks ... 28 Mar 2010 17:53

ActiveCell.FormulaR1C1
I need help.... The following statement is being used in a do loop. ActiveCell.FormulaR1C1 = "=IF(" & TagNmeMe & "!R[" & Cnt1 & "]C[-1]="""",""""," & TagNmeMe & "!R[" & Cnt1 & "]C[-1])" What I need it to do is this: if(sheet1!A5="","",sheet1!a5) then 9 rows down paste this: if(sheet2!A5="","",sheet2!a5) ... 28 Mar 2010 17:53

VBA command to move cursor
Is there a VBA command to move the cursor up one row ? Thanks. ... 28 Mar 2010 13:26

Why do I get VLookup error 1004
After defining a new Name ("_year") in my worksheet, I find that my makro code (Private Sub cmdNewEntry744_Click() With NewEntries ..Show End With End Sub) can no longer open my dialog box. I get a runtime error 1004 a message refering to VLookup property of Workbook function class. The name "_year" refers to... 28 Mar 2010 08:59

help to reduce size of my file
I have a large file that somehow has pictures in it that are not visible (they seem to be sized down to 0) but are causeing the file to be too big. When I use the filter function I can select each picture or object and delete it individualy but I what to know if I can "select all" and delete? I know this is ppo... 28 Mar 2010 06:49