Hi! I have a worksheet containing many formulas. This worksheet is locked without any password. Is there a way to see if somebody unlocked the worksheet to...

BeSmart, (I actually knew someone named B. Smart ;-0) Simply make the row lookup parameter dynamic: in this case, replace the 4 with ROW()-Row($BN$10) This...

Hi, The below formula =IF(OR(G23G$45,G23G$46),"",IF(G$480,(G23-G$45)/G$47,(G$46-G23)/G$47)) is used to generate data. If there is only one data in the...

- MAKE EZ AND FAST CASH, NO JOKE, JUS READ!!!!! : MAKE MONEY FAST!!!!!! IT WORKS!!!!!!! : IT'S SIMPLE AND IT'S LEGAL!!!!!!! I found this on : a bulletin board...

I sometimes need to combine data from more than one pivot table, and then do a pivot table on the combined data. Since you don't have the option of having a...

I'm using the VLOOKUP function to return data from a named range which contains several data points (across the row) for several "sites" which are numbered...

Hi there, I've got a list of products for my company but it is listed in product group, the products for that group coming underneath.. like...

I WANT TO PUT MORE THAN SEVEN LEVELS OF FUNCTIONS WITH A FUNCTION. FOR EXAMPLE...

I'm using the VLOOKUP worksheet function and I'm having some issues with the result affecting my other formulas. Instead of the lookup returning "#N/A" when it...

If i understand you correctly try this: Say you want your numbers from A1 to A1000 In A1 input the number 1. In A2 input the number 2. Hilight (select just...

Can you please guide me about calculation of Antilog in the excel sheet. Regards

Hi, Ctrl+ ; inserts current date and Ctrl+Shift+; inserts current ti me Ctrl+Shift+; inserts the current time with the date serial as 0 and not the current...

I feel sorry for you, but you should have noted that your selection was cleared after you pressed Find All button, leaving the whole sheet open for Replace All...

I have a FoxPro application which uses DDE to open a text file in Excel and save it as a spreadsheet. I can open the text file with the OPEN.TXT macro...

Is it possible to convert, say 1234 to one thousand two hundred and thirty four Thanks

Hi, I am interested if there is a way to have a message become visible when the mouse is hovered over a cell. I am currently using 2007. In this problem I...

Hi, Does anyone know how to do this? Example: If F5 contains data, return the content of cell a1 to a cell on another worksheet. If statements don't work...

I have a drop down box on a spreadsheet in a workbook with several spreadsheets. For some reason the contents of the drop down box is beeing bled through to...

I am trying to count the cells in a range that have a certain fill color in Excel 2003. Is there a way to use COUNTIF? If so, how do I write the criteria for...

Please give me a hand. The source code in VB 6 is something looks like as follow: Dim ExcelObj As Excel.Application Set ExcelObj =...