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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
How can I import a very large PDL from outlook into excel by Bec G (Oz)[_2_]
Hi I've got a PDL that has 2000 names on it and I need to update it. I have a list of names in excel which is the latest informaion that I need to compare...
November 12th, 2009 02:11 PM
by JLatham Go to last post
1 194
convert each letter(text) to number by Joy
I need to calculate text for each letter, it is possible for using for numerlogy name calculation. for expl: Joy +1+7+1=9 j...
November 12th, 2009 01:11 PM
by Bob Phillips[_2_] Go to last post
2 220
Saving changes to option to apply all the time. by Stuart A
I would like to make changes in excel options, to select 'set precision as displayed' which i can do in each time, but i want this option selected for each...
November 12th, 2009 12:19 PM
by Jacob Skaria Go to last post
1 182
Short listing the Data Validation List by Asoka Walpitagama - Brandix College IT
I have over 4000 entries as the prd code & need to enter them on a worksheet. By using DATA VALIDATION is there a feature to shortlist the list when typing...
November 12th, 2009 08:12 AM
by T. Valko Go to last post
2 222
Pivot ... Drag Multiple Fields from Field List? by Ken
Excel2003 ... I wish to setup a Pivot which has Several Orders. Is it possible to drag ALL Orders from the Pivot Table Field List to the "Drop Data Items...
November 12th, 2009 07:50 AM
by Debra Dalgleish Go to last post
1 234
How to use 2 conditions in conditional formatting by Asoka Walpitagama - Brandix College IT
A B C DATE 1 Supplier DATE 2 12-Nov BTT 10-Nov 12-Nov BCT 11-Nov 13-Nov BTT 12-Nov 11-Nov BLL ...
November 12th, 2009 07:41 AM
by Jacob Skaria Go to last post
1 196
Formula Extend in Excel 2007 by Deano
I have a fairly simple spreadsheet in Excel 2007. As data is entered into a new row, some of the formulas from the previous row automatically extend into...
November 12th, 2009 06:42 AM
by Jacob Skaria Go to last post
1 245
win or lose formula needed by Pete
I need to come up with a formula that will result in Good or Busted The racers speed must be within 1.25% (+ or -) of the speed entered into the equation...
(Multi-page thread 1 2)
November 12th, 2009 05:43 AM
by Pete Go to last post
10 521
can I use dates as the lookup argument with HLookup? by crashume
Syntax seems right but I get a #value result. Am i right to assume date arent usable?
November 12th, 2009 05:25 AM
by T. Valko Go to last post
2 219
How do I insert a pop-up box to alert me when numbers are wrong? by Mallymoo
I would like to have a box pop-up to alert me when two numbers in my spreadsheet do not match. Can somebody please let me know how this is done? If that is...
November 12th, 2009 04:26 AM
by Dave Peterson Go to last post
4 191
How can I scroll within an alphabetical list in Excel? by mkfrl
I have a spreadsheet in Excel which contains a very long list of clients (30,000 or so). I have them sorted alphabetically, but I would like to be able to...
November 12th, 2009 04:11 AM
by JBeaucaire[_133_] Go to last post
1 234
VBA Code for "" empty cell by ManhattanRebel
The following IF function works in Excel, but when I copy it into VBA so I can excute it in a range it will not work. Range("p6:p40").Formula =...
November 12th, 2009 03:12 AM
by ManhattanRebel Go to last post
2 173
Retrieve data from excel database by Vanya Noble
Using the Template Wizard Add-in, I have created a form/template and have successfully sent inputs to an excel database. Is it possible to retrieve data from...
November 12th, 2009 01:51 AM
by Vanya Noble Go to last post
0 183
Linked files extremely slow to save. by BKeiser
I have about 8 files that have links between themselves. Not always, but most of the time if I have more than one of them open, when I go to save one, the...
November 12th, 2009 01:19 AM
by BKeiser Go to last post
0 211
Stock Values in Excel by Maurice
I write to inquire if there is an efficient way to get stock values into excel 2007? Additionally, I would like to be able to get dividends into the same...
November 12th, 2009 12:32 AM
by AFSSkier Go to last post
2 208
MIN/MAX Multiple worksheets by Dave R
How can I get min/max of a single cell reference from up to 50 worksheets in a single workbook?
November 12th, 2009 12:15 AM
by Peo Sjoblom[_3_] Go to last post
5 203
File Compatibility by moon
I am now using Excel 2007. What file format should I use for my Excel 2003 documents? How do get that file format? Thank you.
November 12th, 2009 12:08 AM
by Peo Sjoblom[_3_] Go to last post
1 178
underline in an empty cell by MarcB
Is there a way to have an underline (single accounting) in an empty cell? -- MarcB
November 11th, 2009 11:56 PM
by dlw Go to last post
2 193
Sorting a column with Text and Numbers by tstobb
I'm trying to sort a column that contains both text and numbers so that the numbers appear in order instead of 1,10,11,12,19,20,21, etc. I can't use...
November 11th, 2009 11:46 PM
by Dave Peterson Go to last post
1 197
Identify text nums in scrambled fashion by Max
All nums are text nums In A1:A3 would be 3 "winning" 4-digit text numbers, eg: 0044 1234 4233 In C1 down will be input 4 digit text nums such as:
November 11th, 2009 11:45 PM
by T. Valko Go to last post
3 196
Post New Thread


Display Options
Showing threads 10121 to 10140 of 139764
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.