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
Automatic filling of cells within a certain date range by Elor
Can someone please help, I have been stuck on this for the past two days... Column 'AB' has 'Start Date' and column 'AD' has 'Finish date' Row 19, cells 'AI'...
February 8th, 2010 03:44 PM
by Don Guillett[_2_] Go to last post
1 79
End/Beginning of Cell Search/Replace? by msnyc07
I find myself having to export data to word so I can do simple find/replace which I'd do in Word with ^p such as Find ^p(space key) Replace ^p (removes...
February 8th, 2010 03:37 PM
by Eduardo Go to last post
1 80
Excel autofit row height not working by Josafa
Question is on a problem I found posted in internet many times, with NO proper answer. Postings dates range at least from 2001 up to 2010. Text is not short,...
February 8th, 2010 03:05 PM
by Josafa Go to last post
0 136
excel duplicated a sheet. how do i delete one by math4mama
when i opened a workbook, excel duplicated it. i now have two workbooks that open at the same time numbered #1 and #2. when i close one, they both close....
February 8th, 2010 02:36 PM
by Dave Peterson Go to last post
3 111
vlookup to another worksheet by RobFJ[_3_]
I have a filled column in worksheet_1 called "Reference". I have another empty column in that worksheet, called "Data" that I want to populate with values...
February 8th, 2010 02:10 PM
by trip_to_tokyo[_3_] Go to last post
3 92
Count the number of hours/durations by Jafferi[_2_]
Cell A1 ---- Jan 1, 2010 Cell A2 ---- 10:58 Cell B1 ---- Jan 3, 2010 Cell B2 ---- 22:10 What is the formula that I can use to give me the results of no of...
February 8th, 2010 01:49 PM
by Bernd P Go to last post
3 93
Pivot Tables: Don't show data for detail, but still show subtotals by Lynndyhop
Hi there, Is it possible to show a pivot table with detail but have the data only show for the subtotals? I am trying to create a report that combines a...
February 8th, 2010 12:51 PM
by Lynndyhop Go to last post
3 127
best config by ekkeindoha
Good day, I would like to teach kids on money.Is there a formula that wil do the following. If I enter S35 it should give me a feedback of 1 x $20 , 1 X $10...
February 8th, 2010 12:04 PM
by Dana DeLouis Go to last post
2 78
sum cells containing text by edul
Hi. Can anyone help me please. I want to sum the values of certain cells, that contain numbers and text eg. cell B2 contains 32A cell B3 contains...
February 8th, 2010 04:09 AM
by edul Go to last post
0 79
Formula anomaly by Bob
Cell A1 is formatted as TEXT, and IF it contains either: 000000 (six zeros) OR the number 100000 through and including 999999 OR the number 100000 through and...
February 8th, 2010 03:03 AM
by Bob Go to last post
7 84
IF FUNCTION by Dee
I need to match criteria in two separte columns and then the third colum with be fixed text if the criteria matches eg A1= Yes and B1=Yes then C1(column with...
February 8th, 2010 02:50 AM
by Jacob Skaria Go to last post
1 77
Conditional formatting-Date range by smack
I am creating a spreadsheet which is a checklist for a shipping processs. At the top I key in customer name and date the shipping process starts- let say...
February 7th, 2010 11:53 PM
by OssieMac Go to last post
1 83
Perpetual 1st Wed by Keyrookie[_50_]
Hey all, What is the formula that always shows the 1st Wednesday of the month? I am wanting to have the date of the the first Wed. of the month always appear...
February 7th, 2010 10:57 PM
by Keyrookie[_51_] Go to last post
3 69
formula needed by aormonde
I am looking for a formula and this is really stumping me. I have a worksheet that has one column w a name and one w a date that of things given, since the...
February 7th, 2010 09:29 PM
by Don Guillett[_2_] Go to last post
6 70
lookup formula not picking up correct data by skeyesq
I using Excel 2003 to create a "Lookup" formula to calculate grade points and grade point averages. I want to insert the grade and have the grade converted...
February 7th, 2010 09:27 PM
by Gord Dibben Go to last post
2 87
Same Image appear on all sheets from first page single by Duane
Hello all! I am trying to create a basketball team tracking sheet. What I would like to be able to do is on the first page (where you will enter your team...
February 7th, 2010 08:25 PM
by Duane Go to last post
0 76
I want to change a "No" to a "Yes" i by Circuitman57
I have a work sheet that if on page 2 the cell says No, then on page 1 it says Yes and if on page 2 the cell is Yes then on page 1 it is No? What formula do...
February 7th, 2010 07:30 PM
by Russell Dawson Go to last post
3 87
Comparison Formula by Annie
Hi I need to learn how to compare two spreadsheets in Excel to identify differences between the two. For example, if I have one spreadsheet with a list of...
February 7th, 2010 06:58 PM
by Francis Go to last post
2 115
Time format shows default of 12:00 AM by Helene
I didn't see anything like this problem in the community questions. I downloaded the "timecard with breaks" template from the MS site. The time-in and...
February 7th, 2010 06:58 PM
by rr76012 Go to last post
6 86
Running Total Column by DisMusBeDaPlaz
Hello Group Excel, I am using Excel 2003. My computation Columns are "E" to "J". Column "I" is the Total. Column "J" is the Running Total.
February 7th, 2010 06:48 PM
by Lars-Åke Aspelin[_2_] Go to last post
1 77
Post New Thread


Display Options
Showing threads 3161 to 3180 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 04:13 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.