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...

Hi, i have the times in 12:00 PM in cel A1 and 9:30 AM in B1 and i just want to calculate the difference between B1-A1 which is -2.30 hrs, but in excel it is...

Since indirect won't work with closed files, couldn't u use indirect to make the reference and then just copy/paste special values? -- Don Guillett SalesAid...

- 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'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...

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

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

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...

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...

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 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...

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...

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...

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

To those, if any, who use the array functions in the freely downloadable file at http://home.pacbell.net/beban: I refreshed the file yesterday with changes I...

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

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...