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
Need help with formula by Donna
Hello all. How do you write a formula for cell K1 to read “PEDS” if the age in cell C1 is from 1 – 18? I don’t want PEDS to appear in K1 if C1...
June 11th, 2009 10:51 PM
by Gord Dibben Go to last post
2 145
How do I create a VERY complicated spreadsheet? by Kerri
We recently changed from Movex system to Dynamics system and the managers want to see a report exactly how they saw in the old system. I need to create a...
June 11th, 2009 10:42 PM
by Gord Dibben Go to last post
1 210
delete numbers in each cell in same column by Anna Huber
Is there an easy way to just delete the first two numbers in each cell all the way down the column? i.e. 123456789 to 3456789? Would I have to create a...
June 11th, 2009 10:33 PM
by RagDyer Go to last post
7 144
Pivot across several tabs by Tami
can you pivot across several tabs? i have a work sheet where the buyer plans a class 111 on tab 1, class 123 on tab2....and my buyers are very good at pivots...
June 11th, 2009 10:03 PM
by Tami Go to last post
2 166
Combo box selection will not calculate by Perrysbox2
I am using 3 combo boxes to select the year, month and day for a scheduling worksheet. Each combo box is linked to a cell which is 'named' accordingly. When...
June 11th, 2009 09:21 PM
by T. Valko Go to last post
1 144
What Formula to use? by Paul Chung
Hello everyone, I'm trying to figure out how to have excell show me a number based on the value of another cell. Here is the cell info: 1 1.0 0.999...
June 11th, 2009 09:08 PM
by Paul Chung Go to last post
6 142
How do I change date format m/d/yyyy to mmddyyyy toremove the dash by CyndiR
What is the formula to change the date format from m/d/yyyy to mmddyyyy to remove the dashes and have 2 digits for month, 2 digits for day and 4 digits for...
June 11th, 2009 08:52 PM
by David Biddulph Go to last post
3 120
Subtotals from Named Range on other worksheet by sgodschalk
I have a worksheet that holds all of our daily transactions over the last 5 years. Been using just basic Pivots and charts until now. But I need I need...
June 11th, 2009 08:51 PM
by Glenn[_6_] Go to last post
5 192
Importing by newbo
My posi installation used dBase 5 (only dBase 5) standard drivers. But the dbf files appear to be part of an export process? (I would guess--only a few hours...
June 11th, 2009 08:41 PM
by newbo Go to last post
0 108
VBA Converter for Excel 2007 by RBB
Does a VBA Converter exist for Excel 2007, and if it does, what is the direct link to download it?
June 11th, 2009 07:46 PM
by Dave Peterson Go to last post
1 167
Formula for rating results by Nadine
Look for a help creating a formula, if it possible, to find out the overall rating results example - first row going across lists all the options provided -...
June 11th, 2009 07:27 PM
by Nadine Go to last post
4 123
standings by Kashyap
Jean 06:52 Jackson 05:12 UmaU 00:00 Peter 05:36 Joseph 02:48 in the above table how to find out the standings of each? that...
June 11th, 2009 07:15 PM
by Justin Case[_2_] Go to last post
3 120
Using the "Count" function with filters? by Irv
I need to find a formula that counts the number of cells in a column that has data (text, &/or number), but the kicker is I need that number to change when I...
(Multi-page thread 1 2)
June 11th, 2009 06:55 PM
by icsonu Go to last post
13 211
Conditional Formatting Based on Due Dates by Morgimo
I want a stop light color to change from green, yellow, or red based on a specific number of days prior to the due date. For example: If A1 is the stoplight...
June 11th, 2009 06:15 PM
by Morgimo Go to last post
3 127
Summing data based on certain cells by MurrayBarn
I have a spreadsheet that has data for each month. At the bottom of each month is a summary of the data in four categories. What I need to do is for the data...
June 11th, 2009 05:46 PM
by RagDyeR Go to last post
4 114
Updating & Archiving Records by sandy
Hi, I am using Excel 2007. I have a large spreadsheet and new data is added periodically. I have several columns of data associated with a description &...
June 11th, 2009 05:43 PM
by sandy Go to last post
4 189
IF with #N/A by Rahim
I want to tell excel that IF A2 has "#N/A", AVERAGE (A1,A3), A2 but it don't work, any help is highly appreciated, thanks
June 11th, 2009 05:21 PM
by Shane Devenshire[_3_] Go to last post
3 145
SUMPRODUCT by PAL
I am using the formula below and it seems to work fine. As an array: =SUMPRODUCT(--('Enroll I'!$O$2:$O$2741="Regular"),--('Enroll...
June 11th, 2009 05:20 PM
by PAL Go to last post
4 121
Using Multiple Criteria to filter for multiple users by fgwiii
Earlier in the week someone was kind enough to provide me with the following code that allowed me to search for different numbers in a column and provide me...
June 11th, 2009 05:09 PM
by Luke M Go to last post
5 152
Conditional formatting from Dates by DavidM
Today's date will be manually entered in to a header cell. The worksheet contains the dates that customers last purchased from me. How can I change the colour...
June 11th, 2009 05:00 PM
by David Biddulph Go to last post
3 136
Post New Thread


Display Options
Showing threads 10201 to 10220 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 07:58 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.