|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#3
06-02-2022, 10:19 AM
|
||||
|
||||
Office365 lets you do this; the formula
=sales.value/sales.Volume in cell C14 will spill the results down to cell C19. With earlier versions you should be able to select cells C14 to C19 and type in the same formula, but commit the formula to the whole selected range using Ctrl+Shift+Enter rather than the usual plain Enter. (I haven't checked this.) 
|
| Tags |
| defined name |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need to copy specific ranges column data as row data from one worksheet to another using excel VBA | ganesang | Excel Programming | 1 | 03-26-2020 06:18 AM |
 Word Error- 'the name in the end tag of the element must match the element type in the start tag'
|
Eaqox | Word | 6 | 07-25-2019 02:50 AM |
| 'the name in the end tag of the element must match the element type in the start tag' | NancyL218 | Word | 1 | 05-29-2018 03:18 PM |
| Auto-filter horizontally column wise on basis of date | shoaib1989 | Excel | 0 | 02-18-2016 11:16 PM |
| How to fetch data from one sheet to another with complete details and date wise as well | harisjawed86 | Excel Programming | 1 | 08-05-2014 09:10 PM |
Windows 10 
Office 2019
Threaded Mode