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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
YEAR result from an ArrayFormula, or Query function
On Tuesday, 2 July 2019 04:24:40 UTC+1, wrote:
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. In cell AS2 enter =YEAR(J2) Hover over the bottom right corner of cell AS2 until you see the "+" fill handle. Double click the fill handle and it will automatically fill the formula down the column for you. Better still, if you could make the range that contains column As into a table (Insert Table) then anter your formula in As2 and it will automatically populate the other cells in column As, and also add the formula s you add any more rows. |
Reply |
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 |