Is there anyway to format a column to take data from another column and convert it to all caps? I can get the data from another column but can't seem to get it...

I am trying to use NETWORKDAYS to eliminate Weekends in my calcutions as below A1 Cell contains 6/30/06 B1 Cell contains 7/5/06 using NETWORKDAYS(A1,B1), it...

I'm using a pivottable to addup two columns of figures, Stock and Orders pivotted by department. I want to show the percentage (%) of stock ordered, by...

Is it possible and if so how, to connect two system databases on two servers into one MS query? It's possible in MS Access but I don't know how in MS...

Hi, I currently am using an array formula to match up certain values, if they match, then I pull a Qty value from that row. I want to be able to have one of...

Hi, I need to sum values for a range if two conditions are met. One column is a Status condition which is a simple Spin list ("AP"=Approved, "CP"=Cancelled...

When I highlite a cell, or someone sends me a report with highlighted cells, I can't see them. If I do a print preview, they are there. And they print okay....

I am setting up a spread sheet to use as a time sheet for my son. I have use used the time format in to cells. Next I used the :mm:ss to calculate the...

I want to be able to add the values in a column of cells based on the color formatting of that cell as the criteria. Is there a way to do that with sumif or...

I am only wanting to count the hours between two dates that fall on Monday thru Friday. In other words, I want to always exclude counting hours on...

I want to run an MSQuery on all the spreadsheets on my network drive, to find when they were last modified/accessed! Would it be possible in MSQuery or easier...

It's the old time problem. I want to calculate a persons pick rate. We have Start time, End time and qty picked Times are in dd/mm/yyyy hh:mm:ss format So far...

Pick start time = 20/05/05 06:00:00 Pick endtime = 20/05/05 06:01:15 Order number = 123456 User id = DS123654 Each item picked has its Task...

I am trying to create a master accrued leave workbook. I want an action to take place on the last day of each month. That action is to insert a value of "14".

It's another if question. I have two datetime columns that I want to know if the date in them is older than 11/10/05 or #N/A. Currently I have another column...

Currently I have two seperate MSQueries on seperate sheets, each pull seperate info. The first collects all the stock info and the second collects all the...

Hi, I would like to countIf the conditions of multiple columns exist.. CountIf(A:A,"RS" and the respective row in column "H" = "Sent to" but the same row in...

I would like to count the number of times an item appears in a list but between a set criteria. Two columns, 1 is a date and the other contains text "Major",...

I have three depots each running their own delivery schedule on their system, I can access each system and produce a report detailing all the stores...

Similar to PERMUT, is there a formula that will display or plot out all combinations of specific values? e.g.: 0 0 1 2 3; 0 1 2 3 0; 1 2 3 0 0; ... --...