|
Filtering in XL2003 -- where did filter by blanks go, pls?
There were two features under the filtering pulldowns that we could
assign to columns that would really make life easier. We could filter
by non-blanks and my blanks. Now when I click on the pulldown filter
arrow neither of these appear and nothing I've tried under "Custom"
filtering works.
How do we do this now, filter by non-blank rows so that all empty rows
get hidden temporarily, i.e...
|
6 |
10/22/2008 9:13:01 PM |
|
|
I need a formula
I need a formula that would allow me to copy one cell to another as
well as remove the first three characters.
example
cel a - 12321232 would copy to cell be as - 21232
If anyone could help me that would be soo awesome...
|
2 |
10/22/2008 8:49:49 PM |
|
|
vlookup
Hello to all,
I have the archives excel with 12 sheets with data
and a 13° for the totals.
I have used in 13° the sheet in several columns vlookup+ vlookup+ +vlookup+
............... in order to add the data of the 12 sheets precedence.
The formula has become longest and when I must move or add of the columns in
the sheets precedence the formula need modified manually. It's possible to
...
|
5 |
10/22/2008 8:35:00 PM |
|
|
Enable Combo box based on value in check box and list box....
I am working in Excel 2003
As a part of my worksheet titled "Worksheet" I am trying to enable
Combo boxes based on the value of a check box and the value in a list
box.
There will be a total of 6 combo boxes on the Worksheet. The first
combo box that deals with the body of a book will by default enabled.
The second combo box will be set to appear disabled unless a forms
control check ...
|
1 |
10/22/2008 6:32:16 PM |
|
|
V Lookup using a combo box in Excel 2003
I have a workbook with several sheets.
What I am needing to do is use V Lookup to return the value in the
second column referenced by the foms control combo box. The combo box
references values on a sheet called "Frac" with a cell range of
A1:B31
I am able to link the forms control combo box to return the index
value to the column under the combo box, which is cell G7 on a
worksheet c...
|
1 |
10/22/2008 5:48:31 PM |
|
|
I found the answer to breaking out the job number by account manager.
I used Microsoft query to write specific queries and filtering the
data....
The problem I now have is how do I automatically update those queries
every time I open the job detail list... I can right click on the
cells and click update, but is there an automated way to update these
queries ?...
|
4 |
10/22/2008 5:39:36 PM |
|
|
Job List in one workbook broken down to Account reps in another workbook.
I am wanting to find a way to update between two workbooks, one is a
job number workbook that is constantly updated by 15 different
people, the other is a job detail workbook that I want to track by
account rep.
There are 2 fields that are entered. The job number is an auto
number field which is not manually entered. The two that are are the
job description and the account rep.
This...
|
3 |
10/22/2008 5:38:30 PM |
|
|
Jump to A Sheet
I have a Excel file that contains several worksheets. Can I create a
"homepage" sheet with links to the other sheets?...
|
5 |
10/22/2008 3:33:11 PM |
|
|
Duplicates formula, empty cells
I'm ecstatic to find a solution to my first post this morning - saved
my nonprofit a lot of scarce resources.
Another issue: I'm using a formula to identify duplicate values in
and among several columns in this worksheet of contacts. This is the
formula:
=IF(COUNTIFS(B2:B3,B2,C2:C3,C2)>1,"Dupe","")
Is there a way to keep it from identifying empy cells as duplicates?
(For example,...
|
7 |
10/22/2008 3:17:26 PM |
|
|
Excel 2007 Sort-How to Retain Sort Order
In earlier versions of Excel, if you had a worksheet that you sorted, then
the sort columns and order (ascending/descending) was retained, so that if
you added data and wanted to sort it, you simply told Excel to re-do the same
sort.
But in Excel 2007, the sort instructions are not retained, so that I have to
recreate the entire sort instructions from scratch every time that I need to
...
|
4 |
10/22/2008 2:11:03 PM |
|
|
Lookup Function Help
I need a little help constructing a lookup function. See the table
below:
http://pics.livejournal.com/lonewolf_csu/pic/0002c0bc
I'm trying to get the TRUE/FALSE values in G based on whether or not
the value of F is in the column with the header ($1) that matches the
value in E.
Obviously the example is hard data with no functions.
Thanks in advance for the help.
--
Dave Savitsky
...
|
9 |
10/22/2008 2:07:07 PM |
|
|
copy part of cell contents to another column
I have an Excel sheet in which one of the columns contains e-mail addresses.
I'd like to add a new column that contains the domain portion of the e-mail
address (so basically anything after the @ sign), and keep the original
column in tact.
Is this possible? If so how?
Thanks!!
...
|
2 |
10/22/2008 1:58:01 PM |
|
|
Excel cannot complete this task with available resources
I am getting this error in excel:
Excel cannot complete this task with available resources. Choose less data
or close other applications.
I have Excel 2003 (11.8231.8221) SP3. My computer has 2.0 GB RAM. I closed
all other apps but excel.
The spreadsheet that I have has 19 tabs each with a query to an MS SQL
database. My vb code also does some formating, background color and
gro...
|
1 |
10/22/2008 1:37:58 PM |
|
|
clear dublicate values
Hi all,
I have a datasheet like this:
field1 field2 field3
AA 100 10
AB 100 15
BB 200 10
BA 200 20
I need a vba code to clear one or more of dublicate numbers( just in field2)
and after run it, my datasheet become like this:
field1 field2 field3
AA 100 10
AB 15
BB 200 10
BA 20
any help would be appreciated...
|
2 |
10/22/2008 12:36:45 PM |
|
|
Extract time from date/time column
Is there a way to extract the time from a date/time formatted column so I
can sort the list on the time? I'm using Excel 2007.
The data I'm trying to work with is here
http://www.nuforc.org/webreports/ndxlAZ.html
I want to import this table, extract the time from the date/time column and
then sort on the time column. My goal is to get a list of all events that
occured between 5am t...
|
8 |
10/22/2008 8:17:02 AM |
|
|
conditional formatting criteria
I desire color a cell if in a range exit 0 value.
My cells are in C23:C120 and the 0 value are in AF23:AY120
so
C23 color for ex red if in AF23:AY23 exit one or more cells with value 0
C24 color red if in AF24:AY24 exit one or more cells with value 0
....
C120color red if in AF120:AY120 exit one or more cells with value 0
Is it possible ?
or better
C23 color for ex red if in AF23:AY23...
|
4 |
10/22/2008 1:11:01 AM |
|
|
pasting a block of text into one cell
Hi everybody,
I'm trying to paste a few passages from a book, surrounded by a trim()
command, into a single cell of a worksheet. Since this has multiple lines,
and tabs at the beginning of each line, the paste occurs in multiple rows and
the trim() command doesn't work. Does anyone know how to paste something like
this into one cell?
For clarity, the block is like this:
=trim( "
b...
|
4 |
10/22/2008 12:51:00 AM |
|
|
Vlookup
Problem linking values from one wookbook / sheet to anouther. Almost all
cells work fine but some do not, they do however if I copy/paste the lookup
value into a "search all sheets" and double click the cell in the source
sheet that contains the lookup value.
Example: Look up cell for destination file on sheet1 = 1234
Look up cell from source file on sheet2 = 1234
...
|
7 |
10/21/2008 11:28:02 PM |
|
|
CRAZY WEIRD "SAVE AS" DIALOG GLITCH (PROBLEM) IN OFFICE 2007
This is kind of hard to explain, but I get seemingly random "save as"
dialog pop-ups in many (if not most) of my office programs.
Sometimes it will pop up when I press on my touchpad scroll section,
when I hit various keys, or simply out of nowhere.
I don't think it's a virus or spyware because I get 100% free results
about 98% of the time I scan my system.
Please let me know if you ha...
|
1 |
10/21/2008 11:02:46 PM |
|
|
EXCEL Files open Slow
Why is it that when I open associated files for Office 2007 (.xlsx and
..docx)
that they open SLOW (approx 15 seconds). However, if I have Excel or Word
open and then attempt to open specific files, they open in a snap ? I have
Office 2007, Vista Home Prsmium, a 2.4 Quad Core system, and four gigs of
ram. Can someone please explain this and help me out ?
Thanks.
...
|
9 |
10/21/2008 7:36:57 PM |
|
|
Loop through a range of rows and hide based on conditions
I want to loop through a range. If any data exists on the row in the
range from Column X over to the last column in use, I want to hide the
row.
I also have questions about null and zero values in the cells. Cells
can have either in the row of data. I am hiding zero values but I am
assigning a zero value via a function for some cells.
Thanks in advance for the help....
|
4 |
10/21/2008 7:10:07 PM |
|
|
data validation for range
Hi,
I set data validation based on a range of date where "start date" and
"end date" reference from cell "A1" and "B1" respectively. If data
validation start at G7, meaning date in key at this cell must be of range
between the start date and end date, it is possible to have extra validation
where "end date" have past from the system date and validate failed!
...
|
3 |
10/21/2008 6:58:10 PM |
|
|
Excel Licensing?
I have the Student/Teacher version of Office, licensed for 3 machines.
And it's installed on three machines and all is well with the world.
Almost...
My wife was upset with the performance of Vista on her computer so I
installed XP on it in a dual boot arrangement. So my question is
this. If I install Excel on her XP partition, as well as the Vista,
does Microsoft still count that as one...
|
1 |
10/21/2008 6:30:32 PM |
|
|
Excel 2007 text sorting problem
I apologize in advance for decidedly noob lingo...
In short, Excel is doing a very odd sort of last name/first name
columns in a worksheet containing data from two separate lists.
Here's an example:
Sandra H Bailey
Ward Bailey
B B BAILEY
BARBARA BAILEY
BARBARA BAILEY
DEBBIE BAILEY
ELEANOR BAILEY
ELOISE ...
|
7 |
10/21/2008 5:38:03 PM |
|
|
Customizing Excel 2007
Hi,
I do a lot of date manipulation and would like to add a shortcut Date Format
of DD-Mmm-YY to either the ribbon (under Home in Number drop-down list) or
to the Quick Access toolbar on top of the screen. Any help is appreciated.
Regards,
Schiz
...
|
3 |
10/21/2008 4:55:02 PM |