|
|
|
|
2 |
825 |
|
|
Invisible Column names and Row numbers by
Suresh Lohar
Friends,
I received a work sheet from my friend which has data from a1 to m60.
But surprisingly after the column M, whole letters are invisible and same in...
|
|
2 |
788 |
|
|
how to compare the old code and new code? by
Pradeep_ji78
I have old code and old description in my excel. Now company given me new
code with same description. I want to compare the old code with new code but...
|
|
2 |
745 |
|
|
Count using IF / AND by
RERAA
If cell B3 is between a number range and another cell in same Row =(Z) count.
As cells are populated the count will increase. So the cell must be between
10...
|
|
2 |
961 |
|
|
ranking by
liem
How can I rank the top 5 or 10 items in the category for a location.
Location PSA Category item Day 1 day 2 day 3 day 4 day 5 day 6
1501 ...
|
|
1 |
791 |
|
|
Date inconsistent help please :) by
daisy
Is it possible to clean up a date field where someone was keeping an excel
sheet but the date field is a mess
For example he has
1998
2/2005
1/1/2010
We...
|
May 28th, 2010 08:37 PM
by daisy
|
3 |
889 |
|
|
|
|
4 |
950 |
|
|
Format Date by
Malcolm
Hi, all,
How do I format the date to show May, 2010? The closest I can get is May-10
from the drop down list.
Thanks,
Malcolm
|
|
6 |
805 |
|
|
|
May 28th, 2010 06:45 PM
by Doug
|
20 |
1,900 |
|
|
Convert Week number into Month by
KT
I have a worksheet with values for year and week number. I need to convert
these to the descriptive month name. Some weeks cross month ends, but this
is...
|
|
4 |
944 |
|
|
How do I shorten an IF formula? by
FJM
How do I shorten this formula. It is missing information from the missing
rows, but if I put those in, it tells me "The specified formula cannot be
entered...
|
|
7 |
897 |
|
|
Formula Help by
Nikki
I would like to remove every character up to the "_" and retrieve the name to
the right. Can someone please help me with a formulat that would work for...
|
May 28th, 2010 05:40 PM
by Nikki
|
4 |
709 |
|
|
Pivot Excel 2007 by
Dinesh
Hi,
Somehow my Pivot table is not summing up rows at the end when I have more
than two data field in excel 2007. It does sums up by columns. Does any one...
|
May 28th, 2010 05:02 PM
by Dinesh
|
2 |
965 |
|
|
Thanks Everyone by
ryguy7272
Thanks everyone, for all the help over the course of the past couple years.
This has been an unbelievably rich venue for learning the ins and outs of
Excel....
|
|
0 |
677 |
|
|
Linking to external files by
Mike
I am trying to use and external link that is updated each week based on a
week numbered file as below
=VLOOKUP(E3,'G:\Mike\In progress\Sameday Product...
|
|
1 |
764 |
|
|
IF OR AND in same conditional formula by
Ron
I'm setting up a conditional formula to use in a conditional format, where
depending on a couple of different conditions, the cell with the date entered
will...
|
May 28th, 2010 04:18 PM
by Ron
|
2 |
780 |
|
|
Fill last row down for large selection? by
msnyc07
A few months ago someone posted a great solution for the following problem
which doesn't seem to be working all of a sudden;
I have a column with values...
|
|
1 |
821 |
|
|
|
|
3 |
763 |
|
|
Averaging a column that contains text by
Malcolm
On my worksheet I have a column of12 cells that I need to average.
Unfortunately cell B6 contains text (see below). As shown the dreaded #DIV/0!
displays in...
|
|
4 |
741 |
|
|
some help or direction on using excel by
KC
cutting to the chase. what i'm trying to do is i have a report that i import
from one program to an excel spreadsheet, based on the information in that...
|
|
1 |
746 |