| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
4 SETS OF CRITERIA USED TO DISPLAY ANSWER
Hi
I have a list of dates in column C e.g. 01/10/2008 Column D equals the dates in column C and are formatted using the custom 'mmm' e.g. Oct What I need is a formaula in column E that shows If D1=Apr, May or Jun then the formula result displays "Q1" OR If D1=Jul, Aug or Sep then the formula result displays "Q2" OR If D1=Oct, Nov or Dec then the formula result displays "Q3" OR If D1=Jan, Feb or Mar then the formula result displays "Q4" The formaula will be copied down the column Thank you in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get the command sets to automatically display? | Excel Discussion (Misc queries) | |||
| Vlookup for 2 sets of Criteria (or do I need to use something else | Excel Discussion (Misc queries) | |||
| vlookup with 2 sets of criteria | Excel Discussion (Misc queries) | |||
| SUMIF with two sets of criteria | Excel Discussion (Misc queries) | |||
| Need to display 4 sets of data on one x-axis with 4 repeating y a. | Charts and Charting in Excel | |||
Threaded Mode
