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
finding the earliest date in an array of cells by Buck
I have one column with various dates.....lets say B2:B20. The next column (C2:c20) with values such as 1, 4, 8, etc. I am trying to calculate the earliest...
May 13th, 2009 12:55 AM
by Ashish Mathur[_2_] Go to last post
3 140
Refer to a named range indirectly by tberkom
I'm looking to refer to a named range in a VLOOKUP formula that gets its value from another cell. In other words, the cell contains a text value that...
May 13th, 2009 12:33 AM
by Ashish Mathur[_2_] Go to last post
1 165
To Calculate the qty b/w two dates by vmohan1978
In Sheet 1 the table is as below SL.NO Received Dia Qty (MT) 1 29-Mar-03 20 19.89 2 31-Mar-08 10 6.51 3 31-Mar-08 10 0.63 4 11-Apr-08 10 1.43...
May 13th, 2009 12:20 AM
by Herbert Seidenberg Go to last post
3 119
Renaming worksheets by James
I have an excel 2003 Checksheet that needs to be undertaken on a daily basis. I would like it have a copy of the original checksheet for every day of the...
May 12th, 2009 11:45 PM
by James Go to last post
0 160
DSUM to pull data from Access DB by Brian[_16_]
Howdy All, I'm trying to sum data contained in an Access DB based on multiple criteria. DB name = FTD.mdb location = c:\FTD.mdb I'm trying to sum Labor...
May 12th, 2009 11:21 PM
by Brian[_16_] Go to last post
2 188
Header/Footer on entire workbook by tonyalt3
Does anyone know how to make a header/footer for an entire workbook instead of having to do it for each sheet?
May 12th, 2009 11:14 PM
by Gord Dibben Go to last post
2 158
Format Cell by bennetto
I need to limit a cell to 30 digits.
May 12th, 2009 11:02 PM
by Gord Dibben Go to last post
5 162
Linking data? by Ron_Ron
I have one sheet with a list of ID numbers and there corresponding names. In another sheed I have 100,000+ rows of data that contain the ID number as well as...
May 12th, 2009 10:50 PM
by Ron_Ron Go to last post
2 153
SUMPRODUCT Help by RoadKill
Here is my formula: =SUMPRODUCT(('5-1'!$B$2:$B$1000="John Doe")&('5-1'!$D$2:$D$1000="Product One")&('5-1'!$D$2:$D$1000="Product...
May 12th, 2009 10:46 PM
by T. Valko Go to last post
7 137
how to display my cursor cell content in another cell.... by dh13134
hi is there a function that can display the content of whatever cell my cursor is currently in? for example, A1="Dog", A2="Cat", and A3="Horse". i want cell...
May 12th, 2009 10:43 PM
by Don Guillett Go to last post
3 132
Delete a toggle button overlaying data by Gigacrete
I have an"inherited" worksheet which has a "toggle" button overlaying data - how do I get rid of this
May 12th, 2009 09:56 PM
by Dave Peterson Go to last post
1 167
4 IFs by Steve
How can 4 ifs give me one of 3 numbers in the following situations: If between 1200-2000, = 3 If between 2001-2400, = 1 If between 0001-0400, = 1 If...
May 12th, 2009 09:41 PM
by Steve Go to last post
4 135
excell big dilemma by dingbat
Hi again,,,, I work for a bus company and would like to link sheets in a workbook I have list of duties on one sheet with times they start and end. Within...
May 12th, 2009 09:20 PM
by dingbat Go to last post
0 127
Vlookup for multiple results by Kris
I am trying to create a formula that will compare lists and return data for as many times as it finds the name in a column. For instance, I have a vendor...
May 12th, 2009 08:46 PM
by Harlan Grove[_2_] Go to last post
3 140
help with calculating average prices and profit/loss by monkeytrader
i hope someone can help me with trying to sort and calculate an enormous set of data (25k rows) automatically with a function(s). here is an example of the...
May 12th, 2009 07:34 PM
by Iriemon Go to last post
3 129
Sumproduct excluding multiple criteria by Ivano
Hi, I'm trying to use the SUMPRODUCT formula to add up a colunm but exlude certain values based on a criteria in another column. I have column A which has...
May 12th, 2009 07:27 PM
by Bernard Liengme[_2_] Go to last post
4 141
sum of every 4th cell in a row. by Monique
I am trying to set up a spread sheet where each element in a row has four different columns of data. At the end of the row I need to do various calculations...
May 12th, 2009 07:21 PM
by T. Valko Go to last post
3 134
New row(s) macro by PSM
What code can I use to attach to a button whereby the user can input how many rows and which row to add them from ? Thanks Phil
May 12th, 2009 06:46 PM
by Gord Dibben Go to last post
1 134
Link changes in destination workbook by confused
I have 2 workbooks linked - when I insert a row in the source workbook the destination workbook does not update (even when I do an update). ex. cell A2 in...
May 12th, 2009 06:06 PM
by Cindy Go to last post
2 70
Survey Form And Tracking Results by Joe Gieder
Can a survey form be setup in Excel and track all the results? I have seen a few examples but these only look like they can have a form but when hundreds of...
May 12th, 2009 05:15 PM
by Joe Gieder Go to last post
2 146
Post New Thread


Display Options
Showing threads 11161 to 11180 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 10:22 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.