| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
YEAR result from an ArrayFormula, or Query function
I have a date in column J [01/01/2019]
I need column AS to show JUST the 2019 Year, and I need (strongly want) a header that says "YEAR". I cant have the formula in the row 2 because of sorting. or can I? I don't want to drag a formula endlessly down... I would like an arrayFormula or Query solution. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup with an Arrayformula.... HELP! | Excel Discussion (Misc queries) | |||
| How do I crate a function for week of year + year in same cell. | Excel Worksheet Functions | |||
| CountA and ArrayFormula | Excel Worksheet Functions | |||
| Importing result from Access query to Excel but the result only c. | Excel Discussion (Misc queries) | |||
| Size of arrayformula with VBA | Excel Programming | |||
Threaded Mode
