|
|
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 19th, 2009 11:58 PM
by TK
|
13 |
499 |
|
|
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 19th, 2009 11:56 PM
by W. Lock
|
0 |
106 |
|
|
|
November 19th, 2009 11:23 PM
by donato11
|
0 |
127 |
|
|
|
|
1 |
134 |
|
|
|
|
2 |
117 |
|
|
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 10:35 PM
by T. Valko
|
1 |
147 |
|
|
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 |
110 |
|
|
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 10:19 PM
by Bob I
|
1 |
119 |
|
|
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 10:16 PM
by Bob I
|
1 |
137 |
|
|
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 |
120 |
|
|
|
November 19th, 2009 09:50 PM
by JLatham
|
1 |
136 |
|
|
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 09:42 PM
by gab1972
|
2 |
148 |
|
|
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 09:36 PM
by april
|
6 |
101 |
|
|
|
|
4 |
125 |
|
|
|
|
3 |
112 |
|
|
|
November 19th, 2009 08:56 PM
by Mike H
|
1 |
99 |
|
|
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 08:44 PM
by Roger
|
0 |
137 |
|
|
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 |
124 |
|
|
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 |
131 |
|
|
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 08:03 PM
by Johnny
|
7 |
135 |