|
|
Inserting new row by
Sure
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...
|
|
2 |
147 |
|
|
Conditional formating formula by
Jman
I need a formula in conditional formating.
I am CF'ing column M.
If column J contains blank cells.... format .
|
September 20th, 2008 01:20 AM
by Jman
|
2 |
169 |
|
|
summing times by
j.ruderman
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...
( 1 2)
|
|
11 |
240 |
|
|
|
September 19th, 2008 11:16 PM
by T. Valko
|
6 |
161 |
|
|
|
|
1 |
164 |
|
|
Duplicate Function by
Manni
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
|
|
2 |
126 |
|
|
|
|
1 |
141 |
|
|
|
|
1 |
131 |
|
|
Cursor by
Terry
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...
|
|
1 |
100 |
|
|
Use ROUND to return an average date by
Christy
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...
|
September 19th, 2008 10:31 PM
by NoodNutt
|
6 |
136 |
|
|
Multiple Sumifs by
Emeryville John
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 ...
|
September 19th, 2008 10:12 PM
by JMB
|
1 |
137 |
|
|
Search Formual Error by
Christopher Naveen[_2_]
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...
|
September 19th, 2008 09:43 PM
by T. Valko
|
4 |
121 |
|
|
Return an average date by
Christy
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...
|
September 19th, 2008 09:32 PM
by T. Valko
|
6 |
108 |
|
|
how to roundup by
Trishs
How would I roundup in the following formula? I keep getting a circular
reference.
=E5*(1+10%)
E5 is constant
|
September 19th, 2008 09:32 PM
by NoodNutt
|
3 |
111 |
|
|
Please Help. by
Christy
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...
|
|
1 |
102 |
|
|
Real problem with SumProduct by
Alexey[_2_]
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...
|
|
2 |
115 |
|
|
Help with Functions by
DisFUNCTIONAL
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...
|
September 19th, 2008 09:14 PM
by Christy
|
1 |
123 |
|
|
Sum range if 2 conditions are met by
Dean
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...
|
September 19th, 2008 09:03 PM
by Dean
|
5 |
125 |
|
|
Match or Lookup help please... by
Soth
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...
|
September 19th, 2008 08:58 PM
by Soth
|
2 |
95 |
|
|
Rank Tie by
RaY
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...
|
September 19th, 2008 08:27 PM
by MichaelZ
|
6 |
139 |