I need to find the formula where there are two dependencies considered to get the result.In V look up from reference of one column the results in the second...

Hello genuine guys, Is the macro function see below here still possible for adjustment so I can use this very good macro, productively, as often as needed...

Hi all, I am trying to find a way to check if a data validated cell contains invalid data. I know I can conditionally format it and that I can set Excel to...

Hello, I've read the link: http://www.contextures.com/xlDataVal05.html over and over, and I am able make a dependent data validation happen for simple...

All, I feel kinda stupid. I can't get this to work. I'm trying to figure out how to get excel to show the differnece in 2 dates. I have gone through the help...

Hi, I've created a workbook that captures the daily work done by my team. I had a similar one before and the new one is more than 11 MB in size. The old one...

When I click the E-mail button in Excel 2003 it opens a blank e-mail, but when I click the "To" button it only shows my contacts and no option to select the...

I posted a message for help yesterday...how do I find it?

I have password protected an Excel Workbook. However, users of this Workbook need to unprotect the Workbook to make changes and then re-protect the...

How can I set the font type and size for all the comments on a whole spreadsheet. Tahoma is set at present and I want to change to a TT font. I know how to...

In Excel how can I set a worksheet so that when entering a comment the font is always the same. I know how to change the font etc in individual comments but...

Hi, In the following data, the negative values are capital calls (outflows) and the positive values are inflows (distributions, income, etc.) The final...

I thought I posted this hours earlier today but it never showed up??? Anyway, I have one column of data with Depts and Names listed below the dept. I need...

I have set up an extensive spreadsheet for my "non-Excel" co-workers. I do not want them inadvertently typing in the cells that have formulas. Other than...

I have a form and when it loads I want it to calculate how many merged cells are in selection. RnSz = Selection.Cells.MergeArea.Count - is what I thought it...

Hi all - Is there a line of vba code that I could put into a startup macro to empty a cell of data. I want to keep the formatting and any cell comments....

How can I change a cell to either "Y" or "N" if the user enters "x". i.e. If the user enters "x" in G12 and presses enter or moves to another cell, that cell,...

Have this function Look up value : A3 Table Array: '01'!Q:S Column Index Number:2 Range Look Up: False Want to copy formula into other column Not change...

When I have alot of data. I filter down to the data I want to see. How can I create a sum total of only the data I have filtered down to?

Hi all, I hve noted there are documented ways to calculate the number of weekdays in any month, but my enquiry is somewhat different. I have 5000 rows, with...