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
Excel Preview by TC
Does Excel have a preview pane (document map) on the left like in Word ?
November 18th, 2009 10:33 AM
by Jacob Skaria Go to last post
1 89
simple question about excel by Μανολης Β
I have an excel list with 300 names. Each name and surname are both written to the same cell (eg. "George Smith"). However i want name and surname be in 2...
November 18th, 2009 10:13 AM
by Stefi Go to last post
5 121
E2007 - Macro for splitting text and then replacing something by Niniel
Hello, Could somebody please help me to modify this macro that I recorded with the macro recorder so that it won't contain any hard-coded columns anymore and...
November 18th, 2009 10:11 AM
by Niniel Go to last post
2 101
Calculation by inserting = sign at the start of equaton by Rechie
I have column in a sheet that contains below: 8+4+8 8+4+4 4+8+4 4+8+2 Equation might be text as I exported this from other application. I have to insert = sign...
November 18th, 2009 09:47 AM
by muddan madhu Go to last post
3 96
IF function by Phil
Can I use the "if" function to determine if a cell contains a value that is "greater than 1 but equal to or less than 5"? eg.... if b4 1 =5 IF TRUE.... IF...
November 18th, 2009 06:27 AM
by David Biddulph Go to last post
4 137
Change drop down list in one cell based on values in other cells by Hemi
Hi, Can someone pls help. I want to update value in a drop down list based on selection in preceeding drop down list e.g. there is a list of 10 business...
November 18th, 2009 05:51 AM
by Hemi Go to last post
2 144
military time calculations by NedG
I am trying to write a program that tracks time entries in "Military time" and then average multiple entries, that cover a 24 hour cylcle for three shifts. ...
November 18th, 2009 05:31 AM
by David Biddulph Go to last post
2 138
Make Excel see columns as rows and rows as columns by Xane
Okay, I have a bit of a difficult problem. I'm using excel to make a map for a game I'm playing. I've already converted the columns to numbers as well,...
November 18th, 2009 05:24 AM
by David Biddulph Go to last post
5 113
trouble in copy pasting by Suri
HI, I was trying to copy the formula in one cell toanother. Eg: Copy formula "=T157*H157" in cell c5 in to cell C6. When i drag the formula from cell C5 to...
November 18th, 2009 04:06 AM
by Suri Go to last post
3 144
dividing a number into hours and minutes by ramona
My users are entering numbers into column B. Is it possible to take the total of column B (say Row X) and divide it into hours and minutes putting the hours...
November 18th, 2009 03:20 AM
by Tom Hutchins Go to last post
1 118
Lock sheets automatically by Thu Ng[_2_]
Hi everyone, I have 26 fortnightly timesheets in a workbook for every staff and would like to lock each timesheet after some days.Can you please help me to...
November 18th, 2009 02:16 AM
by JLatham Go to last post
2 103
Excel 2003 chart plots wierd on Excel 2007, time value x-axis by Tony Ozzello[_2_]
Hey all, just upgraded. I have a chart with multiple time value series going out many years, some of the series have data going into the future a while and...
November 18th, 2009 12:07 AM
by Tony Ozzello[_2_] Go to last post
0 136
Table formula optimization Question by urlocaljeweler
I have a spreadsheet (.csv) with 1600 products/rows and several columns. One of the columns that has the product descriptions also contains 1600 rows. In...
November 17th, 2009 11:23 PM
by urlocaljeweler Go to last post
0 142
Summary of data using array formula by Smitee2006
I have a spreadsheet where there are several columns with data using validation picklists as well as free-entry columns. I would like to create a summary of...
November 17th, 2009 10:55 PM
by Dave Peterson Go to last post
1 125
Move data from mulitple tabs to one sheet by Supe
I have about 60 tabs that have the item UPC, dollars, and units for 60 different vendors. Is there a way to move the data from these tabs onto one sheet...
November 17th, 2009 10:33 PM
by Herbert Seidenberg Go to last post
2 165
Data arranged in calender format by Chris
I'm being asked to summarize and show data in a calender view. Does anyone know how to accomplish this without having to copy and paste each time? Is there...
November 17th, 2009 09:59 PM
by Pete_UK Go to last post
1 148
Count if using multiple date criteria by GPearson
Hello: I am working on a spreadsheet that records inventory. I need to create a formula that counts if any items were completed late by a person . The...
November 17th, 2009 09:30 PM
by GPearson Go to last post
4 138
Auto sum 2 adjacent row data into 3rd row? by Tacrier
I have a list of people's names in column C and cost data for each person in column M and N. Is there was to provide a subtotal of all cost data for each...
November 17th, 2009 09:27 PM
by Sean Timmons Go to last post
1 106
TextToColumn when destination to other sheet by CG Rosen
God day Group, Is it at all possible to destinate the the split columns to another worksheet when using the TextToColumn wizard? Can it be made by code? When...
November 17th, 2009 09:10 PM
by CG Rosen Go to last post
4 105
will formulas be lost when moving data in a worksheet? by Renae
I have a P & L that contains 3 years of info. I have to delete the oldest year (2007) and put in our actual numbers for year ending 2010. Will I lose all of...
November 17th, 2009 09:00 PM
by David Biddulph Go to last post
7 83
Post New Thread


Display Options
Showing threads 9861 to 9880 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 01:36 PM.


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