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 : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Split text to compare by Manos
Dear all I have a code extracted A1 from the system and looks like. Bill.Eko1 Bill.Eko37 Bill.Eko123 There is any possible way to keep from the code the...
August 26th, 2008 08:55 AM
by Manos Go to last post
3 91
Row header by Wong KM
How to change row header back to left-side of worksheet?
August 26th, 2008 08:42 AM
by Rick Rothstein \(MVP - VB\)[_1194_] Go to last post
4 78
Workbook open event by Pawan
Hi I have written a code in workbook open event. But it works only if I closes excel and reopens the file. If I close that particular workbook (without...
August 26th, 2008 07:32 AM
by Pawan Go to last post
7 109
Rows to Columns by Shazam
I have a spreadsheet that in A2 =NAME, B2 = ADDRESS, C2 = DENTAL, C3 = MEDICAL, C4 = HCRA. I need to place column C to a horizontal range where C3 will be D2...
August 26th, 2008 06:43 AM
by Max Go to last post
3 90
Use of CELL("protect") in conditional formatting in Excel 07 by Mark
I have seen this discussed before but have tried several formulas and have not been able to do what I want to do. It is theoretically very simple: I want to...
August 26th, 2008 06:13 AM
by T. Valko Go to last post
3 65
Lookup question by Aline
I’m having problems this the following formula: =LOOKUP(2,1/(Format!A2:A200=D3),B2:B200) What I want is that only D3 becomes D4, D5, D6... and the rest...
August 26th, 2008 05:40 AM
by Sheeloo Go to last post
3 124
Creating checkable boxes w/o the check box forms tool by crimsontodd
Not sure if this can be done. When you use certain fax cover sheets in the Word templates, there are boxes that can be checked and unchecked with a...
August 26th, 2008 05:38 AM
by crimsontodd Go to last post
0 88
COUNT IF by readystate
I am trying to count values based on 3 sets of criteria. In this case, I am trying to count the number of times the value in column A exceeds 1,000 but only...
August 26th, 2008 05:32 AM
by Sheeloo Go to last post
1 67
duration by Keith_river
Hi there, I want to use excel to calculate duration, but i don't know how to do it. Term to maturity =30 years. Coupon rate=3% Yield to maturity=5% coupon is...
August 26th, 2008 04:46 AM
by Fred Smith[_4_] Go to last post
1 86
NETWORKDAY + Excel 2007 + Excel 2003 by Joe[_22_]
Hi I have the following problem... A workbook created in 2003 Excel version has several cells with formulas. Some cells has the NETWORKDAY function. This...
August 26th, 2008 04:42 AM
by T. Valko Go to last post
1 59
add multiple returns using vlookup by RZ
Hi I am using Vlookup function to find matching datat in another worksheet, i want to add values if there is more than one matching values. -- RZ
August 26th, 2008 03:18 AM
by smartin Go to last post
7 240
Incrementing numbers in cells by Andrew Morine
Hi, I need to perform the following increments within a cell and need to copy to a large amount of cells: =SUM($G7+1) =SUM($G7+2) =SUM($G7+3) etc... etc...
August 26th, 2008 02:11 AM
by Teethless mama Go to last post
1 69
Dividing a list into thirds by Dave
I have a list of handicaps from large to small in B3:B26. In column C I would like to put these numbers into equal thirds. I.E.: B C 9 ...
August 26th, 2008 01:12 AM
by Teethless mama Go to last post
1 67
Sorting a Pivot Table by cware
I have a pivot table that I need to sort the contents of, by the last data column. I've tried help, but am just not able to get there. Does anyone have a...
August 26th, 2008 12:27 AM
by Debra Dalgleish Go to last post
2 70
Averaging Time by BostonBoy
We’re trying to figure our how early an employee typically punches in for work, as we want to give her a bonus. I have the punch clock data in an excel...
(Multi-page thread 1 2)
August 26th, 2008 12:07 AM
by David Biddulph Go to last post
14 124
predetermined answer in next cell by geenie
I have a list of short codes that are equal to a certain Commission Rate Now when this code is entered in a spread sheet the number must automatically apear...
August 25th, 2008 11:40 PM
by Max Go to last post
3 89
Subtract 30 minutes from Formula by Karen
I have a cell that calculates my time with the following formula: =TEXT(C205-B205," \h\r\s: m \m\i\n\s") I want to subtract 30 minutes for lunch. How would I...
August 25th, 2008 11:26 PM
by T. Valko Go to last post
9 89
How to Create % cell and apply changes to worksheet by Daddy Dool
I want to create a cell in my excel sheet which would increase or decrease to entire sheet by the % entered. I want the cell to be available at all times for...
August 25th, 2008 10:57 PM
by Gord Dibben Go to last post
1 99
How do i create formula in words from amounts by Komal
In 1 cell i have amount 3,400.00. how do i create a formula in another cell for amount in words?
August 25th, 2008 10:34 PM
by Tom Hutchins Go to last post
2 82
How to change a date from 19990812 to 08-12-1999? by bcmsmom
Trying to change a date in cells that are downloaded as 19990812 to 08-12-1999? Anybody have a way of doing it? Changing format doesn't work.
August 25th, 2008 10:32 PM
by Rick Rothstein \(MVP - VB\)[_1188_] Go to last post
3 94
Post New Thread


Display Options
Showing threads 21161 to 21180 of 87787
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 12:46 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.