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

How do you add an asterisk to the begining of a excel cell? or replace the zeros with a asterisk? For example, data come in the cell as 01222 but I want it...

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

Hello, I have an Excel sheet which has macro's written as well as Calendar control used. This sheet was developed in Excel 97 (windows 98) environment. It...

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

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

In order to count the number of unique entries in a range of cells, a very complicated nested set of functions (SUM, IF, FREQUENCY, MATCH, LEN, etc.)...

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

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

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

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

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

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

I am trying to count the number of cells in column B="large" when the condition in column A="week1". I tried the formula below and it counted all the...