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
RAND() by Charles W
I have posted this question in the wrong place, so here I am again. I want to generate a random number using RAND() in a cell. But the number generated by...
April 23rd, 2009 10:11 PM
by T. Valko Go to last post
9 223
Transpose columns into continuous rows by PattiP
I have a large table with the following columns: Date, DayOfWeek, Hour1, Hour2….Hour24: Date HE01 HE02 … ...
April 23rd, 2009 09:29 PM
by PattiP Go to last post
1 93
index and match on 2 criteria by Picman
I have a table that i want to extract data from one column based on 2 conditions in other columns. The table has 4 columns, the first and second are the...
April 23rd, 2009 09:08 PM
by Picman Go to last post
7 80
SUMPRODUCT - Creating a weighted score in column with subtotals by DP
Col A Col B Count Average Score Manual Calculation Single 0 - Single 1 5.00 Single 2 4.83 Single 2 4.00 Single 0 - Sub Total 5 ...
April 23rd, 2009 08:14 PM
by Bernie Deitrick Go to last post
3 76
Top 25 List of Times by thscc1659
I have a spreadsheet with the times run by individuals over a 3 year span. I've been able to create a Top 25 list out of those times, but am having trouble...
April 23rd, 2009 08:07 PM
by thscc1659 Go to last post
1 80
Lookup Question by Harlan
I'm creating a workbook with multiple sheets, that is to be semi-interactive. I have one sheet (CurrentYear) where I enter all of my information (P & L...
April 23rd, 2009 07:57 PM
by Harlan Go to last post
1 87
RANK ABSOLUTE NUMBER AND WITHOUT GAP by M&M[_3_]
The value that I need to rank include positive and negative number. I need to treat them all absolute value and also need to rank without gap. VALUE RANK...
April 23rd, 2009 07:44 PM
by Harlan Grove[_2_] Go to last post
3 80
If formula by Terrie Vargas
I have a project where I am having to report the number of lines, the total amount and the % based on 5 other criteria... Legend: ...
April 23rd, 2009 07:37 PM
by Terrie Vargas Go to last post
0 87
Duplex Printing Macro by [email protected]
I have created and set up a number of daily reports that mulitple users can generate from multiple work stations. All of the work stations are on the network,...
April 23rd, 2009 07:23 PM
by [email protected] Go to last post
0 89
Data Sort header row by inungh
I would like to have default Header Row checked when I click on Data Sort. Are there any option to set it? I got randomly sometimes checked Header Row, but...
April 23rd, 2009 07:21 PM
by Sheeloo Go to last post
1 101
Problem with Vlookup by Confused
I am using Vlookup to find names in one file and replace it with emails from another. The two names exist in both files but i get all #N/A . How can I...
(Multi-page thread 1 2)
April 23rd, 2009 07:20 PM
by Jacob Skaria Go to last post
10 122
conditional formula with lots of conditions by sarajane82
i am trying to develop a conditional formula. the spreadsheet is separated into sections, and in each 4-column section, there are 2 columns that contain...
April 23rd, 2009 07:02 PM
by Glenn[_6_] Go to last post
8 101
If - Then statement by Neall
I have a drop menu with part numbers, which I pull from another sheet, there are descriptions associated to those part numbers. What I want to do is on the...
April 23rd, 2009 06:51 PM
by Neall Go to last post
3 63
first and last occurance by Darius
in range a2:a3500 how to find the row number of first cell which its content value is less than 0.0 and last value which is less than 0.0? They can be set in...
April 23rd, 2009 06:49 PM
by Darius Go to last post
7 70
Transfer Information by Lois
hi i have 2 worksheets, when a new row of information is added to 1 worksheet, some of the details need to be transfered unto the next blank row of other. ...
April 23rd, 2009 06:45 PM
by Ron de Bruin Go to last post
4 74
Average function by Harriet
I am trying to create a daily average in a spreadsheet. Here is my situation. I have a row of sums of columns that I want to average. Data is filled into...
April 23rd, 2009 06:25 PM
by Jacob Skaria Go to last post
5 106
Multiple formulas in a single cell referencing a drop down box. by Sylvan06
I have a drop down box in A1 with 13 different items from another sheet (same workbook). I need a formula in E6 (for example) that says (in plain english for...
April 23rd, 2009 05:40 PM
by Sylvan06 Go to last post
3 120
Formula for Multiple Variables. by Sri Harsha[_2_]
Hi, I am preparing an estimation template. I have a source tables which have the estimated hours of effort and a table which gives options to select the...
April 23rd, 2009 05:28 PM
by macropod[_2_] Go to last post
1 71
SUMIF, wrong result, strange behaviour by Werner Rohrmoser
Hi, I have a found something strange, which I do not understand. Formula in A1: =SUMIF(D1:D3,C1,E1:E3) value in C1: 02016521000513438888 formatted as...
April 23rd, 2009 05:11 PM
by Dave Peterson Go to last post
5 84
Converting decimals to Time by Gringarlow
My data for work time is 1.1 1.017 etc... I need to convert this to 1:06 1:01 etc.. and have this data be used in a Pivot Table that shows the average time of...
April 23rd, 2009 05:07 PM
by Gringarlow Go to last post
4 87
Post New Thread


Display Options
Showing threads 11801 to 11820 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 12:28 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.