I am trying to find a way to generate a list of numbers (1- 75)in random order (for a Bingo game). I can use the Add In tool 'Random Generated Numbers' but...

I added a drop-down list to my worksheet. I'd like to resize its height so that it fits the height of the cell it's in. I went into the Format Control...

I am running EXCEL 2002 with Crystal Ball. In a project anaylsis simulation, I want to calculate IRR. I use the RATE function, rather than the IRR function,...

I am trying to compare similar text in two columns with a condition. Example ColA ColB ColC ColD ColE Header Acct User ...

Have a data range containing headers on the first row and numbers below. When I create a subtotal, Excel inserts the subtotal() function. The grandtotal line...

For total days =SUMPRODUCT(0+(WEEKDAY(ROW(INDIRECT(A1&":"&A2)),2)={1,3,5,6})) for Mondays =SUMPRODUCT(0+(WEEKDAY(ROW(INDIRECT(A1&":"&A2)),2)=1)) Wednesdays

Russ Did you ever find a solution to the inability to find Report Manager help file XLMAIN8.HPL? GWH ------------------------------------------------

Can you help with a formula for working days left minus holidays before 12/31/2003? Trying to use NETWORKDAYS function but it doesn't seem to work with...

hello, I would be most appreciative of anyone that can assist me with this problem: every time I open up Excel every single worksheet that I've ever created...

Hi , I have this formulae =IF(VLOOKUP($A6,RPD_Switch_Report_20030113! $A$4:$M$1500,12,0)="#N/A","not...

I need to count the cells where the date in the cell is less than 1 year old from the current date. The cells are formatted as a date.

How do I do a conditional format to check to see if any cell in the range A2:A10 has the word "complete" type in. If the word "Complete" is there then the...

Hi There I think this is possible. I am using an If Statement to output text to a cell. i.e "Jamie is leading by __ points." Is it possible to insert a...

hi, i'm using microsoft excel for a class assignment and i can't figure out how to use the Vlookup successfully, i can bring the vlookup window on my screen...

First of all thank you for replying to my e-mail. As per your request I will give you more details on what I want to do. Every day I pass the rates of...

First of all thank you for replying to my e-mail. As per your request I will give you more details on what I want to do. Every day I pass the rates of...

"Kanga" wrote in message ... As part of an assessment I have to create a discount...

hey guys simple question I have a macro I made on my pc, and I'll to have this macro on 20 other pcs. how do I do that? tnx

Hello, is there any function with how i can my send the curent worksheet to a preseverd person - like i make a sheet with a button , when i click the button...

try matching only the 13 characters in both columns, by modifying the original data with the Left (a, 13) command, before the vlookup. -----Original...