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
vlookup from multiple sheets by Radhakant Panigrahi
i have data in 10 different sheets (Sheet 2 to Sheet11)with identical columns. i need to use the vlookup function in Sheet1 taking the range from column E to...
May 19th, 2010 08:27 AM
by L. Howard Kittle Go to last post
2 282
CELL IS NOT ACCODATING MORE THAN 12 NUMBRS HOW TO ENTER 15 DIGIT by LOGANATHAN IYER
I AM NOT ABLE TO ENTER MORE THAN 12 DIGITS I .E. 123456789012 THE CELL DOES NOT ACCOMMODATE - AFTER ENTERING: 123456789012345678 THE RESULT SHOWN IN CELL IS : ...
May 19th, 2010 08:26 AM
by David Biddulph Go to last post
2 231
Function Has Too Many Arguments by tb
I am using Excel 2007 for Windows. Excel complains that one of the functions in the following formula has too many arguments. I am not quite sure which...
May 19th, 2010 02:26 AM
by tb Go to last post
4 221
extend the range of cells for a drop down list by Marge
I have a range of cells (named staff) on a worksheet in the workbook where the drop down list will be used. Additional cells were added to the range of...
May 19th, 2010 12:49 AM
by Ashish Mathur[_2_] Go to last post
8 277
Tables in excel- bringing down formulas for new records. by Ben
I am trying to put together a table and want to have an auto number that counts the recods and puts the next number in for a new record. Need a good method...
May 19th, 2010 12:35 AM
by Ashish Mathur[_2_] Go to last post
2 325
Sorting columns into a table by Christian
Hi, I need to sort the following data in A2:C8 to E2:G8 (actually there are 40 rows of data). The date needs to be sorted to Low risk first (then mid and...
May 19th, 2010 12:32 AM
by Ashish Mathur[_2_] Go to last post
6 305
MLK b-day as holiday date by Greg
hi, i need a function to calculate what date would be the 3rd monday in January for a given year. can this be done w/o arrays? thanks -- ______ Regards,
May 18th, 2010 11:32 PM
by Mike H Go to last post
5 149
Help with data points in line graph in Chart function in Excel. by BDF
I added data to an existing line graph and the data points do not align properly with the values on the Y axis. For example, a data point valued at 119...
May 18th, 2010 11:29 PM
by BDF Go to last post
0 178
Pivot Item Displaying Incorrect Value? by mark
We have a pivot table, which has Project as pivot field 4. The Project pivot field has 3410 pivot items, of which number 842 is misbehaving. The project...
May 18th, 2010 10:36 PM
by mark Go to last post
1 173
How can stop a 9 digit number from formatting scientific by Excell Rooky
I am completing a pivot table/csv file for Government Legislation requirements and my user id number for submitting the information keeps reverting to a...
May 18th, 2010 10:35 PM
by Billns Go to last post
3 226
Multiple text-number in cell divider formula? by ekonomija
Dear, Is it possible in Excel to divide multiple text and numbers in the separate columns. Text in one and two numbers in separate For example: Jane &...
May 18th, 2010 10:33 PM
by Ron Rosenfeld Go to last post
1 172
how do I attach a jpeg to a cell by Mark
I am trying to have a button or link in a cell that when clicked will open up a jpeg that is also attached to (part of) the excel file.
May 18th, 2010 10:33 PM
by Billns Go to last post
1 166
Difference Between Dates WITH Conditional Formatting by DOUG
I want cell C2 to turn RED if it is more than two days different than the date in cell B2. Oddly, the formula "=B2-TODAY()2" works, but that is not what I...
May 18th, 2010 10:25 PM
by Gord Dibben Go to last post
2 147
Write a sum formula to determine the total of all the numbers bel by cristian
how can i do the the work to havee to do
May 18th, 2010 10:17 PM
by Gord Dibben Go to last post
2 204
Calendar Control missing by deafo
Giday to you all, I'm trying to help fellow worker who have Excel 2003 and he does'nt have Calendar Control in Object dialog box. Even his computer in...
May 18th, 2010 10:13 PM
by deafo[_3_] Go to last post
4 216
Find 3 If(Iserrors instead of 1 by Steve
I posted this a week ago, and did get a couple of responses, but they did not work. So I'm trying again, thinking that the wealth of knowlege here is such...
May 18th, 2010 10:05 PM
by T. Valko Go to last post
7 219
Max Function by Iriemon
Is there any function available that works similar to the MAX function for alpha characters? Thanks Irie
May 18th, 2010 09:20 PM
by Rick Rothstein[_2_] Go to last post
3 154
Show comments when printing a document by DBish
Is it possible to print a worksheet within an excel document and show the comments that are generated within?
May 18th, 2010 09:13 PM
by Rick Rothstein[_2_] Go to last post
2 146
using a conditional in STDEV function by Researcher
I would like to use the STDEV function on a set of cells that have been indicated by a conditional statement. I have tried a variety of ways and have not...
May 18th, 2010 08:33 PM
by Luke M[_4_] Go to last post
1 142
Include YTD calculations? by MrRJ
Hello, I have built a table with formulas similar to this. I need assistance on how I can create a YTD table based on what Period I...
May 18th, 2010 08:33 PM
by MrRJ Go to last post
4 124
Post New Thread


Display Options
Showing threads 461 to 480 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:34 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.