|
|
VLOOKUP by
Me
I nned help. I need to bring back the daily room charge into my main
worksheet from the look table. The lookup table is below. So depending on
the room...
|
|
1 |
104 |
|
|
|
|
1 |
138 |
|
|
IF + IF? by
RoadKill
Is there a way to combine the IF Statement. I will be using a similar formula
for six separate metrics so would be great if I didn't need to build a table...
|
August 29th, 2008 01:58 AM
by JMB
|
7 |
154 |
|
|
IF question by
Stuart
Hi,
Can someone help with the following conditional IF question please:
If value in C4 is numeric, then the formula for K4 is C4*J4 rounded to 2
places
or...
|
|
3 |
121 |
|
|
|
|
4 |
182 |
|
|
|
|
3 |
154 |
|
|
Offset formula by
Joe_Hunt
I've been trying to find an answer to a question I think I should know the
answer to with no luck. I hope someone can help me. I need to have a formula
change...
|
|
2 |
345 |
|
|
Calendar List to Calendar format by
Kristin
Please help! I have been asked to maintain a calendar which lists calendar
items and sorts them by item type on one sheet and then links those items to
a...
|
August 29th, 2008 12:20 AM
by Pete_UK
|
3 |
177 |
|
|
|
August 29th, 2008 12:04 AM
by Saylees
|
4 |
527 |
|
|
|
August 29th, 2008 12:02 AM
by Max
|
5 |
192 |
|
|
vlookup returning zeros by
Cobaum
I have a vlookup formula that I copied down a column. It works fine on 95%
of the values, but for some reason, right in the middle of the column it is...
|
August 28th, 2008 11:43 PM
by Max
|
5 |
117 |
|
|
Percentage formula needed by
MJM
I have not used Excel formulas for a while (need to take a refresher course)
but in the meantime I am in need of the formula that will calculate the...
|
August 28th, 2008 11:25 PM
by MJM
|
5 |
129 |
|
|
need help with a formula by
freeman
I have an excel file that looks like this.
Column A has a long list of names, many that repeat
Column B has a the following formula =COUNTIF($A$2:$A$7610,A2)...
|
|
8 |
122 |
|
|
#Missing by
Shirley
Hi,
I am using Hyperion Smart View - similar to excel.
The cells have formula which are suppose to be zero amounts, display
#Missing, instead of 0 or - ....
|
August 28th, 2008 10:22 PM
by JLatham
|
1 |
150 |
|
|
similar names - two spreadsheets by
jtkuehn
I have two spreadsheets. 1 has the names of new customers and 1 has names of
prospects. I want to figure out if a prospect became a customer, but the
names...
|
|
3 |
138 |
|
|
|
|
1 |
149 |
|
|
=SUMPRODUCT Col E = B, Col F = blank by
77Debbie77
I am using the formula below to try and get the total count of Col F when it
is blank (Col F is text data and some employees did not enter a comment) when...
|
|
7 |
148 |
|
|
|
|
5 |
124 |
|
|
|
|
2 |
143 |
|
|
weighted average by
elaine9412
Thanks for my previous help. Now I have the data and I need to do a weighted
average for different groups of data as follows:
group 1:
Total count 3 total...
|
|
6 |
113 |