|
|
How can I paste a unique values list? by
jak roodi
I have a very big list contains a lot of repeated values and I want to get a
copy of the same list BUT only with unique values. For Example the column
Reg.No....
( 1 2)
|
November 20th, 2009 12:58 AM
by TK
|
13 |
495 |
|
|
Double Clicking File by
W. Lock
When a user double clicks an excel input file, if it finds an open workbook,
it adds it to the workbook with the same settings.
Could this be changed so that...
|
November 20th, 2009 12:56 AM
by W. Lock
|
0 |
89 |
|
|
|
November 20th, 2009 12:23 AM
by donato11
|
0 |
110 |
|
|
|
|
1 |
117 |
|
|
|
|
2 |
100 |
|
|
Excel finding top of range by
NassauLIMan
I have a column of numbers. Instead of sorting and manually ID's the highest
and lowest value what is the function in Excel that I can use to have it look...
|
November 19th, 2009 11:35 PM
by T. Valko
|
1 |
130 |
|
|
delete row if 2 cells are empty by
Wanna Learn
Hello I get a daily report and I have to delete the entire row if cell AA
and Cell AB are empty. staring from row 4 till the end. I have been doing
this...
|
|
1 |
93 |
|
|
Pulling Data, References and Flat Files by
GF08
More flat file fun.
Here is what I want to do:
Create a .csv flat file. It has 8 columns and 4 rows.
The columns will always be the same.
The 4 rows...
|
November 19th, 2009 11:19 PM
by Bob I
|
1 |
102 |
|
|
banded columns & ball point pen by
april
just got 07 installed and have been looking at some of the new commands.
when do you use the ball point pen feature? i have typed "ball point Pen"
into...
|
November 19th, 2009 11:16 PM
by Bob I
|
1 |
120 |
|
|
Excel starts very slowly by
THIBUS Trévis
Hi Everybody.
On a Windows XP computer with Office XP, I have this problem since a couple
of days.
When I launch Excel, it starts SOOOOOO slowly (between 1...
|
|
0 |
103 |
|
|
|
November 19th, 2009 10:50 PM
by JLatham
|
1 |
119 |
|
|
SQL statement question by
gab1972
Someone please help with this coding. I'm getting a data mismatch
error.
Dim cn As ADODB.Connection
Dim str As String
Dim sql As String
Dim lRecords As...
|
November 19th, 2009 10:42 PM
by gab1972
|
2 |
131 |
|
|
for each loop by
april
i want to format each row in a spreadsheet that has the word "month" in bold.
i'm able to do it for 1 month but i want to loop through and do the other...
|
November 19th, 2009 10:36 PM
by april
|
6 |
101 |
|
|
|
|
4 |
108 |
|
|
|
|
3 |
95 |
|
|
|
November 19th, 2009 09:56 PM
by Mike H
|
1 |
82 |
|
|
Scroll Through Pivot Table Entries by
Roger
XL 2007
XP
I have a pivot table chart. The chart is setup to show only one entry
at at time. I have with many different entries, 197 total, in the
Report...
|
November 19th, 2009 09:44 PM
by Roger
|
0 |
120 |
|
|
Solver by
Alec Erskine
I am delighted to see that Microsoft have made an important development in
Excel 2007 with their optimiser. You have effectively introduced a
combinatorial...
|
|
3 |
107 |
|
|
Mutiple IF(AND) too many conditions by
rgl2sa
Hi, I may have too many conditions, but I am hoping to achievs the desired
Var% as indicated in column D. The goal is to always get the the 'Var%' to be
the...
|
|
8 |
114 |
|
|
Count in a Cell Reference by
Johnny
I have a count formula in cell A1 that = 25
I would like to be refer to that number in another cell reference.
For example SUM(A1:A?) where the question...
|
November 19th, 2009 09:03 PM
by Johnny
|
7 |
135 |