Functions

absolute reference fill
i have 235 lines each linking to a cell in another tab. I need to make each cell an absolute reference so i can copy them down again below and the same cell is referenced. How to I insert Absolute Reference in multiple cells. (i've tried macro's but i failed). Thanks in Advance ... 2 Jun 2010 14:17

concatenate will not paste special
Hi I am trying to concatenate first name and last name columns, all is good till I copy and paste special.....It say copy and paste area is not the same size...and it is. Here is the real dilemma, when I copy and past the data into a new spread sheet and concatenate it works, except in certain records it drops... 2 Jun 2010 13:10

Formula Help
I need a formula (will be in L2) to do the following-- IF G2 contains the text "bail" then L2 should be the contents of cells B2 G2 H2 separated by commas. If G2 does not contain the text "bail" then I want L2 to remain blank. Any help would be appreciated. Thanks! Heather ... 2 Jun 2010 13:10

extracting sheets on the basis of Row character
Hi, I have the below data...i have only shown the st column but i have the data in 15 coulmns. Like this i have 20 sheets... and i need a separate sheets for the name that are contained in column A ie separate sheet for "Mark" where it will extract the data from 20 sheets where there is row with name mark... ... 2 Jun 2010 12:03

difference between two time
Hi, i have the times in 12:00 PM in cel A1 and 9:30 AM in B1 and i just want to calculate the difference between B1-A1 which is -2.30 hrs, but in excel it is not coming only A1-B1 is coming which is +ve 2.30 hrs can anybody help me. regards, radha ... 3 Jun 2010 08:57

Alternate Rounding Up & Down of .50 in a column
Hello, I haven't had any success in trying to do the following: I have a column of hours - all with .50 (such as 8.50, 7.50, 1.50, etc.) I am trying to program a routine to go down the column cell by cell and alternately round the first cell up to the nearest whole number, round the second cell down to the... 2 Jun 2010 12:03

Counting Occurrence of a Value within Cells
I have a user who is using Excel as a database – ugh. One of their columns (fields) has contact data points. As an example, a cell might state – “05/10/2009 – Called person. 05/24/2009 – Sent letter. 06/30/2009 – Received call from person. 07/31/2009 – Closed case. 01/10/2010 – Reopened case. 01/24/2010 – Sent ... 2 Jun 2010 17:37

Counting cells with conditional formatting
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 the color I'm looking for? Or, is there another formula? Many thanks to whomever can answer this one! ... 3 Jun 2010 07:51

Index Match Inconsistencies
hi all, I am trying to use Index Match formula on 2 spreadsheets. There is 2 text fields and a date field which I need to match b/w the s/s. Problem 1: when I try to match on the 2 text fields, I dont have a problem. Once I add in the date field, I don't get any results. Problem 2: When I try to match on 2 ... 2 Jun 2010 10:56

average if - between range
Hi I have the following data Col-A Col-B 1/10/2009 10:20 0.006 1/10/2009 10:22 0.007 1/10/2009 10:24 0.006 ........ 1/06/2010 15:00 0.015 etc What I would like to be able to do, is to calculate the average of the vaules in Col B... 3 Jun 2010 07:51