I am trying to create a weekly schedule in excel for approx 22 employees

Hi there, Please help me out with the folliwing query. This is my data which I wish to lookup: Group name 12 Brian 33 Norman 12 ...

Hi all I have a macro which i need to use numbers of times thoughout the year so want to create a button in excel that when clicked plays the macro. The...

The formula in Cell A1 evaluates the values in B1, C1, and D1. B1 can be blank or have numerical values either positive or negative. C1 always has numerical...

I cannot figure it out for the life of me. I have a table with 3 colums: 1) Category of plan (i.e. 1046, 1046-1) 2) Type of plan (med, dent, life) 3) Number of...

I cannot figure out why this formula works in version 2002 SP1 but I get "#value" when I try to use it in version 2003...

I have the following formula on my worksheet =SUMPRODUCT(--(Closed!$B$1:$B$5000="Maxwell R"),--(MONTH(Closed!$W$1:$W$5000)=10)). It works great for cells that...

All, I'm trying to do a sumif. For the criteria I want to sum anything that begins with a value in cell A7. So my formula looks...

hi harlan , i have seen so many questions about vlooku and concatenate function and they suggested to use indirect or use pull funciton created by you, can you...

Is it possible to create a Macro which when activated will move the active cell to the equivalent cell in the same row in a different columns. E.g. If the...

Hi there, I have to calculate the days between two date. But between monday to saturday. The DIAS.LAB function calculate the total days between monday...

I have a column where each cell has values that are separated by a carriage return, and I want to do a Text to Column action delimited by the carriage returns....

Test

See if I got the basic info right.... Col H: Decimal values (0.01,0.02,0.6, etc). Col I: Corresponding column of descriptors (0.05, =0.05) You want to...

I used to have a box in the bottom toolbar of my Excel spreadsheets that automatically summed any cells selected on the worksheet. How do I turn that feature...

Let's say $M3 contains a formula J3/I3 which returns a percentage. I want the row to color if the resulting percentage is over 100%. -- Thank...

I am trying to do some automation of cells and have an IF Function started. As I continue to build this automation, I am wondering if a VBA solution is...

I am using radio buttons (from the control toolbox) for a survey. How do I hide the text "true" and "false" from the properties of the radio button so they do...

I have a worksheet where columns alternate between budgeted and actual income by month (e.g. Col A = January Budget, Col B = January Actual, Col C =...

I have a list of 90,000 12 digit records. I need to count the number of time the fourth and fifth digit are 1, 8 (or 18) and, if possible, filter...