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
Convert a Cell Reference to Text by Chuck Buker
Cell A2 contains the text "a100". Cells A5 through F15 contain indirect and offset functions that use the text in A2 to cause cells A5 through F15 to refer...
September 22nd, 2003 05:04 PM
by Chuck Buker Go to last post
6 9,838
Array formula in merged cells by vtisix
I have a simple array formula that sums 3 criterias. After I've entered the formula and do Ctrl+Shift+Enter, an error pops up stating that "Array Formulas are...
May 12th, 2015 06:08 PM
by Methodician Go to last post
8 7,690
Movie Times Calculation? by CAMooV
I work for a major theatre chain an no one (inclduing the help desk) can figure out how to make a show start/end time schedule calculate the ending time. ...
September 18th, 2003 05:08 PM
by Charlie Go to last post
3 7,151
Sort & Filter grayed out by ljCharlie
I have a table with A-G columns and 20 rows. If I do not select column A then the "Sort & Filter" is enable. The "Format as Table" also works. As soon as I...
January 30th, 2011 09:16 PM
by ljCharlie Go to last post
0 3,704
Radio Buttons on Worksheet by Jeff Monroe
I am just trying to add simple groups of radio buttons to a worksheet for yes-or-no questions to be filled out by the user. No funtions, no data being entered....
March 28th, 2012 05:59 PM
by Jeff Monroe Go to last post
0 3,692
What is DBRW as used in Excel cell formula ie =DBRW( by Carlos
What is DBRW as used in Excel cell formula ie =DBRW(
June 4th, 2006 11:13 AM
by Gary''s Student Go to last post
1 2,819
VBA FORMAT(date,"YYYYMMDD") not working in Excel 2003 but works i. by JV
I have VB code in Excel Spread sheet that uses Format function to convert date to yyyymmdd format, it works in Excel 2000 but not in Excel 2003. Any info on...
September 16th, 2004 05:58 PM
by JE McGimpsey Go to last post
1 2,792
Select a worksheet by Phil
I'm using the below formula to determine the specific type of equipment from a list named:...
April 18th, 2011 12:33 PM
by tarquinious Go to last post
4 2,779
Signature question by ElaineT1
I am trying to set up a workbook in Excel 2007 with multiple tabs and two signature lines at the bottom of each sheet. The idea is that my boss can read, sign...
January 18th, 2012 06:33 AM
by martincrow Go to last post
1 2,676
Conditional Drop Down by sunil.kini
In the attached excel file there are list of names and list of cities. If I select city as "DELHI" for "A", I should not get "DELHI" in subsequent drop downs....
May 16th, 2011 10:29 AM
by tarquinious Go to last post
2 2,637
copy paste via macro by Azrael
I need to copy certain data from a page and move it to another form, in the same book. The basics is that data will be entered each day then the user will hit...
March 16th, 2011 10:48 AM
by tarquinious Go to last post
1 2,559
Macro: Insert formula for each row of data by Jeff Monroe
I have a variable sized data set in a work sheet. Simplified it's like this: A B 1 data1 =Today() 2 data2 =Today() ...
August 23rd, 2011 12:52 AM
by Jeff Monroe Go to last post
2 2,555
Selecting a Particular sheet by shajizz
I'm using Excel 2007, workbook there is several sheets, I want to select the particular sheet from the first sheet, any tips please... Expl:- I'm making...
January 27th, 2011 05:05 PM
by ukgiftsshop Go to last post
3 2,390
maintaining constant percentage by SF123
Am trying to construct formula in excel 2007 for maintaining a constant percentage. Example: company 1 has 1,000 shares. Company 2 wants to purchase 10% of...
February 4th, 2011 11:01 PM
by Azrael Go to last post
2 2,374
Scoring or Rating by JamesZ
From a previous post. Thought this example might be easier to understand. I have an Evaluation Sheet that has four cells of different ratings each...
March 15th, 2011 11:25 PM
by tarquinious Go to last post
1 2,372
Can Excel automatically insert current date in a cell? by AdrianXing
Does anyone know of a function that can make Excel automatically insert the current date into a cell when a file is opened up?
(Multi-page thread 1 2 3)
June 3rd, 2010 09:42 AM
by steve Go to last post
21 2,267
Can I Use a Count Function for Text? by Joan NYC
I have been trying to calculate a column of Text in order to sum contents by certain criteria I have tried Count, CoutA and CountIF and cannot be able to get...
(Multi-page thread 1 2 3 ... Last Page)
May 22nd, 2010 07:17 PM
by Chris Reid Go to last post
106 2,251
Finding roots of non-linear equations in Excel by TCO
I would like to find the first 20 or so POSITIVE roots of the following equation: A1=ATAN((2*A1*4)/(A1^2-16))/2 I have the "iteration" option turned on in...
(Multi-page thread 1 2)
August 4th, 2004 06:27 PM
by TCO Go to last post
14 2,149
Moving comments in Excel by sollc
I have moved a comment by dragging and dropping it. However, when I 'hover over' the cell with the comment, the comment box goes back to its original position....
April 13th, 2011 01:18 PM
by sollc Go to last post
0 2,107
Delta E(cmc) formula by Michelle7890
Does anyone out there have the Delta E cmc formula for excel? I am trying to set up a spreadsheet that compares colors of test samples to a reference sample...
(Multi-page thread 1 2)
May 5th, 2009 02:46 PM
by Dana DeLouis[_3_] Go to last post
10 2,091
Post New Thread


Display Options
Showing threads 1 to 20 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 01:57 PM.


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