Functions

Condional Formatting with Percents
I'm trying to conditionally format a row of calculated values displayed at percents with icons such that >0% - green light, < 0% - red light. Any insight would be appreciated. Miki ... 12 Feb 2010 14:37

copying data
Getting errors when copying data from workbook to workbook. Shutdown and restart allows without errors. ... 9 Feb 2010 10:36

Insert Data From Multiple Worksheets Into One (With Criteria)
Ok, I have created a sales report list that tracks what customers we are contacting, how we are contacting them, if they are a new or existing customer and if we sent a quote, along with some other details. There is a worksheet the salesmen fills out for each day of the month (its linked to a calendar) and that... 9 Feb 2010 10:36

Stock control spreadsheet
I thought I had posted this previously but ommited the subject and I don't think it did post. Although I have used Excel for years I have never had the need to use a complicated formula. I am trying to set up a stock control spreadsheet where multiple items are deducted when I click on one cell. What I am tr... 9 Feb 2010 08:23

Stock control formula
Although I have used Excel for years I have never had the need to use a complicated formula. I am trying to set up a stock control spreadsheet where multiple items are deducted when I click on one cell. What I am trying to do is each time I click on cell A3 "Item" all the amounts in C will be deducted from D an... 9 Feb 2010 08:23

duplicate numbers being given different rankings
Have list of percentages which have been sourced from another sheet within an excel document - when i rank these some duplicates are given the same ranking and some are given different rankings eg. 2 results of 6.16% were both ranked 13 while 2 results of 6.11% were ranked 10 & 11 ... 9 Feb 2010 10:36

5th Char in a cell
Hi I know this is simple, and I know I should know it, but I cannot get it to work and I have searched Help and the answers seem more complicated than what I really want. I have a Col that can have a number of codes with varying lengths. What I want to do is extract the 5(Fifth) Char from each Cell. eg A... 9 Feb 2010 00:46

If count
start date end date 01/01/2010 01/01/2010 01/01/2010 01/01/2010 01/01/2010 01/01/2011 01/01/2010 01/01/2010 I want to count the start date column only if there is nothing in the end date column. ... 9 Feb 2010 05:06

Getting a formula to do the following:
Hi there, I need a bit of a hand writing a formula. I have a column of numbers that has duplicates and triplicates in it; I'm trying to concatenate the data conditionally - something like this: if(a2=a3), concatenate(c2:c3, d2:d3 ...) then select and delete row a3. It then needs to apply the same formula, repe... 9 Feb 2010 15:10

retrieve data from different workbook
good day, I have workbook A and workbook B; in workbook A cell C9 has a value (31); in workbook B, there is a worksheet named 31; regardless of the number in the cell, there will always be a worksheet in WorkbookB with the same value (if C9 was 55, there will be a sheet named 55 in WorkbookB, etc.) i... 8 Feb 2010 20:16