|
|
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,135 |
|
|
|
|
1 |
1,165 |
|
|
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 |
903 |
|
|
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 |
926 |
|
|
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,246 |
|
|
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,094 |
|
|
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 |
1,002 |
|
|
|
|
1 |
1,059 |
|
|
|
June 4th, 2010 12:55 AM
by Nadine
|
1 |
899 |
|
|
Pivot table in Excel 2007 by
Dinesh
Hi,
Somehow my Pivot table do not sums up by rows.
Boxes are checked for both columns and rows for Grand total under options,
Tools and Filter.
Dinesh
|
|
1 |
1,056 |
|
|
Pre-configuring Pivot table "views" by
Mahurshi Akilla
I need to create several different pivot tables from the same set of
data. However, I need to keep switching between the different tables
and it quickly...
|
|
4 |
1,183 |
|
|
Import external data by
nordiyu
Sir,
I am using MS excel 2003. I try to get data (a1:u17000) from another file
using "Import external data" function. When I refresh data, not all data...
|
June 4th, 2010 09:49 AM
by FSt1
|
6 |
874 |
|
|
SumIf and vlookup formula help by
Nikki
I have 5 categories that I need to sum but it is on another tab. I can't
remember how to use the Sumif and vlookup formula together.
Product A = 100
Product...
|
|
2 |
1,107 |
|
|
lookup function by
Keith[_22_]
I have a column listing numbers in worksheet B. I'm looking for a formula
to place in worksheet A that will list the bottom number listed in that
worksheet...
|
|
4 |
923 |
|
|
|
|
5 |
926 |
|
|
How to give a string of data into different columns by
Elton Law[_2_]
Super expert,
If I have cell containing a series of data like this ....
1,12,9
1,2,9
1,22,17,18
23,23,1,9
24,21,1
1,23,11
|
|
8 |
1,218 |
|
|
Can't Edit Worksheet Comments by
Paul Calcagno
I'm running Vista Home Premium SP2, 2 GB RAM, Firefox, Spyware Doctor, MBAM,
SAS and CCleaner, Office 2007.
All of a sudden only one (of many) worksheets...
|
|
1 |
984 |
|
|
Average If by
carl
Is it possible to compute an average given a criteria.
For example, I have some data like this:
30 Day High30 Day...
|
|
3 |
890 |
|
|
Macro help - add column selection by
HeatherJ
I have the following replace info in a macro.
Selection.Replace What:="Of", Replacement:= _
" of ", LookAt:=xlPart, SearchOrder:=xlByRows, _
...
|
|
1 |
988 |
|
|
MEDIANIF by
rwtrader
Was this function removed from 2007 or do I just need to download an add-in?
|
|
1 |
1,147 |