A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
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....
(Multi-page thread 1 2)
November 20th, 2009 12:58 AM
by TK Go to last post
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 Go to last post
0 89
How to increase the shading when highlighting mult. rows w/ mouse by donato11
In the Excel 2007 (which I've been using for six months and absolutely hate) how can you increase the contrast when highlighting multiple cells on a...
November 20th, 2009 12:23 AM
by donato11 Go to last post
0 110
Analyzing Bank Statements with Pivot Tables by Sleuth
I would like to perform analysis of a several years of bank statements. I wish to be able to identify the main source of deposits and the main recipient of...
November 19th, 2009 11:41 PM
by Fred Smith[_4_] Go to last post
1 117
Paste contents, but keep formula of destination by cynteeuh
Hi, I've searched for a solution for this, but I cannot find it. Apologies if this is a duplicate. I want to copy the values only of a selection to another...
November 19th, 2009 11:38 PM
by Dave Peterson Go to last post
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 Go to last post
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...
November 19th, 2009 11:20 PM
by Don Guillett Go to last post
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 Go to last post
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 Go to last post
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...
November 19th, 2009 11:14 PM
by THIBUS Trévis Go to last post
0 103
How do extract cells from hundreds of excel files and put in one n by Chris D[_2_]
I need to extract expense totals from employee expense reports and put in to one file for import then in to the payroll system fo reimbursement.
November 19th, 2009 10:50 PM
by JLatham Go to last post
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 Go to last post
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 Go to last post
6 101
how do I change the default name of a column from numbers to lett. by mac
my default used to be column a, column b etc, somehow it has been changed to column 1, column 2 etc. how do I change it back? Because of the default change...
November 19th, 2009 10:31 PM
by Peo Sjoblom[_3_] Go to last post
4 108
HOW CAN WE CALCULATE INTEREST ACCURED BETWEEN TWODATES by manas123
Help me please, I want to calculate interest accured between two dates data i have start date (1st jan 2005) End date or maturity date (1st jan 2007) amount...
November 19th, 2009 09:56 PM
by Joe User[_2_] Go to last post
3 95
excel 07, i don't want circular reference arrows every time I open by Zack H
I know i have a circular reference and I am ok with it. In the old version of excel, you could ignore the circular reference, in this version, the program...
November 19th, 2009 09:56 PM
by Mike H Go to last post
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 Go to last post
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...
November 19th, 2009 09:44 PM
by Dana DeLouis[_3_] Go to last post
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...
November 19th, 2009 09:11 PM
by David Biddulph Go to last post
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 Go to last post
7 135
Post New Thread


Display Options
Showing threads 9721 to 9740 of 139764
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:41 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.