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 and combining data by
I've got two different spread sheets with large amount of data. These two charts however share one grout of data (in this case street address) The first set...
October 6th, 2003 01:22 PM
by Bernie Deitrick Go to last post
1 219
pull down menus by
how do you make pull down menus from a cell???
June 26th, 2004 05:54 AM
by Don Go to last post
3 173
how to switch a #N/A value into 0 by
I used the vlookup function to get pricing from a=20 database which is multiplied by a specific volume. When I=20 have no pricing in the database for a product...
July 22nd, 2004 10:01 PM
by JE McGimpsey Go to last post
1 83
Custom Function & Personal.XLS by
Excel 2000 SR1, Win2kPro Using a custom function works fine if the module is in my current workbook, but when I move the function to the module in my...
July 30th, 2004 07:04 AM
by Frank Kabel Go to last post
1 324
Percentages by
I have several percentages in a drop down validation box. I'm trying to put 23.5% in using one decimal place. It shows as 23.5%, however, when you choose it...
September 2nd, 2004 04:04 PM
by Don Guillett Go to last post
1 130
Count function by
How can I count a text value only once when there are multiple occurrences in a column?
September 2nd, 2004 09:12 PM
by Gabor Sebo Go to last post
2 129
Indirect References - Summarizing sheets - Relative? by
Hi all - Hoping anyone could help on this problem I am seeing. I have a workbook called SummaryForecast and have several sheets in the book: Summary; DeptA;...
September 2nd, 2004 08:28 PM
by Frank Kabel Go to last post
1 174
Dollar amount dependent on date by
Hi, I have a column of $ amounts and corresponding dates in another column. Date Amount 1/1/04 $100.00 1/15/04 $100.00 1/31/04 ...
September 7th, 2004 04:35 PM
by Go to last post
4 336
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 129
Do I use an IF function? by
Here is what I'm trying to do. I'm making an expense record chart. I am entering a negative (-) number for items paid with a credit card and a positve (+)...
June 12th, 2004 01:25 PM
by Frank Kabel Go to last post
9 134
Returning a Value by
I had two spreadsheets. The first contains two columns of data, and on the second I wish to set up an equation (no macros or sorts) so that when I type in a...
June 12th, 2004 02:00 PM
by JulieD Go to last post
6 119
Excel Template Function by
I need to insert a function into one cell of my worksheet (which will become a template) so that everytime the template is use it adds a number. Like a counter...
October 21st, 2003 08:59 PM
by Go to last post
0 212
Name conversion by
I have a spreadsheet that is updated by multiple users. When they enter their names they enter it in the format (first_name Last_name). Does anyone know how I...
November 18th, 2003 05:35 AM
by immanuel Go to last post
1 103
Sequential Cell Reference follow-up by
That worked Great! Thank you. I'm probably pushing it, ...... but it would be ideal if a qualifer could be added ... e.g. add '@IF(A10,A1,0)for B:600;...
December 9th, 2003 06:58 PM
by Harlan Grove Go to last post
1 105
mail merge foorm excel to word having problems by
I am trying ot do a mail merge form and excel spread sheet that has the addres infromation onto a letter in word, I have everythign but once I hit merge it...
January 7th, 2004 11:50 PM
by David McRitchie Go to last post
1 515
Need Formula the yields same count as my multicolumn filter by
When I filter a multi column table, one column "Pledge" contains only "Y" or (blank). I filter this column to ="Y". The second column "Grades" contain 1 or...
February 14th, 2004 04:44 AM
by Peo Sjoblom Go to last post
2 216
long formula by
Could you suggest a way to trim this formula...
April 23rd, 2004 07:11 PM
by Jennifer Go to last post
9 147
Sorting by
I have office xp. I'm new to excel and having trouble sorting a column of names. The sort tool is grayed out no mater what cell I select. If I start a new file...
May 28th, 2004 05:45 PM
by Frank Kabel Go to last post
3 96
color tabs on excel worksheet by
I am interested in knowing about the excel spreadsheets where u can color code the tabs
May 28th, 2004 06:09 PM
by Harald Staff Go to last post
2 300
Cell by
I type account number in cell and it turn into 2.50021e+12. I check the format o cell and it just gernral. The 2.50021e+12 is underline. I not sure wy the cell...
September 20th, 2004 06:35 PM
by Lady Layla Go to last post
2 124
Post New Thread


Display Options
Showing threads 61 to 80 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 02:53 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.