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
my formated column is displaying one cell incorrectly by jungbugg40
I have a spreadsheet with 4 columns; the 4th columns is a formula going across the 3 columns a+b-c = d with d preferably equally zero. When I format column...
January 6th, 2010 08:51 PM
by Gord Dibben Go to last post
2 121
Can I show a number like 1,935,674,923 as 1.9B? by Dave
I would like to reformat 10- and 11-digit the numbers (e.g. like 1,935,674,923 as 1.9B). Can this be done?
January 6th, 2010 08:41 PM
by Bernard Liengme Go to last post
8 178
Search for Employee Names by DaveMoore
Good Evening. My spreadsheet contains data imported from an Oracle database. This data is in text form in a single column and can run to many thousands of...
January 6th, 2010 08:39 PM
by Gord Dibben Go to last post
2 90
Excel Formula and Variance Analysis by Mur
Cell A1 is 10 an input Cell B1 is 5 an input Cell C1 is 5 a formula of A1 - B1 I want to only see variances that are greater than 25% of cell A1 and I can...
January 6th, 2010 07:57 PM
by Mur Go to last post
0 108
dates in VLOOKUP by MBG
Trying to use Vlookup to copy dates for a series of records (rows) from one file to another. The result in the placed file (where the formula resides) is 4...
January 6th, 2010 07:53 PM
by Dave Peterson Go to last post
3 88
Consolidating Redundant Text by Brad Autry
My issue: I've a worksheet with 17 columns of data. Total is roughly 10,000 rows. Of those 10,000 rows, I am dealing with roughly 1000 different items. That...
January 6th, 2010 07:39 PM
by Gord Dibben Go to last post
2 146
Create a button to insert a new row. by Sharon
I know Excel can do it; I just don't know how. In addition, once the new row is inserted, I need the formulas to carry into it. Any help is greatly...
January 6th, 2010 07:35 PM
by Bob Umlas[_3_] Go to last post
2 84
Concatenate including a date so that the date appears as a date by Zembu
When I try to join the contents of several cells, one of which is a date and time obtained from =now(), the date and time part appears as a number. How can...
January 6th, 2010 07:09 PM
by T. Valko Go to last post
2 117
Help with Formatting Number as Text by klafert
I have a spreadsheet that contains the following data: Date Account...
January 6th, 2010 06:38 PM
by klmiura Go to last post
5 146
Extracting Text From Right To Left - MID & FIND by Brenda
First of all I would like to thank you in advance for taking the time to look at this post and providing any help possible. I am a novice trying to learn...
January 6th, 2010 06:36 PM
by Glenn[_6_] Go to last post
3 191
Help by Steve
Howdee all. I was just presented with a problem that has got me curious. While it's something I have thought about before, I never knew where to begin with...
(Multi-page thread 1 2)
January 6th, 2010 06:35 PM
by T. Valko Go to last post
14 199
Lookup Values, return multiple. by JJ
I need help please. The formula I require has to in Worksheet A :- lookup DATA in Worksheet A SP001 in worksheet B
January 6th, 2010 06:33 PM
by T. Valko Go to last post
4 145
matching data in 2 worksheets by tabylee via OfficeKB.com
Hi, We have started entering our membership in an Excel workbook of about 500 names with names, age, birthday, address, tel no., mobile nos. 2 of us were...
January 6th, 2010 06:30 PM
by John Go to last post
3 147
Count based on date criteria by Erich
I Want to create a formula that will tell me based on any given day how many tickets were unresolved. I have the date fields "Call Taken" (Column B) and...
January 6th, 2010 06:20 PM
by Bernie Deitrick Go to last post
1 138
print area Excel 2007 by CraigJ
I have a pivot table in a worksheet that is updated each month. When I update the pivot table and try to drag over the print area to cover the new data,...
January 6th, 2010 05:36 PM
by CraigJ Go to last post
0 140
drag a formula downa column keeping one value the same? by column formula with a constant value
I need to drag a formula down a column, but keep one value constant (when I drag the formula down, the values in the formula change according to the row, but...
January 6th, 2010 05:14 PM
by David Biddulph Go to last post
3 113
vlookup help linking data between worksheet by tabylee via OfficeKB.com
hi, I have a master list of students (about 200+ )in one worksheet. On the succeeding worksheets are the attendance for seminars. We have more than...
January 6th, 2010 04:44 PM
by tabylee via OfficeKB.com Go to last post
3 124
How to use the search in an if statement by trinamariem
I have a spreadsheet with numbers in column B and letters in column C. I need to search for "J" in Column C and if there is not a J there and there is a...
January 6th, 2010 03:51 PM
by trinamariem Go to last post
3 94
January 6th, 2010 02:44 PM
by Brenda Go to last post
0 126
how do i create a divisible formula by Tim
I use a xl doc that has numbers in the cells that need to be divisible by 15. Can i incert a formula that will check the number in B5 and display an error...
January 6th, 2010 02:41 PM
by Huber57 Go to last post
3 88
Post New Thread


Display Options
Showing threads 4101 to 4120 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 08:30 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.