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 would I do this sum in Excel please? by Denise Green
am new to excel (and maths to some extent!) so how do I put the following calculation into the formula bar please. 42,450 x (1+0.004167) to the power of 120
November 14th, 2009 04:55 AM
by Dana DeLouis[_3_] Go to last post
7 343
How to delete Excel 2007 file from list under Recent Documents by GPS
I deleted all old files from my documents folder but all still shows up at Recent Documents when opening Excel. Any Ideas?
November 14th, 2009 03:59 AM
by Patty Jones[_2_] Go to last post
4 447
Mysterious "Arc" appearing at the bottom of the page by PlarfySoober
When I either Print Preview or print my spreadsheet (I got it from another guy who is sort of nutsoid), I get a large, wide-line arc printing at the bottom...
November 14th, 2009 02:22 AM
by Gord Dibben Go to last post
6 264
Formula Values not Updating by dcornett63
Hello, I have a multisheet spreadsheet that keeps track of costs on jobs that extend over multiple days (a worksheet for each day). This is something that...
November 14th, 2009 12:42 AM
by Luizvs Go to last post
1 256
Compare 2 lists / conduct gap analysis (XL 2007) by AMR
I'm looking for an easier way to conduct a gap analysis between two lists in Excel 2007. My company has a tool that sends out documents to clients based on...
November 14th, 2009 12:20 AM
by Dave Peterson Go to last post
5 364
Combine multiple columns to one with separator, omitting empty col by CD-UIO
I have 50 Columns of text data, not all of which contain values, I want to combine these into one column, with each value separated by a coma, but omitting...
November 13th, 2009 11:48 PM
by Gord Dibben Go to last post
8 265
Average Time for Specific Item by stkinkuwait
Thanks in advance for any help! I am trying to calculate the average time it takes to accomplish a specific task amongst many tasks during an 8 hour weekday,...
(Multi-page thread 1 2)
November 13th, 2009 11:21 PM
by stkinkuwait Go to last post
10 386
use pivot table data in vlookup formula by Jennifer Novato
When I copy the results of a pivot table to another worksheet, the vlookup formula in the other worksheet does not recognize the same number from the data...
November 13th, 2009 11:17 PM
by Jennifer Novato Go to last post
0 230
BVE = BE? by Todd
why is it when you type "BVE" onto a cell it changes it to BE?
November 13th, 2009 10:45 PM
by T. Valko Go to last post
2 249
Problem with a simple formula by ChristiW26
I've entered a simple "=sum" formula into a cell on a worksheet and for some reason, the formula is being displayed in the cell instead of the value. I've...
November 13th, 2009 10:44 PM
by Sean Timmons Go to last post
8 309
sumif based on 1 criteria by v1rt8
cannot quite figure this out, Cells a3:a1000 have respectively numbers 1-997 Cells f3:f1000 has text containing either of 4 types...
November 13th, 2009 10:26 PM
by v1rt8 Go to last post
1 211
MATCH with MAX formula question by Spongie
I'm hoping someone can help. I have the following formula in a spreadsheet: =IF(MATCH(MAX(C22:G22),C22:G22,0)=1,"Low...
November 13th, 2009 10:09 PM
by Lars-Åke Aspelin[_2_] Go to last post
5 190
averageif with 2 other criteria by v1rt8
Need some help with an averageif calc. setup is as follows: q3:q1357 contains ages r3:r1357 contains text (active), (MGT), (others) so averageif q3:q1357...
(Multi-page thread 1 2)
November 13th, 2009 10:00 PM
by T. Valko Go to last post
10 437
Concatenate not working by NicoleS
Using Excel 2007 - though I've seen this problem in '03, too. I inserted a concatenate formula into a cell: =CONCATENATE(B3," ",A3) Then I dragged the formula...
November 13th, 2009 09:56 PM
by Dave Peterson Go to last post
3 223
Resetting the scroll bar by Todd
Lets say I have a spreadsheet with information going out to column FT and I deleted the information because it was no longer necessary. Now my data only goes...
November 13th, 2009 09:53 PM
by Dave Peterson Go to last post
1 213
what is the best way to pull in external data from SQL table by Lorina
I want to pull in information from our ERP system into excel so I can combine it will other information (that is not in our ERP system) and I want to be able...
November 13th, 2009 09:16 PM
by berniean Go to last post
3 227
nested ifs by dave glynn
Cell C1 takes is value from any one of three other cells depending on the value of cell B4. The if statement I should like to writr would go something like...
November 13th, 2009 08:55 PM
by dave glynn Go to last post
4 179
Count Names by B. Levien
I have an excel spreadsheet with Columns like: Column C Column D Column E Award1 Award2 Award3 Row 1 Brenda Joe Shana Row 2 Misty Joe Monty Row 3 Brenda...
November 13th, 2009 08:48 PM
by Sean Timmons Go to last post
2 217
Splitting text and numbers from a cell by JimAA
Hi, I'm trying to split a cell that contains a part number and a part description into a cell that contains the part number and a cell that contains the part...
November 13th, 2009 08:33 PM
by Ron Rosenfeld Go to last post
4 202
if then and conditional formatting of dates by KidA
I'm trying to format a spreadsheet so past dates in column F appear in red. column E column F entered Date+30 I've added...
November 13th, 2009 08:07 PM
by KidA Go to last post
3 291
Post New Thread


Display Options
Showing threads 10021 to 10040 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 04:49 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.