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 Replies Views Reverse Sort Order
Return Numerical Label for LAST value Subtracted to reach Sum Target Value by Sam via OfficeKB.com
Hi All, I am looking for a Formula that can process the following: The Sum Target Value is variable e.g.; 147 I have two columns of numerical values: Column...
(Multi-page thread 1 2)
October 31st, 2005 02:46 PM
by Ron Rosenfeld Go to last post
17 556
Remove border line of a few cells by Raymond
how do I remove the border around a cell? I did it by right-click the cell, then click Format Cells. click the Border tab and I remove the borders by...
June 29th, 2004 06:13 PM
by Bob Phillips Go to last post
1 556
Format cell containing complex number by David
I'm using Excel 97 SR-2. I have a cell (actually lot of them) containing a complex number, for example, "=complex (sqrt(3),pi())". The cell will show "a+bi"...
May 20th, 2004 12:14 AM
by Frank Kabel Go to last post
1 556
Counting styles or formatting by Paula
Is there a formula to count styles in a worksheet? I've assigned cells individual styles based on formatting options, and need to tally them. Thanks!
April 22nd, 2004 09:31 PM
by Paula Go to last post
0 556
importing tabs with leaders from Word into Excel, or creating variable length "dots" in Excel by Chica
I am creating a telephone directory in Excel that has name, followed by dots (leaders) reaching the phone number. Some contain other info also. I am importing...
November 25th, 2003 09:06 PM
by Mark Graesser Go to last post
3 555
auto-formatting weekends with colours & automatically inputing holiday in autoformatted cells by eijaz
hi all, this is my first post to this group. i am working in a mortgage loan servicing call-center as a team leader & handle agents under me. i am trying to...
October 2nd, 2003 08:24 PM
by eijaz Go to last post
6 555
Date Function with literal date does not resolve True by Cam
I have a Data! sheet with a Cell C16 that holds a date (m/d/yy). On another sheet I am trying to determine if the date on Data!C16 is = May 1st 2003. My IF...
April 30th, 2004 04:02 PM
by Cam Go to last post
6 555
Displayed Rows and Columns Excel 2000 by Roy
I import data to a worksheet and want to show only the necessary number of rows and columns - not all 65,536 rows and all 256 columns. Then when I scroll down...
April 14th, 2004 05:11 PM
by Andy B Go to last post
2 555
Pivot Tables compatibility - 97 and 2000 ? by Clarence Crow
Hello One our clever Clients has sent us a very complex Excel 2000 workbook including Pivot Tables. He also has locked it except in a few areas to enable us to...
January 5th, 2004 06:48 PM
by sebastian Go to last post
5 555
data query problem by aaron
Thanks in advance for your help. I am querying a website for some tabular data. This website contains several pages of tabular data in the following...
December 22nd, 2003 01:24 AM
by Go to last post
3 555
Excel 2000 vs Excel 2002 by Harald Staff
"Julie" skrev i melding ... I use Windows 2000 and Excel 2000 at...
April 16th, 2004 11:14 AM
by A.W.J. Ales Go to last post
1 554
Auto Date Conversion Not Requested by Bad Date Mark
When opening a .csv file or pasting in a column of number with the format of "01-5308", Excel autoformats to "Jan-08"...then when converting the format of the...
June 14th, 2004 05:24 PM
by RagDyeR Go to last post
7 554
Display rows based on criteria by Holly
Hello, I have 2 fields that are populated based on user entry: 1- Age 2- Trip length Based on the answer to these questions, I would like for excel to...
June 1st, 2004 09:40 PM
by RagDyer Go to last post
3 554
How to create drop down list having options to the right of cell by Vipul Vashisht
hi i want to create drop down list having options to the right of cell so that i neded not type evey option in the cells below in the column. pls tell me how...
November 15th, 2003 03:12 PM
by Debra Dalgleish Go to last post
5 554
Macro/Formula percentage problem by Frank Kabel
Hi I would suggest you take a look at piot tables for this (group them by week)....
May 26th, 2004 08:10 PM
by DJONES Go to last post
1 553
Problem with formula using an answer of another cell formula by KIMBERLY
IN CELL A11, I HAVE 39,500 IN CELL B11, I HAVE =A11*0.63 WHICH GIVES ME 24,885 IN CELL B11 CORRECT IN CELL C6, I HAVE ...
April 23rd, 2004 08:15 PM
by KIMBERLY Go to last post
4 553
Number days between 2 dates by Kreiss
I'm looking to find a way to tell how many days are between two dates. I found function, "Days 360", but that doesn't give me a true number since it's based...
October 3rd, 2003 01:48 AM
by GB Go to last post
6 553
Range names selected from within a cell by Alan Hines
Hi, hope you can help. I have a number of named ranges across a workbook. In 1 summary sheet I want to be able to enter a range name and then other cells...
July 21st, 2004 02:23 PM
by Frank abel Go to last post
2 553
Problem with changing defined ranges... by BeSmart
Hi all I have a code using defined ranges.... The defined range on a worksheet called "Schedule" will increase/decrease in size based on users...
September 28th, 2004 08:23 AM
by Jamie Collins Go to last post
6 553
multiple arrays in single statement by Alan Beban
I think you've overcomplicated the example, which makes it hard to reproduce; can't you articulate your problem using simply, e.g., =MATCH(JP,iRange,0) and...
November 21st, 2003 01:34 PM
by rudekid Go to last post
2 553
Post New Thread


Display Options
Showing threads 1001 to 1020 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 11:54 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.