I have several rows of data and want to insert a new row alternatively. Suppose I have 10 rows, I want a row to be inserted so that the 2nd row becomes 3 rd...

I need a formula in conditional formating. I am CF'ing column M. If column J contains blank cells.... format .

I'm tring to create a daily log/time sheet which will have start and stop times in adjecent columns. My problem is there may, or may not, be mutiple shift...

Column A Column B Colum C John John = return value of 1, if matches, else 2 Smith Bob Mary Jennifer I...

I have 4 cells in a work sheet that I have to type or copy information into. This cell always has more than 250 characters. What I wanted to do was set up...

Hi, I have a data below and I want to creat a function to tell me if the number I am working on is a duplicate or not. How do I do this? 1 2 3 4 1

I am using Microsoft Office 2007. How would I add two totals to get a percentage of additional income. I am doing Benefit Statements for a company with 50...

Hi, I have a data I'm working with and I want to create a formula to tell me if the number I am working on is a duplicate in that same data. Can someone...

I work for a large organization that does not allow for me to use "add-ins". I deal with very large spreadsheets and sometimes I can't find the box I was...

Does anyone know how I would alter this using ROUND? Also, when cells in Col H and/or Col E are blank I would like it if the cell that contained this...

Howdy, Here is what my data looks like: Date Zip Code Widgets 1/1/08 10001 1 1/1/08 10002 2 1/1/08 10001 ...

Hi, I am trying search a particular character in a cell and i used "Search" Function. Here is the formual I used but it is returning...

I'm trying to do the following: Col E Col H 9/17/08 in 9/18/08 ti 9/19/08 ot When H13:H36 = in and H13:H36 = ti, Then return the average...

How would I roundup in the following formula? I keep getting a circular reference. =E5*(1+10%) E5 is constant

This is what I'm trying to do..... Col E Col H 9/17/08 in 9/18/08 ti 9/19/08 ot When H13:H36 = in OR H13:H36 = ti, Then return the average...

Hi I am analyising a lot of data. I am using: =SUMPRODUCT(--(TEXT(MISDATA!$G$3:$G$5000,"mmm-yy")=TEXT($A39,"mmm-yy")),--(MISDATA!$H$3:$H$5000="Paul...

I need some help.... If i have a worksheet and i want to pick out anything in column N that has a value of "TR" and then return the value of the data that is...

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...

Hi, I'd like to lookup items in two different column. If item in column A, matches item in column B, then indicate #1, otherwise show #2. I'm not sure how...

My formula keeps returning 1 for every value on the rank list. I'm not sure what i'm missing. I need it to rank the ties but not skip any...