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

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

Hi Can anyone help me find asymptote from a set of data in two column x and y that show the frequency responce of a say a freq. responce in Excel? Finding it...

I'm trying to get the count of the number of cells that contain a multiple condition using dates. Count the number of instances in cells A1 to A300 which are...

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

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

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

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

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

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

I need an example on writing an IFERROR in Excel 2007. =IFERROR......I have to do this for work and can't find anything on it.

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

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

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

EHi Everybody, excuse the preamble but if I tell you what I'm trying to achieve it might help. I am a pensions adviser and our practice gets involved in a...

I am using Micosoft Excel 2000. My worksheet has contiguous cells that represent a "trade show booth." Most clients take only 1 booth but some will take 2, 3,...