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
Web Query Refersh Interval by Kelvin
Hi I am using Excel 2002 to get a web query, it work fine but the AUTOMATIC REFERESH Interval is min 1 minute. I want set the Interval to 20 seconds, can any...
June 15th, 2004 11:37 AM
by Kelvin Go to last post
2 247
matching a non-blank by JulieD
i need to find the cell in a (single row) range that is not blank and return the cell reference of the cell one row above e.g. a b c ...
(Multi-page thread 1 2)
June 15th, 2004 01:38 PM
by JulieD Go to last post
19 407
Naming a range by Nick Read
I trying to setupa frontpage file that sends data from a form to microsoft excel file. Every time I try to do this I am told that the microsoft excel...
June 15th, 2004 02:02 PM
by Jan Karel Pieterse Go to last post
1 243
Rounding up by Chris
Does anyone know the formula for rounding up to the next quarters. Example 1.66 should round to 1.75, 2.11 should round to 2.25. Thanks
June 15th, 2004 02:18 PM
by Andy B Go to last post
2 239
Excel Query by Lesley
Hello, I have a list of around 50 values of which around 40 of them make up a specific value. Is there a way that I can find which cells make up this...
June 15th, 2004 02:25 PM
by jeff Go to last post
1 222
How can I put these 2 VBA codes Together? by rdvance
Sub ClickFirst() With ActiveSheet.Buttons(Application.Caller).TopLeftCell If .Column 8 Then Cells(.Row - 6, .Column - 8).Select End With End Sub Sub...
June 15th, 2004 03:06 PM
by Chip Pearson Go to last post
1 221
hour sum setup by andy
i am currently trying to write an automated wage sheet for my temporary workers. i have finished the sheets and most of the formulas, however i am stuck. if...
June 15th, 2004 04:05 PM
by Andy B Go to last post
1 225
How to Not Minmize Access Window When I Go to Excel by JB
Hello, I run the same query on a database but with different dates for each run. After each run I key-in the results to an excel spreadsheet. This works fine....
June 15th, 2004 04:10 PM
by JB Go to last post
2 295
generalized macros by vishu
i tried to write a macro for changingthe way the columns are placed on the excel sheet,but i am not able to make it generalized for every sheet is use . Can...
June 15th, 2004 04:27 PM
by Gord Dibben Go to last post
1 248
MIN with a condition by Sarah
I am having no luck writing a formula that will return the MIN value from column B when column A = "Admin". Example data: A B Admin 5 Mktg ...
June 15th, 2004 04:53 PM
by Andy B Go to last post
1 235
align numbers with comma and center within column by AndiB
Thank you both for your assistance. I found that the ???,??0 format worked best for what I needed to accomplish. I really appreciate your taking the time to...
June 15th, 2004 05:18 PM
by AndiB Go to last post
0 313
Auto Sum + Conditional Formatting by BenJAMMIN
I would like to take one cell and have it with the Auto Sum feature. Here's the catch: I have applied a simple Conditional Formatting to a number of cells. The...
June 15th, 2004 05:29 PM
by Andy B Go to last post
6 304
Format will not save! by Fred
Win98SE and WinXP using Excel 2000. I have a CSV file (audit trail from Sage Accts) which will not allow me to change the format in three particular cells. ...
June 15th, 2004 06:02 PM
by Fred Go to last post
2 360
Problem with duplicate entries after sorting by Reems
I have a problem that has stumped me and I was hoping someone could help me out. I have data in rows 2 through 15 with a header row and then blank rows until...
June 15th, 2004 06:08 PM
by Reems Go to last post
1 288
Excel Spreadsheets by Karen Decker
I have several spreadsheets that are in separate files. (I need them to be in separate files.) If I have the same change to all of the spreadsheets, is there...
June 15th, 2004 06:42 PM
by Frank Kabel Go to last post
1 329
Solver query by Damien
I'm trying to use the Solver to solve a problem for me, but even though I've set binary constraints on the changing cells (ie I want them to be 1 or 0), the...
June 15th, 2004 06:49 PM
by Tushar Mehta Go to last post
1 212
replace N/A with blank by leeners82
I need to create a vlookup function where the following occur: 1) the function looks for a number in the worksheet and if that cell is blank the cell with the...
June 15th, 2004 06:54 PM
by Tushar Mehta Go to last post
2 223
Emergency! Sort Issues by Sam
I sorted a list in excel - - ascending. Now, I need it to go back to its original order. I did not save a copy before doing this, ugh! There does not seem...
June 15th, 2004 06:59 PM
by Tushar Mehta Go to last post
3 253
Hyperlink by Nick
Does anyone know why I cant insert a hyperlink in a shared worksheet?
June 15th, 2004 07:12 PM
by Frank Kabel Go to last post
1 246
Save As using contents of Cell in Name by NickMinUK
Can someone help with code that changes the "save As" file name to a combination of the original File Name + the contents of a cell, and saves file in same...
June 15th, 2004 07:14 PM
by Frank Kabel Go to last post
1 227
Post New Thread

Display Options
Showing threads 161 to 180 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 03:51 AM.

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