|
|
Lookup Help by
aeast50 - ExcelForums.com
I have a table that list names,club and stats for sporting
competition.
My problem is the stats are recieved with the name as - A.Name
as there are...
|
|
3 |
118 |
|
|
Repeating a formula across mulitple columns by
aebjeffrey
I am analyzing data from a measure with two scales. There are 8 total
questions in each measure. Answers from Respondent #1 will in column 1
in excel (rows a1...
|
|
1 |
80 |
|
|
Creating a new "record" by
aeddave
Is there any way to have pre-formatted controls and form items (drop-down and
check boxes) appear when a certain value is input into a cell?
What I am trying...
|
|
1 |
87 |
|
|
Automatic Drop Down List by
aeddave
I have a workbook with 4 sheets.
Sheet 1 Column A allows users to enter a location name
Sheet 2 Column B automatically creates a dynamic drop-down of the...
|
January 14th, 2008 03:40 PM
by JP[_5_]
|
3 |
101 |
|
|
Assign a date by
aeddave
Is there a way (preferably not with VBA) to assign a date to a new record
when a cell is a certain value? In this instance, when a particular cell
shows...
|
|
2 |
54 |
|
|
SUMIF? Question by
aeddave
I want to add the cells in column D, when their corresponding column A is a
specific label. For example,
Column A Column D
Blue ...
|
January 23rd, 2008 12:32 AM
by aeddave
|
7 |
77 |
|
|
Run time error '1004' by
aeddave
I assigned a recorded macro to an object. When clicked it sorts range
A12:A2500. It works fine until I turn on sheet protection. The range is not...
|
|
1 |
79 |
|
|
Automatically insert a line by
aeddave
Hi,
Is there a function or formula to automatically insert a new line in Excel.
In this instance, I have a spreadsheet with three sections (top to bottom). ...
|
April 23rd, 2009 01:09 PM
by JLatham
|
5 |
96 |
|
|
matrix to normalised table? by
aeg
i posted this previously but got lost in between other questions so here it
is again. i need to convert matrix looking spreadsheet to a normalised table
so i...
|
October 5th, 2004 07:55 AM
by aeg
|
2 |
104 |
|
|
|
February 25th, 2004 08:00 PM
by aeg42
|
2 |
425 |
|
|
Material List by
AEHNLE
Hi, I work for a small construction company and I am working on a material
list for jobs. What I need is a function that will go through the list and
remove...
|
September 21st, 2009 04:26 PM
by Pete_UK
|
6 |
87 |
|
|
|
|
1 |
88 |
|
|
Nested IF - Work Around for 7 nest Max by
AEICHEN
I have consecutive dates in column B and integers in column D. In column B,
there can be anywhere from 0 to 10 dates listed and in column D, there may or
may...
|
|
1 |
80 |
|
|
Excel Formula Help by
aejaz
Hello Group
i have this rather simple equation , but cant seem to figure out how
to write it in excel
x1=x2=x3=x4=x5=x6=x7=x8=x9=x10
These are just initial...
|
|
3 |
253 |
|
|
How do i write this formula in Excel? by
aejaz
Hello Group
I am resending this..i dont know why this post did not show up.
Anyways,i have this rather simple equation , but cant seem to figure
out how
to...
|
|
3 |
361 |
|
|
VLookup to join three + worksheets? by
Aekta
I have a workbook w/three different worksheets. They all contain a column
that has employee IDs each with the same heading. So the columns match, they
just...
|
|
1 |
60 |
|
|
|
|
3 |
73 |
|
|
formulahelp by
aem
Limited excel formula knowledge. Trying to create a formula based on a
dollar amount input to give you a specific output. I'm trying to use this in
a self...
|
|
2 |
65 |
|
|
|
June 16th, 2006 11:18 PM
by Elkar
|
1 |
61 |
|
|
|
July 28th, 2006 07:35 AM
by Biff
|
4 |
55 |