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 Replies Reverse Sort Order Views
Rounding numbers up or down by Michelle
Is there a function (or other method) that we can use to round currency to the nearest 5 cents, ie $27.28 would round up to $27.30, and $30.01 would round to...
(Multi-page thread 1 2 3)
April 8th, 2009 03:03 PM
by Jose Go to last post
24 380
How can I open 2 excel files in two excel windows -using multi mon by Mr. Analogy
I've got a 3 monitor setup and I'd like to look at two excel spreadsheets in two instances of excel, each maximized to one monitor. But when I open multiple...
(Multi-page thread 1 2 3)
February 24th, 2010 12:08 PM
by george roberts Go to last post
24 444
Formula vs. Constant by rk0909
Is there a way using excel funtions (not UDF) to find if a cell contains a formula vs. a number (constant). I looked around the forum but did not find...
(Multi-page thread 1 2 3)
January 14th, 2010 07:34 PM
by rk0909 Go to last post
24 391
Highlighting by gwenturpin
:confused: I am wanting to change the default highlighting when you hover over a cell/row. E.g. I will be working on a large list of contact details when...
(Multi-page thread 1 2 3)
June 16th, 2005 04:28 PM
by Bob Phillips Go to last post
23 639
Simple Formula by Canon
Excel 2009 I am looking for a formula that will do the following; If cell A1 in workbook one = Brent, then cell B1 must equal the amount in cell A1 of...
(Multi-page thread 1 2 3)
November 16th, 2009 05:47 PM
by Dave Peterson Go to last post
23 591
File integrity checking? by bogstick
I like to routinely check my documents against backups by comparing MD5 signatures. However, I find this impossible with Excel files because the MD5 value...
(Multi-page thread 1 2 3)
October 1st, 2009 06:32 PM
by Bob I Go to last post
23 297
Find Last Saturday of the Year by jlclyde
I am trying to find the last Saturday of the year with excel. There are a few sites that I visited, but they specify weekdays and I want saturday. Thanks, Jay
(Multi-page thread 1 2 3)
March 18th, 2008 02:14 PM
by jlclyde Go to last post
23 323
separating alpha numeric vlue by Narasimha
Hi all, how do separate alpha numeric value for example I have values like ABC123,AB234 starts with alpha but the length may be 2 or 3 or 4. just I want alpha...
(Multi-page thread 1 2 3)
December 9th, 2007 07:25 PM
by Rick Rothstein \(MVP - VB\) Go to last post
23 206
How to trim a string to the last "." by VCKW
I have 11,000 long text strings in Excel... I had used LEFT operation to limit the strings to 500 charaters, now I need to trim the strings to the last...
(Multi-page thread 1 2 3)
November 28th, 2007 09:36 PM
by Rick Rothstein \(MVP - VB\) Go to last post
23 140
Linking to Password Protect Workbooks by Paul Ferris
Hi Guys I have a summary workbook, that links to several password protected workbooks. Currently when I open the summary workbook, it prompts me for the...
(Multi-page thread 1 2 3)
November 3rd, 2007 02:30 PM
by Dave Peterson Go to last post
23 184
Calculating days in a month by STFC
Hello, Hope someone can help. A1 = Start date B1=End Date eg A1 = 1st Jan B1=4th April C1=Days in Jan D1=Days in Feb E1=Days in Mar etc until...
(Multi-page thread 1 2 3)
January 26th, 2005 06:58 PM
by Myrna Larson Go to last post
23 237
Problem by damanwitdaplan
I have a scoresheet I am trying to compile for someone. I ran it through like it was a real time match and these are the results. This is what I have right...
(Multi-page thread 1 2 3)
March 27th, 2007 08:28 PM
by Sandy Mann Go to last post
23 164
Macros to delete check boxes by GWB Direct
I need to find a way to delete the check mark within a checkbox button so the customer can clear chcked items. I tried a macro but it will not uncheck the box....
(Multi-page thread 1 2 3)
June 3rd, 2005 09:56 PM
by Dave Peterson Go to last post
23 435
Index Match Vlookup? by IntricateFool
How would I go about having a function return a single value from searching several different columns and matching the proper "name" with its "county"? Here...
(Multi-page thread 1 2 3)
October 3rd, 2006 10:39 PM
by PapaDos Go to last post
23 283
How do you auto-number a large list of rows in Excel? by Birdieguy
Without having to type each number from 1 to, say, 300, and hit the down arrow or enter in between each, isn't there a command in Excel that will...
(Multi-page thread 1 2 3)
May 25th, 2009 10:56 PM
by redgoose Go to last post
23 332
VlookUP Multiple tables by joeldsmt
Hello, I dont have a clue what to do and any assistance would be greatly appreciated. Here is what i want to do: I presently have a worksheet that has for...
(Multi-page thread 1 2 3)
July 19th, 2006 02:46 AM
by Max Go to last post
23 212
formula to convert decimal feet to feet inch sixteenths by tv
I would like to write a formula in excel, without using macros, to convert decimal feet to feet-inch-sixteenths. Can someone help me ?
(Multi-page thread 1 2 3)
February 20th, 2008 11:58 PM
by Gord Dibben Go to last post
23 323
How do i do this? by R.P.McMurphy
Im trying to set up a holiday accrual worksheet for my employees, so that i can tell at a glance how much holiday they have left. basicaly, employees acrue...
(Multi-page thread 1 2 3)
August 25th, 2005 09:28 PM
by R.P.McMurphy Go to last post
23 209
Extract Unique Values, Then Extract Again to Remove Suffixes by Karl Burrows
I have a list of builders where I want to extract all the unique values. Using =IF(COUNTIF($A$1:A1,A1)=1,A!,"") works fine to get the first set of unique...
(Multi-page thread 1 2 3)
June 25th, 2005 10:37 PM
by Harlan Grove Go to last post
23 599
Dates by Ms. Beasley
I'm trying to do a worksheet that will autotmatically enter "today's date" in a field but will not update when the spreadsheet is opened tomorrow. Can...
(Multi-page thread 1 2 3)
May 16th, 2008 01:49 AM
by Gord Dibben Go to last post
23 232
Post New Thread


Display Options
Showing threads 81 to 100 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 02:12 AM.


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