|
|
Logical function please by
Amin
Hi i have an inventory table where a column is to remind me of reordering
but my approach is not helping me so i need a help.
i have a column in a...
|
April 16th, 2010 09:44 AM
by Amin
|
3 |
135 |
|
|
Pulling a cell reference--clickable cells? by
Bermie
Hello:
I have a problem to which I'm sure there is a solution, but I haven't been
able to find it yet:
I have a master list of different employees' ratings...
|
|
1 |
177 |
|
|
|
|
1 |
130 |
|
|
Function similar to "LEFT" by
Karen D
I'm trying to separate the last name from the first name in a field. I can
get the first name by using the "left" function. Does anyone know how to get
the...
|
|
2 |
141 |
|
|
copy formula by
Jafferi[_2_]
In Sheet a, i have these info
Employee Number hiring date
122555 apr 5, 2010
152666 apr 4, 2010
123554 apr...
|
|
3 |
213 |
|
|
CONCATENATE by
Tservo
I would LOVE to combine cells from the same column instead of cut & pasting
information. - example D132 through D147 and have this combined information...
|
|
3 |
144 |
|
|
SUM by
Talladega
Hi,
I have a few hundred rows. Each row contains a person information and
amount. There are multiple rows with the same person, but different amount.
I...
|
|
2 |
123 |
|
|
|
|
2 |
230 |
|
|
Conditional Formatting Date Range by
BWR_Rick
Excel 2003
I enter a series of dates in B3:B13 - Cells formatted as dates
I have a mini calendar in Q7:W12- Cells formatted as dates, but only showing
date...
|
|
1 |
152 |
|
|
VLOOKUP returning formula by
Jan Ogg[_2_]
I have a VLOOKUP on one worksheet =VLOOKUP(A1,'Tasks'!A1:C17,2,FALSE) which
refers to looking up the 2nd column of the reference A1 on the sheet that the...
|
|
3 |
167 |
|
|
copy/paste malfunction by
Innovator
I use the copy command to copy a line. The process locks up with a jagged
line around the copied phrase. I waite for 15-20 seconds then it unlocks and
I am...
|
|
0 |
116 |
|
|
VLOOKUP & IF by
Sarah
Hi All,
I am looking to use an if statement with 2 separate vlookups. Is this
possible? Basically what I want to do is if B3=PWRFUT then...
|
|
9 |
172 |
|
|
spreadsheet by
Ben Rivera
I have one spreadsheet with 2 worksheets (A and B). Is there any way to
setup a formula that will copy text input into B from A?
Thanx
|
April 15th, 2010 10:55 PM
by CLR
|
1 |
120 |
|
|
|
|
2 |
135 |
|
|
Can excel data be encrypted? by
Confused
I have Employee numbers that I want to encrypt so the employees cant be
identified. Can this be done in excel and how?
Thank you.
|
|
1 |
167 |
|
|
Standard deviation and bell curve by
Meebers[_4_]
I have a long list (1400) of patient check in's and registration
completion by time formated as 13:30. I am trying to find the standard
deviation and...
|
|
0 |
142 |
|
|
rounded # to correct # by
Wagnerk
I'm dividing two cell (257 by 20)---Excell inserts 12.00. What formula do I
use to get the real number which is 12.85? Please Help!
|
|
4 |
146 |
|
|
|
|
7 |
135 |
|
|
|
|
1 |
133 |
|
|
|
|
1 |
132 |