I have a set of numbers in column AG.
0.3411
0.5423
0.3310

I would like to sort an Excel spreadsheet by random columns, keeping the data
in the individual rows together, similar to sorting a table in Access.  Is
this possible in Excel?

I am trying to use the SubTotal function to return number of rows as I
autofilter

Am I able to set my workbook up so that when I enter a certain name say Bob
that an amount ie £50 appears in the next field?

I received a large file with several different sheets.  Is there a way to
save the one sheet to another file without having to save it and remove all
of the extra sheets?

There are 2 worksheets on the same workbook.
Sheet#1 consists of raw data
Sheet#2 consists of a Vlookup for looking up data from Sheet#1
I've added comments on several cells in Sheet#1

Good evening!
Can you PLEASE help me with the formatting of my excel formula?
Basically, I am trying to recalculate my employee’s goals based on their
attendance. Their attendance is measured at 25%,50%, 75% or 100% based.  I am

A simple task that I just can't get to work...
I have a simmple table in which I enter a number in a cell. I then
want to LOOKUP this number and if it matches what I am looking for I
want to return "1" if not  return "0"

I have 2 workbooks, Book 1 and Book 2.
Book 1 has a number in Cell A1. I want to find Book 1 Cell A1 value in a
Cell in Book 2 from a Column (lets say B) of numbers. Once I find that value
I want to return the value of a different cell in that row.

Hi, felow Excel users
I've designed a complex Workbook for calculating costings for a range of
products in a range of sizes, cover materials, optional extras, etc.
To ensure accuracy, I've included validation where a selection criteria is

How do I assign a name to a cell that has the same name in another worksheet?

I need to select multipe cells and change just the reference page for the
selected cells, not the other reference information in the cell.  Find and
Replace does not work. Example, this are four cell, I want to just change the
5 (which is the refence page).

How would we get 2008-01 to read as "Jan-08"?, etc for months and
years.
I'd use a helper column if necessary.  Custom format is better though.
TIA.

I have a very large file, with repeated IP addresses in the same column.  I
need to know how many times the same Ip address is repeated...
like 120.21.18.2 - repeated 630 times
     156.44.90.5 - repeated 1023 times

I have a table that gives me a time. I want to use a lookup table with a
range to give me a specific time in my worksheet (col C). I am getting N/A's
for some numbers. Here is my example:
Eff Time    Time        A    B    C