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
What is the quickest method to insert & name multiple worksheets . by clyonesse
Need to create several spreadsheets ... each containing multiple worksheets .... Example: Monthly spreadsheets containing a separate worksheet for each day of...
September 20th, 2005 10:55 PM
by Gord Dibben Go to last post
8 1,296
date conversion by web_time
Is there an easy way to build a two-column table with gregorian dates in one column and Hebrew dates in the other? And then for each year, have it...
(Multi-page thread 1 2)
December 25th, 2003 07:51 PM
by Ron Rosenfeld Go to last post
10 1,292
How to remove a suffix in excel by BC
type I have the following example data in cells and need to separate the suffix. Adelphi Blue7 The suffix may be alpha or numerical but in all cases there is...
February 13th, 2006 11:41 AM
by BC Go to last post
3 1,287
VLOOKUP WITH ALPHA NUMERIC by JACOB
i HAVE ALOOK UP RANGE THAT HAS IN THE 1ST COLUMN NUMBERS & OR NUMBERS & LETTERS THE vLOOK UP ONLY GIVES ME THE NUMBERS IT GIVE n?A ON THE ALPHA OR ALPHA...
(Multi-page thread 1 2)
June 16th, 2005 04:10 PM
by VG Go to last post
14 1,274
Return SEARCHED Column Number of Numeric Label and Value by Sam via OfficeKB.com
Hi All, I would like a flexible Formula to Return the Column Number of individual Numeric Labels and their Numeric Value. I have a 2-Row by many...
(Multi-page thread 1 2 3)
January 30th, 2006 07:16 PM
by Sam via OfficeKB.com Go to last post
23 1,272
GET.CELL by Biff
Hi Folks! Anyone know where I can find info on the argument values for GET.CELL? I saw a post a couple of wks ago that had a link for a help file from MS but...
November 24th, 2004 08:16 PM
by Biff Go to last post
2 1,247
Using a Text Cell to Reference a Worksheet Name by Jay L
I have one summary worksheet and approximately 45 data worksheets. Each row on the summary page needs 8 - 10 cells from each data worksheet. The...
May 31st, 2010 12:26 PM
by Roger Govier[_8_] Go to last post
7 1,235
Convert Kilo's to pounds and ounces by kls
Hi, is there a formula to convert kilo's into pounds? i can convert simply multiplying the kilos by 2.2 and dividing by 16, but this gives me 'decimal' answer...
May 26th, 2004 03:28 PM
by Go to last post
4 1,234
HELP! having trouble matching info with excel, HELP! by gloriamar
Hi, I'm required to present some info at my work, using two excel files. This is the task: File 1, has ID numbers in column A, and column B is blank. File...
June 6th, 2010 11:16 AM
by Mike Go to last post
1 1,227
help on averaging function by Treesy
Is there a way to not have a blank or zero value not be counted in an average function. Example: I have a spreadsheet that has a year's worth of data. ...
(Multi-page thread 1 2 3 ... Last Page)
July 18th, 2007 09:10 PM
by Harlan Grove[_4_] Go to last post
41 1,226
Combo Box & Linked Workbooks by D B
I have two questions: 1. Drop Down Boxes: Is there a way to actually convert a cell(s) to be a combo box? The only way I have been able to achieve this is...
September 15th, 2003 02:42 PM
by Arvi Laanemets Go to last post
1 1,223
remove 'click to add data' page? by mfouche
after I saved a excel document to pdf format the header and footer appeared, with a page on the right and bottom saying 'click to add data' How do I remove...
September 18th, 2009 08:45 AM
by mfouche Go to last post
0 1,220
A string of data in a cell by Elton Law[_2_]
Dear expert, I got a system generated file. Say cell A1 to A3 are...
June 3rd, 2010 10:00 AM
by Elton Law[_2_] Go to last post
3 1,214
Calculating pay dates by BW
If a date is a friday, I want to display the previous Thursday (MM/DD/YYYY). If a date is a Saturday - Thursday, I want to display the Thursday as a date...
June 6th, 2010 04:58 AM
by BW Go to last post
4 1,214
If statement by Doug
Does anyone have a solution? Subject: If statement From: "Doug" Sent: 6/25/2004 5:42:46 AM The format category...
June 28th, 2004 06:13 AM
by Doug Go to last post
9 1,202
Weibull function in Excel by Barbo
I have a survival dataset (see below). I want to fit to Weibull function S(t)=EXP(-alpha*Time^gamma). If I use Excel Solver, alpha=0.00367 and gamma=2.32. If...
June 6th, 2010 12:19 AM
by Mike Middleton[_2_] Go to last post
3 1,195
Excel 2000: Data Validation List - no drop down arrow; no frozen cells by Matt.
Hi all! I have an Excel 2000 spreadsheet in which I'm trying to use Data Validation to restrict entered values to a List. The List is hard coded on the...
August 20th, 2004 06:13 PM
by Matt. Go to last post
3 1,189
Excel "IF" function problem by Johan
Our domain uses group policy to configure user rights on the workstations, and it appears that on certain machines, or rather under certain user profiles, the...
September 15th, 2003 03:08 PM
by JM Go to last post
2 1,189
Consolidating info from multiple Worksheets by Al
Hi, Is there a function that allows me to copy data from multiple worksheets into ONE ?? All the worksheets (30) have the same type of info (i.e. Name,...
April 22nd, 2004 07:30 PM
by Frank Kabel Go to last post
1 1,185
Percentage formula in excel by Trevea
I have 4 columns which I have set up with a formula to calculate percentage. The 4 column formulas should equal 100% but they equal 106%. Can you help?
February 15th, 2008 02:50 PM
by Fred Smith[_4_] Go to last post
5 1,181
Post New Thread


Display Options
Showing threads 101 to 120 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 06:50 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.