|
|
Make a product that works by
msnyc07
Truly you should be ashamed of Excel. I couldn't even BEGIN to itemize or
describe the utter hell of working with this application and the literally
1000s...
( 1 2)
|
February 11th, 2010 02:34 AM
by msnyc07
|
12 |
331 |
|
|
|
|
3 |
130 |
|
|
Drop down box issue by
- pat
Hey all,
I am using excel 2007 on XP Professional SP2. I am using a drop down
box on a worksheet that selects from a column of designated data
elsewhere on...
|
|
2 |
175 |
|
|
Text to Columns by
LeisaA
500+ sentences, I need to seperate (text to columns) after the first "-"
only. There are subsequent "-" but I only want it seperated at the first.
And when...
|
|
4 |
107 |
|
|
Finding duplicates by
Louja
How do I write a formula that looks at two columns and looks for
duplicate values in both, and flags the row if it finds them in?
See below example I would...
|
|
2 |
99 |
|
|
Date format problems after csv import by
YY san.[_2_]
Dear all Excel expert,
I am facing 2 date problems after importing from a sql database via .csv.
This field is a date + time field. Appreciate any help....
|
|
1 |
137 |
|
|
|
|
9 |
152 |
|
|
Array Formula by
Andri
Dear Experts,
Please find the following formula
=LARGE(IF(AND(AC.TR.NMT="X1234"),AC.STATUS=1),AC.DATE,0),1).
how to make the result (AND(AC.TR,NMT =...
|
February 10th, 2010 10:21 PM
by Bernd P
|
3 |
111 |
|
|
Lookup by
Joe
How do I have Excel return multiple values from a lookup in a table of
information? For example, if I have excel do a vlookup or an index/match to
the input...
|
February 10th, 2010 09:38 PM
by Luke M
|
1 |
133 |
|
|
|
February 10th, 2010 09:30 PM
by Flcnmech
|
0 |
105 |
|
|
|
February 10th, 2010 09:28 PM
by ..[_2_]
|
0 |
160 |
|
|
Nested COUNTIF? by
Astro
Currently, I have this worksheet with the following datas:
Items Accepted Date
Apple 1 30-Jan-08
Mango ...
( 1 2)
|
|
15 |
222 |
|
|
|
|
7 |
167 |
|
|
Change How Tab Operates by
RH
Somehow, I've changed how my Tab Operates in Excel. How can I change back to
when I hit Tab, it simply moves over one column?
|
|
2 |
140 |
|
|
|
|
1 |
185 |
|
|
|
|
1 |
119 |
|
|
|
|
2 |
176 |
|
|
|
February 10th, 2010 06:50 PM
by Diane
|
2 |
119 |
|
|
Offset with scrollbar by
H.G. Lamy
Hello,
I'm trying to use a (form control) scrollbar on a worksheet to cycle through
a vertical (column) list of 12 month (January - December).
The length /...
|
February 10th, 2010 06:38 PM
by T. Valko
|
5 |
107 |
|
|
formula to subtract from inventory total by
Dee
Hello,
I would like to set up a spreadsheet where I have a call with a total number
of paqs that I have in inventory. I have a column called Units where I...
|
|
1 |
110 |