| Recent Answers from Richard Roberts |
 |
2008-12-02 Excel Help: Steve Unfortunately VLOOKUP is the best function to use to find your client needs. And as you know vlookup finds the first occurance, and when there are more it ignores them. What you can do is...
|
2008-12-01 IF AND VLOOKUP Statement: Steven I am not exactly sure of the question, but here is the answer anyway. The formula would look like this. =IF(AND(A1>=A2:A7,A1<=B3:B7),VLOOKUP(A1,C3:C7,1,FALSE),"") What I don't understand...
|
2008-11-28 Reg Date Minus Time: Akhil The trick to working with time and dates is to use the same formatting and the same numerical basis with all the cells being used and input the data using the same format. If you enter a date...
|
2008-11-26 Scoring a network: Anson If I am reading your question correctly, you should be able to use the countif function to get the answer. The formula might look something like this--- =COUNTIF(A1:A50,"yes")/(COUNTIF(A1:A50...
|
2008-11-23 MAX and Conditional: Tisa I'm not sure I fully understand the question, but---- What I think is the question is resolved as follows" It is a bit difficult to combine the formulas that you need, so I use three formulas...
|
| More Answers for "Excel" |