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
I want to tally my sheet by Mr. Haney
Hi guys... I am looking for advice as to which function(s) to use he I have a sheet where I keep track of time put toward job tasks at work. I look...
April 23rd, 2009 12:24 AM
by Mr. Haney Go to last post
6 76
calculating percentage of year passed (for sales reports) by morneauja
I've figured out how to calculate the percentage of the month and quarter passed, but the options for calculating the percentage of the year passed have not...
April 22nd, 2009 11:59 PM
by PJFry Go to last post
1 55
Average a group of numbers within an date range. by sross
I have a spreadsheet that has tickets for an entire year. I have calculated a field that has the total number of days a ticket was open for each ticket. I...
April 22nd, 2009 11:16 PM
by sross Go to last post
4 55
Drop Down List by katiapro93
Hi, can anyone help Is there anyway I can create a drop down list on a form using data that is located in another workbook yet not have to open it everytime...
April 22nd, 2009 10:30 PM
by Gord Dibben Go to last post
2 51
Not Counting cells that have a formula with "" by Steve
I have a column of cells with a formulas that have =If(c4 0, "test", ""). This is the simple form, as there is a few if and countifs that can produce...
April 22nd, 2009 10:26 PM
by Steve Go to last post
6 50
Vlookup questions by Steve
Table (leftmost) must be in ascending order. Then is it correct that you cannot use the same table to look for a different value in a different column...
April 22nd, 2009 09:44 PM
by Steve Go to last post
4 185
Sumif based on criteria on another cell by Jane
I am trying to add values in one column, if another column meets a certain criteria. This is the formula I have come up with and it doesnt work. Please...
April 22nd, 2009 09:36 PM
by T. Valko Go to last post
3 73
I need a lookup function using range names! by Pam V
I have this huge data base that I have summarized in a pivot table with the month & year across the columns and the different places for the rows. The body...
April 22nd, 2009 09:29 PM
by Pam V Go to last post
0 89
Drop down list from another worksheet by Marysam67
I have created a drop down list from another workbook. When I pick a name from the drop down list I want to list the location also listed in the original...
April 22nd, 2009 09:22 PM
by Marysam67 Go to last post
0 46
Counting rows that meet multiple criteria by sabow71
I have a strength report that generates counts based on multiple criteria. The workbook has 2 sheets (Roster contains the personnel names and position...
April 22nd, 2009 09:20 PM
by sabow71 Go to last post
0 58
Using VLOOKUP to locate an answer in one of multiple columns by ksean
I am using the following formula to get an answer from a single column of a spreadsheet (column 2) =VLOOKUP(B3,Master!$R$3:$AP$4180,2,FALSE) Would you...
April 22nd, 2009 09:08 PM
by PJFry Go to last post
7 65
Conditional Formatting Using Min/Max by CE
Regarding Excel 2003, I want to indicate the min value in a non-contiguous range of cells. The data are located in cells G8, K8, O8, S8, W8, AA8 and each...
(Multi-page thread 1 2)
April 22nd, 2009 09:05 PM
by T. Valko Go to last post
10 91
EXCEL Pivot Table by Tovok
I work in education for a major city, handling complaints. My spreadsheet contains wellover 8000 lines of data, i need to isolate schools with x number of...
April 22nd, 2009 08:44 PM
by Tovok Go to last post
0 90
Worksheet is not calculating by David
Hi There, I have a worksheet using the following equation several hundred times. The worksheet is about 700 rows and pulling from 2 worksheets in the same...
April 22nd, 2009 08:40 PM
by David Go to last post
0 61
Hey all... I hope this comes across ok. I have a utility that exports data out to an Excel file (using Excel '03) via SQL statements. My query is fine and...
(Multi-page thread 1 2)
April 22nd, 2009 08:33 PM
by JG Go to last post
13 109
vlookup??? by Scott D[_2_]
I've studied a lot of post and can't find what i need so here goes. Forgive me if i missed it somewhere. sheet 1 contains the following data: A ...
April 22nd, 2009 08:24 PM
by Don Guillett Go to last post
4 87
Copying a column list from one sheet to another and repeating??? by simon
Hi Does anyone know how to copy a list of text in a column from one sheet and display it in another sheet but then continue to repeat the original list? I...
(Multi-page thread 1 2)
April 22nd, 2009 08:06 PM
by simon Go to last post
18 99
Duplicate data entries by Rich
What I am trying to accomplish is to copy all the duplicate data from one worksheet to another. I have five columns and I want to have the data transfered to...
April 22nd, 2009 08:02 PM
by Bernie Deitrick Go to last post
1 58
What function do I use by katiapro93
After I combined 2 columns to create 1 column that I can make a drop down list from can I have the list display my combined data from the combined column but...
April 22nd, 2009 07:40 PM
by katiapro93 Go to last post
0 52
MROUND by emz486
Hope someone can help but whenever I use the MROUND function the answer is always (#NAME?). Does this even when I copy the example from the help menu. Anyone...
April 22nd, 2009 07:40 PM
by T. Valko Go to last post
3 47
Post New Thread

Display Options
Showing threads 11861 to 11880 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 01:45 PM.

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