|
|
Large list of numbers to concatenate by
MaggieB.
I have a list of 600+ zip codes that are curently in individual cells. I need
to turn them into one list separated by commas. Is this possible? The best...
|
|
3 |
960 |
|
|
Function to concatenate cells in a range by
Leporello
Does anyone have an elegant way of concatenating a series of cells? I think
the answer will be a user defined function which will be equivalent to...
|
|
2 |
1,039 |
|
|
Determine "on time" status by
Teri
I'm trying to write a formula to determine if a delivery is on time. In the
example below, I used =IF(O6=N6,"Yes","No") and Excel returned "No", but
this...
|
June 3rd, 2010 11:18 PM
by Teri
|
9 |
1,173 |
|
|
Zip Code Last 4 Digit as Zero by
cheppy
I have a Zip Code Table with only the first 5 digits and do not have the last
4 digit.
How can I make them in 9 digit zip code with the last 4 digit as...
|
|
1 |
879 |
|
|
Zeros displaying in cell when using = sign by
watermt
I was moving along very well gathering information form several other
worksheets in my workbook by using the = sign to display text from the
worksheets into...
|
|
2 |
850 |
|
|
|
|
1 |
1,110 |
|
|
Challenging Formula Issue by
Alex
I have been having serious trouble trying to sort this out. It is a little
complicated and I will score major points with my supervisor if I can sort
this...
|
|
1 |
1,083 |
|
|
Function help please. by
Helios150
I am a teacher and have an excel spreadsheet (2003) with student's marks in
various columns. Each column represents a quiz/exam/OP or assignment and they
are...
|
|
1 |
1,105 |
|
|
Simple hack to get $500 to your home. by
money mania
Simple hack to get $500 to your home at http://uslatest.tk
Due to high security risks,i have hidden the cheque link in an
image. in that website on left side...
|
|
0 |
875 |
|
|
difference between two time by
Radhakant Panigrahi
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...
|
|
3 |
1,015 |
|
|
Transpose link by
Ana via OfficeKB.com
Stand in cell A1, enter "=C1"uses the "drag link cell" in the down right
corner of a cell. I will automaticly link
A1 - C1
A2 - C2
A3 - C3 ect
My question is...
|
|
5 |
944 |
|
|
average if - between range by
Chris26
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 ...
|
|
2 |
878 |
|
|
Count "," in a cell by
Elton Law[_2_]
Dear expert,
Is it possible to count "," in a cell please?
I used this ... but does not work
=COUNTIF(FO93,",")
Say below ... can it be solved?
2,5,3
|
|
2 |
840 |
|
|
VLOOKUP returns incorrect data by
burtlake
I am using VLOOKUP to determine addresses from a master list. However I have
found that if the Lookup Value is NOT in the Table Array, I will get
incorrect...
|
|
2 |
885 |
|
|
|
|
3 |
993 |
|
|
IF STATEMENT by
sbain
I have an if statement that says =if(ISBLANK(C3:F3),ROUNDUP(B3,0),b3+.01)
First off, the statement does not seem to evaluate the "roundup" part,
meaning that...
( 1 2)
|
|
19 |
1,606 |
|
|
|
|
3 |
1,221 |
|
|
|
June 3rd, 2010 09:42 AM
by steve
|
21 |
3,832 |
|
|
Should I trust XIRR or Legal & General? by
Ian Jemmett
EHi Everybody, excuse the preamble but if I tell you what I'm trying to
achieve it might help.
I am a pensions adviser and our practice gets involved in a...
|
|
5 |
967 |
|
|
find text string to use in a sumproduct by
MarkN
Hello,
I would like to create a sumproduct function that checks whether column a
contains the letter "M" and then if column f contains the text string "test"...
|
June 3rd, 2010 07:26 AM
by MarkN
|
3 |
776 |