//pivot - unique records .
Sun, 24 Aug 2008 08:36:00 -0700
Hi !! I have a table like this :
Location Order Invoice Week
A 1 X1 20
A 1 Y1 20
B 2 X2 21
C 3 X3 22
C 3 Y3 22
C 3 Z3 22
C 4 X4 22
I want to ha ...
|
Sorted Data
Sun, 24 Aug 2008 10:29:45 -0400
I have columns that have quite a bit a bit of data in them and some of the
numbers are the same.. I would like to be able to find the number that
appears most often, then the second most appearing number and third, all the
way to the fifth most appearing number. I have been able to use "MODE" to
find the ...
|
Formula to enter names in a column specific # of times
Sun, 24 Aug 2008 07:02:01 -0700
Iâ??m using the following to produce a random picking of names in the B column.
=INDEX($B$1:$B$100,RAND()*100+1)
Each name is entered a different number of times in the B column, so that
the names entered the most have a higher probability if hitting.
What Iâ??d like to have is another cells/columns that will a ...
|
Excluding Repeating Numbers Help!1
Sun, 24 Aug 2008 04:23:57 -0700 (PDT)
Hi
1. From Cell A1:E1 random numbers from 1 to 13 gets inputed and gets
ranked then put in under A2:E2
i.e. any numbers from 1 to 13 can be inputed into A1,B1,C1,D1 and E1
e.g.if A1 = 2, B1 = 3, C1 = 1, D1 = 5, E1 = 6 then it becomes
A2 = 1, B2 = 2, C2 = 3, D2 = 5, E2 = 6
2. Sometimes Numbers repeat i ...
|
Autofill Question
Sun, 24 Aug 2008 02:43:49 -0700 (PDT)
Hi everyone,
I am having alot of difficulties trying to solve this problem.
Basically I am coding something in column A like this;
1. 11XXX (X being any number from 0 to 9 i.e.11001 till 11999)
2. X11XX (X being any number from 0 to 9 ) => this part I have a
problem. How do I fill in every possible comb ...
|
Search for tabs from a cell value
Sat, 23 Aug 2008 21:58:01 -0700
Dear Sir/Mdm,
Can anyone please advice how to search for a specific worksheet tab based on
a cell value (user input) on a worksheet.
Eg, I have 50 worksheets in 1 workbook.
Sheet1=Main Menu
Sheet2=Customer ID 1
Sheet3=Customer ID 2
Sheet4=Customer ID 3 and etc.
If I input a value say "Customer ID 45" ...
|
sumifs criteria
Sat, 23 Aug 2008 17:40:01 -0700
I am trying to sum data using the sumif function =SUMIF($A$1:$A$714,
"=396??.50", $B$1:$B$714)
(Criteria range, criteria, sum range)
The criteria range isan entire month of hourly timestamps and I am trying to
sum a specific time (ie 12:00 pm) for the entire month. I have tried
converting all of the dates ...
|
|
|
How do I use x as a variable in a sine function and then graph it
Sat, 23 Aug 2008 17:34:01 -0700
I need to graph the function y=2sin 0.5 PI x
But a) it wont recognise x
b) it wont graph a sine curve
Why? and how do I fix it? ...
|
Worksheet Functions
Sat, 23 Aug 2008 16:42:01 -0700
My simple formula referencing the value of another cell is written over by
that value when the value of the referenced cell is changed? This is a
strange question for me to ask because I have been working with excel for
over a decade and have never come across this before ...
|
CountIF or Sum IF Questin
Sat, 23 Aug 2008 15:46:01 -0700
How do I find out how many times Group 1,2,3 used each test?
Using Excel 2000
A B C D E F
Group Test Group Test 1 Test 2 Test 3
1 Test 1 1
2 Test 3 2
3 Test 2 3
1 Test 1
2 Test 3
3 Test 3
Thanks!!! ...
|
