|
|
nested if statements - multiple variables by
David Pelizzari
I am attempting to write an if statement to check values in two columns, and
return a value based on the two.
column A is difference between two dates (today...
|
|
2 |
164 |
|
|
what excel function to use by
MINAL ZUNKE
Hi All,
I have 2 excel workbook named A and B.
In workbook A, I have 4 worksheet 1, 2, 3, 4. In each worksheet (1,2,3,4)
under Column B are various part...
|
|
2 |
124 |
|
|
|
|
8 |
99 |
|
|
vlookup with different col_index_num by
ArcticWolf
Hi,
I have a vlookup which returns the value from a table called data. The
column I want from the table is column 3, so =vlookup(a1,data,3,false)
However,...
|
August 17th, 2009 11:46 AM
by Pete_UK
|
7 |
113 |
|
|
SUMPRODUCT Problem by
Freshman
Dear experts,
I've a table with 5 columns. Column B is for Departments and column E is for
floor levels.
HK1-P L13
QGE ...
|
|
2 |
111 |
|
|
|
|
1 |
100 |
|
|
conditional formatting on sales percentage by
Loadmaster
I require a formula that if cell A2 has the cost of buying clothes. Cell B2
has the cost when selling clothes. If the cost of A2 (selling the clothes) is
...
|
August 17th, 2009 03:11 AM
by Max
|
1 |
108 |
|
|
|
|
1 |
107 |
|
|
|
|
1 |
122 |
|
|
Offset a formula result by
Patrick C. Simonds
Is there any way to write a formula the puts the result as text in the cell
just to the left of the cell the formula is...
|
|
1 |
88 |
|
|
|
August 16th, 2009 07:06 PM
by Mea
|
4 |
110 |
|
|
|
August 16th, 2009 06:56 PM
by Ragdyer
|
4 |
134 |
|
|
|
|
1 |
226 |
|
|
Percentage according to Weightage by
Kash
I have the below table where Weightage is nuber of bookings a person can
action in one hour. '17' is the total that has been actioned in 8 hours.
I need to...
|
|
3 |
99 |
|
|
|
|
6 |
239 |
|
|
|
|
2 |
91 |
|
|
|
|
1 |
93 |
|
|
Date Update on New Page by
NichGrif
I would like to enter a date (not today's date) on Worksheet 1 and then
update it automatically on Worksheet 2.
Worksheet 1:
January 1, 2009
Worksheet...
|
August 16th, 2009 01:18 AM
by smartin
|
4 |
89 |
|
|
Coping Cross Tab Formulas by
Marty
I have a workbook that contains 1 tab for each day of the month and a status
tab that I want some of the info on the individual tabs to roll up to. On
the...
|
August 16th, 2009 12:42 AM
by Pete_UK
|
3 |
91 |
|
|
Need Help With Writing Concatenate Function by
Michael Styles[_2_]
Here is my Data:
A B C D E F
GRADE Teacher LN FN MN DOB
KK Cain FlintstoneFred Bam-Bam02/22/04
I need to concatenate LN, 1st letter of FN, 1st letter of MN,...
|
|
5 |
76 |