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 Reverse Sort Order Last Post Replies Views
Sorting by cell or text format by
Does anyone know of a way to sort a list by the cell format or by the text format? I have a very long list where the 'good' cells have been colored in yellow....
September 16th, 2003 08:21 PM
by Richard O. Neville Go to last post
1 642
Data transfer2 by
Let me clarify. I am trying to transfer data from an excel 2002 cell to a specific place in a word 2002 document. I am not trying to cut/copy and paste. I...
March 11th, 2004 11:32 PM
by Frank Kabel Go to last post
1 166
Sumif over multiple pages with two criteria by
Try this Bill, =IF(AND(A1="BOOK",B1="YELLOW"),C1,"") Hope this helps. Jennifer -----Original Message----- I need help with a formula to give a total over...
March 17th, 2004 08:27 PM
by Go to last post
0 424
Loops by
I need a loop function in excel... is there such a thing? What I need is for excel to look over a range of cells and if there is data written in the cells to...
May 13th, 2004 03:12 PM
by Go to last post
3 248
Round function - round to 5 by
-----Original Message----- I'm trying to round to 5 but can't figure it out. Decimals are clear, so is round(xx, -1)... but: 26 should be 25 27 should be...
May 18th, 2004 11:36 AM
by Go to last post
0 259
merging 2 spreadsheets by
How do you merge two spreadsheets into one? Each spreadsheet shares a common field.
May 18th, 2004 07:23 PM
by Go to last post
0 93
Deleting a Link by
I've copied a worksheet from another workbook. When I open the file to which I have copied the message states that there is a link to another file. I don't...
July 5th, 2004 03:54 PM
by Gbonda Go to last post
1 107
look up a value in another sheet bases on vaues ound in another cell by
Does any one know how to get a value from one worksheet to put in another. for example on sheet 2 would be 3 columns. the values in the first 2 columns would...
July 14th, 2004 05:34 AM
by Go to last post
6 111
List by
Hello, I am trying to create a list in a cell that references a name range on another sheet. The only way I know how to create a list currently is to...
July 13th, 2004 07:21 PM
by Go to last post
2 100
Per Diem Caculation by
I am writing a spreadsheet to figure Travel Vouchers for myself and my Army classmates. I've everything except for Meal payments on weekends. Got the date...
March 7th, 2004 01:38 AM
by Peo Sjoblom Go to last post
4 85
array formula by
I have an array formula summing only posotive numbers in a single column but in differant rows. I'm not able to use the : because it sums all info inbetween...
April 8th, 2004 04:06 PM
by Bob Umlas, Excel MVP Go to last post
7 217
comparing values for matches by
I would like to set up a cell to look for a number match for a cell next to it in another worksheet and over many columns and rows. Does the value in...
October 27th, 2003 10:55 PM
by Go to last post
2 164
formulas by
I have a spreadsheet which tracks locations of parts. The location is in test format. I want to add up the total of each location to a numeric value. Any...
November 4th, 2003 06:23 AM
by macropod Go to last post
1 114
Calculating Ages by
I am trying to find a formula that will calculate ages in one column based on a birthdate entered into a previous column on a worksheet, that will update on a...
November 5th, 2003 10:28 AM
by Go to last post
2 158
Highest Number? by
How do I get the highest number from a column?
November 19th, 2003 03:58 PM
by Peo Sjoblom Go to last post
2 175
Unique entries in a filtered list by
Hi Peo, I posted it again in case anyone missed it the first time. I got your formula to work and although it was impressive it is not applicable for the way...
November 21st, 2003 02:08 PM
by Peo Sjoblom Go to last post
1 541
Excel on Pocket PC by
I understand that some complex spreadsheets transferred from PC to Pocket PC will not function since some of the commands are not recognised. However, similar...
December 17th, 2003 03:25 PM
by Go to last post
0 322
MSNStockQuote by
I have installed the add-in but the formula is bringing back the error message. As for more info...I am wondering if there is some way to determine if the...
January 17th, 2004 03:28 AM
by Ron Rosenfeld Go to last post
1 124
changing the background color on a single column by
I am trying to change the background color on one column. The only thing it will let me do is change the background on the whole table. Can someone please...
January 30th, 2004 11:32 PM
by Lady Layla Go to last post
2 157
Date and formulas by
Hi I have a spreadsheet with a load of dates when a particular service was carried out. I would like to create a formula in another cell with a date which is...
August 9th, 2004 04:24 PM
by Norman Harker Go to last post
9 141
Post New Thread


Display Options
Showing threads 221 to 240 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 04:37 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.