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 274
Data Validation Limits by
I used Data validation to custom zip code because I needed to limit the numbers. Some numbers started with 00 and if I used the number or text choice the...
April 15th, 2004 07:11 PM
by Peo Sjoblom Go to last post
2 123
sumif; conditional sum by
I'm trying to get a conditional sum based on the relation of the cells in the column to be evaluated to a fixed cell. If the amount in the cell in the...
April 26th, 2004 05:39 PM
by Nancy Go to last post
3 78
Adding a column of numbers by
I have a large worksheet and have entered numbers in a column. Numbers range in value from 255 to 300. When I perform the +sum(a1.a12) function my result is...
April 27th, 2004 05:36 PM
by David Go to last post
3 100
Questions about IF Function by
My workbook contains two worksheets. One of the sheets is used to query a database and return select columns of data. The other worksheet is used to organize...
April 29th, 2004 04:46 PM
by Charlie Go to last post
1 48
Workdays (inc Sat) formula by
I need a formula to tell me the number of workdays between two dates, the problem being that Saturday I consider a workday. The NETWORKDAYS function obviously...
(Multi-page thread 1 2)
May 13th, 2004 03:45 AM
by Vasant Nanavati Go to last post
13 119
filling series problem by
Sorry, other way around, I want it to fill like: Sheet1 A1 Sheet2 A1 Sheet3 A1 but I get: =(Sheet1!A1) =(Sheet1!A2)
June 22nd, 2004 09:31 PM
by Alan Beban Go to last post
2 42
VLOOKUP by
Randy wrote: in the range that contains the lookup value, there are multiple or duplicate entries, is there a function or formula that gives all...
July 8th, 2004 06:00 AM
by Alan Beban Go to last post
1 71
combining functions (VLOOKUP and SUM) by
I have an excel report that needs to be fed from an excel database. The best function I found was vlookup. However, vlookup only capture the result of one...
July 9th, 2004 09:58 PM
by Frank Kabel Go to last post
1 74
How to determine duplicate records by
Hello there! Anybody could help me? I want to know if there is a way I could determine a duplicate entry about 10000 records becuase i do it manually: for...
March 23rd, 2004 03:51 PM
by Go to last post
0 76
printing excel spreadsheet in word by
How do I get the gridlines to print in my word document using XP?
March 25th, 2004 09:43 PM
by Go to last post
0 93
excel by
What does the function or symbol ^ mean?
October 11th, 2003 10:16 PM
by James Silverton Go to last post
1 88
offset/match by
I am trying to create an offset/match formula that pulls data from a separate worksheet, but it is not working. is there any restrictions on this?? thx,
October 30th, 2003 11:18 PM
by Harlan Grove Go to last post
3 104
Random Number Generator - Help! by
Any and all help is appreciated. Starting in Cell B7, I have a list of names. In E7 is a sequential number (starting at 1) that is associated with each name....
November 3rd, 2003 03:36 PM
by Arvi Laanemets Go to last post
3 113
Formula needs more than 256 columns by
I want to calculate a MMULT formula and I need a table of 319x319 cells. Can I divide the table over 2 sheets or in two parts on the same sheet and still use...
December 9th, 2003 06:40 PM
by Harlan Grove Go to last post
2 75
Send add result to next sheet by
I need to copy/send an 'add' result to a cell on the next sheet. a+b+c='d' where 'd' is then copied to a designated cell on the next sheet. If d 0 then copy...
December 10th, 2003 08:49 AM
by Andy B Go to last post
1 96
Hide Column Help Needed! by
-----Original Message----- Hi, I hid two columns in my excel spreadsheet and now I want them back. How can I do this? Please...
January 21st, 2004 05:23 PM
by Go to last post
0 49
vlookup question by
hi say i have colA and colB. i m using vlookup (in other sheet) to lookup for values in colA and returning corresponding value in colB. problem arises when...
March 18th, 2004 05:55 PM
by Frank Kabel Go to last post
5 60
wanna make 20,000-60,000$ from 6$ only...EXCELLENT CASH INCOME$$$ by
What a waste of everybody's time -----Original Message----- EXCELLENT CASH INCOME I started out with $6. Now, I am making thousands. I found...
March 25th, 2004 02:30 PM
by Go to last post
0 222
Total for negative amount by
Hi all, Need you advise on how to Sum-up the following amount only total the negative sign amount (from range A2 to A13) and the results is...
September 20th, 2004 01:58 AM
by duane Go to last post
2 63
Post New Thread


Display Options
Showing threads 241 to 260 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:02 AM.


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